VfZWQpJQ

1/logs/
2      2018-01-01
3      2018-01-02 
4      ....
5	
6CREATE EXTERNAL TABLE IF NOT EXISTS athenaplay.play(
7    ...columns...
8) PARTITIONED BY (
9    dt string 
10) ...Other options
11	
12Partitions not in metastore: user_conn:2018-02-01......a whole list of partitions....
13	
14select * from play where cast(dt as date) > cast('2018-02-01' as date) limit 100;