Skip to content

Instantly share code, notes, and snippets.

@milindjagre

milindjagre/post31.sql

Created June 21, 2017 21:22
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/89868690e71e0b81577b54f74cbfc34b to your computer and use it in GitHub Desktop.
Save milindjagre/89868690e71e0b81577b54f74cbfc34b to your computer and use it in GitHub Desktop.
Download ZIP
this SQL file is used for creating the Hive Partitioned table post31
Raw
post31.sql
create table post31 (
id int,
name string,
gender string
)
partitioned by (year int, month int)
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