| #!/bin/bash | |
| temp_file=/tmp/pyhive_test_data_many_rows.tsv | |
| seq 0 9999 > $temp_file | |
| hive -e " | |
| DROP TABLE IF EXISTS many_rows; | |
| CREATE TABLE many_rows ( | |
| a INT | |
| ) PARTITIONED BY ( | |
| b STRING | |
| ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE; | |
| LOAD DATA LOCAL INPATH '$temp_file' INTO TABLE many_rows PARTITION (b='blah'); | |
| " | |
| rm -f $temp_file |