Skip to content

Instantly share code, notes, and snippets.

@woodrad

woodrad/test.hive

Created January 22, 2015 18:57
Show Gist options
  • Save woodrad/a9975828ad46c5960114 to your computer and use it in GitHub Desktop.
Save woodrad/a9975828ad46c5960114 to your computer and use it in GitHub Desktop.
Download ZIP
test.hive
Raw
test.hive
ADD JAR ~/csv-serde/target/csv-serde-1.1.2-0.11.0-all.jar;
CREATE EXTERNAL TABLE IF NOT EXISTS test (test1 STRING, test2 STRING, test3 STRING, test4 STRING)
ROW FORMAT SERDE 'com.bizo.hive.serde.csv.CSVSerde'
STORED AS TEXTFILE
LOCATION ‘~/csv-serde/blah';
SELECT * FROM test;
DROP TABLE test;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment