· 8 years ago · Aug 18, 2018, 10:34 AM
1How to get Hive working with bz2 ?
2CREATE TABLE IF NOT EXISTS image_bzip (
3 image_id STRING,
4 image_feature STRING,
5 other_stuff STRING)
6ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE LOCATION '/hivestore/bzip';
7
8LOAD DATA LOCAL INPATH '/nfs/directory/*.bz2' OVERWRITE INTO TABLE image_bzip;