create external table if not exists test.test_uid(
  uid int)
partitioned by (year string, month string, day string, hour string, domain string)
stored as orc
location '/user/sqoop/resty_by_domain'
tblproperties ('orc.compress'='SNAPPY');