Hive Basics for Begginers #2

11. Loading the multi-delimiter data into hive table
       There are four steps that I follow to load this kind of data    
       a)  Creating a single column table in hive
           hive> create table multi_temp(content String);         

        b) Loading data from local file system to the hive single column table.

       c) Creating the deired table in hive 
     

        d)  Loading the data from single column table to the desired table 
         

12. Loading XML data into hive table.
  We can use the same four step approach that we have used for the multi-deimiter data of which the first three steps are same.
4. Loading data from single column data to the desired table.

   Till now we have executed all the queries performed operations in hive terminal. We can also do this by writing a script and executing it from local terminal.

13. Loading nested XML data into hive table.





14. Creating and Executing Hive Scripts.
    a) creating the hive script
   

     b) Executing the hive script.