Hi Sungwook, In your where clause, you only need to say year=2012. The directory column (e.g., dir0) is used when users query a directory.
> On Aug 23, 2015, at 7:07 AM, Sungwook Yoon <[email protected]> wrote: > > 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
