...

1. Download and unzip the following dataset: Dataset-HiveExampleData.

2. Store the dataset in the following example directory: 

   Code Block
   /tmp/hiveTest_5mb

   
   

3. Use the following command to create your table:

   Code Block
   create table test (name string, id bigint, id2 bigint, randomName string, description string, dob string, title string, corp string, fixedOne bigint, fixedTwo int) row format delimited fields terminated by ',' STORED AS TEXTFILE;

   
   

4. Add the example dataset to the above test table:

   Code Block
   load data local inpath '/tmp/hiveTest_5mb' into table test;

   
   

...