Skip to content

Instantly share code, notes, and snippets.

@milindjagre

milindjagre/post32.sql

Created June 26, 2017 11:50
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/d7f1e724672472fd5ce133e895fd8493 to your computer and use it in GitHub Desktop.
Save milindjagre/d7f1e724672472fd5ce133e895fd8493 to your computer and use it in GitHub Desktop.
Download ZIP
this SQL file is used for creating hive bucketed table post32
Raw
post32.sql
create table post32 (
id int,
name string,
gender string
)
clustered by (id) into 4 buckets
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