Skip to content

Instantly share code, notes, and snippets.

@velotiotech
Created January 19, 2022 07:34
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 velotiotech/0d94d7bdb1df0114d52f80b9288ab87f to your computer and use it in GitHub Desktop.
Save velotiotech/0d94d7bdb1df0114d52f80b9288ab87f to your computer and use it in GitHub Desktop.
create table GameReviews(
reviewerID string,
asin string,
reviewerName string,
helpful array<int>,
reviewText string,
overall int,
summary string,
unixReviewTime int,
reviewTime string
)
row format serde 'org.apache.hive.hcatalog.data.JsonSerDe'
stored as textfile;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment