Skip to content

Instantly share code, notes, and snippets.

@monimiller

monimiller/create_hive_table.md

Last active May 3, 2022 19:58
Show Gist options
  • Save monimiller/8376a5949a49adab4f59dc7a7a415c5d to your computer and use it in GitHub Desktop.
Save monimiller/8376a5949a49adab4f59dc7a7a415c5d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create_hive_table.md 
CREATE TABLE events (   
  id number,    
  day_id varchar,   
  other columns… )  
WITH (   
  type=’hive’,    
  format=’parquet’,    
  partitioned_by=array[’day_id’] 
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment