In this post , we will learn how to parse XML file using hive. I am using below xml file for this example. jmdbks@hadoop:~$ cat test.xml <test><name>Sumit Kumar</name><properties><age>29</age><sex>male</sex></properties></test> <test>..
(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>. beauty2955@hadoop:~$ ca..
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: 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..
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..
Avoiding Black Hat SEO is a strong choice for longer website Values. Going White Hat Way is a long term process and you have to stick with it only. Trying illegal things to rank higher quickly is a sudden death with respect to long term investment, that is White Hat. Black Hat SEO is as dange..
First 30 days of blogging honestly takes a lot of heart and guts. And it goes to worst if you are a working person. The working people have save time to do blogging. Blogging is not like writing anything without any focus. You have to think many time before writing a high quality blog. ..
There are many factors that needs your concentration and those will help you to build your website and brand with authority. We have covering all the things that is important in optimizing the website. You will enjoy this best practices SEO checklist greatly. We have divided the SEO C..