Skip to content

Instantly share code, notes, and snippets.

@milindjagre

milindjagre/post34.sql

Created July 3, 2017 13:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save milindjagre/d286e766e836aa288ee2e058569e749c to your computer and use it in GitHub Desktop.
Save milindjagre/d286e766e836aa288ee2e058569e749c to your computer and use it in GitHub Desktop.
Download ZIP
this SQL file is used for creating the hive internal table with ORC as the input format
Raw
post34.sql
create table post34 (
id int,
name string,
gender string
)
row format delimited
fields terminated by ','
stored as orc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment