droptableetl_adn_clever_daily;CREATEEXTERNALTABLEetl_adn_clever_daily(device_idstringcomment'device id, gaid or idfa',device_typestringcomment'device type idfa gaid',platformstringcomment'platform:ios|android',modelstringcomment'model',brandstringcomment'brand',package_namestringcomment'package name')PARTITIONEDBY(`date`string)rowformatdelimitedFIELDSTERMINATEDBY'\t'STOREDASORClocation's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/etl_adn_clever_daily/';