Hadoop Tutorial

Important built-in function in Hive

(I)explode() and posexplode():- explode() takes in an array (or a map) as an input and outputs the elements of the array (map) as separate rows. Below example will help to understand explode() better. 1)Create example data set that having only one column  as Array<int>. sumit2955@hadoop:~$ cat..

Date function in hive

1)from_unixtime: This function converts the number of seconds from unix epoch (1970-01-01 00:00:00 UTC) to a STRING that represents the TIMESTAMP of that moment in the current system time zone in the format of “1970-01-01 00:00:00”. The following example returns the current date including the time...

Hive Installation

Hive installation: 1.) search for apache hive-2.2.0 bin in google and download zar file (latest bin.tar.gz file) http://www-eu.apache.org/dist/hive/hive-2.2.0/ e.g. :- apache-hive-2.2.0-bin.tar.gz or download hive from linux command as below:-- wget http://www-eu.apache.org/dist/hive/hive-2.2.0/apac..

Big Data: Frequently used HDFS commands in Real Time

HDFS commands 1)mkdir (Create a directory) hadoop fs –mkdir  /data 2)copyFromLocal(Copy a file or directory from Local to HDFS) If we want to copy file1 from local to HDFS inside directory /data then we have to use below command hadoop fs –copyFromLocal file1  /data/     Note: Can be used..

Planet Polaris

Website Support
website support at Planet Polaris