Unlike in relational database systems like SQL Server, the ISNULL function works in a different way in Apache Hive. In SQL Server, ISNULL(col1, 0) returns
Executing Hive Query From Terminal
The aim of this post is to let you know how to execute a Hive query from command line (terminal) to fetch the records from
Apache Hive – Store & Access Nested Values – Complex Data Types- Part-1
This is going to be a series of articles to discuss about complex data types that are available in Apache Hive. There will be too
WORD COUNT IN Apache Pig
Pig is a high-level scripting language used in Apache Hadoop. Pig allows to write dynamic data transformations without the awareness of Java. Pig’s basic SQL-like
LOADING Tab Delimited DATA using APACHE PIG
The below example will let you know how to load the comma separated values in Apache Pig. Let’s consider the popular Emp data. OracleEmpData.csv7839 KING
Loading comma separated data using Apache Pig
The below example will let you know how to load the comma separated values in Apache Pig. Let’s consider the popular Emp data.OracleEmpData.csv7839,KING,PRESIDENT,0,1981-11-17,5000,0,107698,BLAKE,MANAGER,7839,1981-05-01,2850,0,307782,CLARK,MANAGER,7839,1981-09-06,2450,0,107566,JONES,MANAGER,7839,1981-02-04,2975,0,207788,SCOTT,ANALYST,7566,1987-07-13,3000,0,207902,FORD,ANALYST,7566,1981-12-03,3000,0,207369,SMITH,CLERK,7902,1980-12-17,800,0,207499,ALLEN,SALESMAN,7698,1981-02-20,1600,300,307521,WARD,SALESMAN,7698,1981-02-22,1250,500,307654,MARTIN,SALESMAN,7698,1981-09-28,1250,1400,307844,TURNER,SALESMAN,7698,1981-08-09,1500,0,307876,ADAMS,CLERK,7788,1987-07-13,1100,0,207900,JAMES,CLERK,7698,1981-12-03,950,0,307934,MILLER,CLERK,7782,1982-01-23,1300,0,10 You can
Big Data & SQL 