Generate Data: for i in `seq 1 10000`; do echo "$i,$i,$i,Case 1,Case 2" >> /tmp/data.txt; done Create a table in Hive: create external table TABLE_A (COLUMNA STRING, COLUMNB STRING, COLUMNC STRING,COLUMND STRING,COLUMNE STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','; Upload the file generated to Hive: hadoop fs -put /tmp/data.txt