Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


  1. Download and unzip the following dataset: Dataset-HiveExampleData.
  2. Store the dataset in the following example directory: 

    Code Block

  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;