Skip to content

Instantly share code, notes, and snippets.

@milindjagre

milindjagre/post40.sql

Created August 6, 2017 19:43
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/72e6aa8bb602298b26d4fdc671f2d927 to your computer and use it in GitHub Desktop.
Save milindjagre/72e6aa8bb602298b26d4fdc671f2d927 to your computer and use it in GitHub Desktop.
Download ZIP
this SQL file is used for creating the Hive table to load the data from the SELECT query
Raw
post40.sql
create table post40 (
id int,
name string,
gender string
)
row format delimited
fields terminated by ','
stored as textfile;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment