Hi, I am trying to use Hive parquet stored files partitioned by some column. So, the directory structure is partitioned with the column.
The column is actually year. Let's say there are 5 years, so dir0 are like year=2010, year=2011,year=2012,year=2013,year=2014 We did like following select * from dfs.root.`/user/hive/warehouse/table` d where d.dir0 = 'year=2012'; I get nothing. Apparently, there are parquet files in the directory though. Sometimes it picks up e.g., year=2010, but not year=2012.. Where am I going wrong with this? Thanks, Sungwook
