· 8 years ago · Mar 07, 2018, 06:46 AM
1create external table if not exists test.test_uid(
2 uid int)
3partitioned by (year string, month string, day string, hour string, domain string)
4stored as orc
5location '/user/sqoop/resty_by_domain'
6tblproperties ('orc.compress'='SNAPPY');