Hi Community. I would like to create an external table on top of these hdfs files with parition year, month and day, is there a possible to create one table on top of these files
/tmp/account=aaaa/year=2018/month=01/day=01 /tmp/account=aaaa/year=2018/month=01/day=02 /tmp/account=bbbb/year=2018/month=01/day=01 /tmp/account=bbbb/year=2018/month=01/day=02 Creating a table with: PARTITIONED BY ( year INT, month INT, day INT ) STORED AS PARQUET LOCATION '/tmp' Is not working for me. Adding the account to the partition creatng me millions of partitions and i want to avoid this, in the background i have a compaction job that compact the small files under the parition day. -- Take Care Fawze Abujaber
