Hi, I've had a look through the Wiki but couldn't see anything- is there a good (performant) way to check whether a partition exists for a table?
For example, let's say I have a table that stores Ad Impressions and these are partitioned for various countries/regions and by date. We have some other applications that consume data from Hive and I'd like to check that the data's been loaded before we attempt to run anything (that way we can defer for a few minutes and check again later). I was wondering whether there was anything like a SELECT PARTITIONS FROM table_name WHERE region = 'us' and dated = '2010-01-01' that I could use, or, whether some other statement would avoid kicking off a MapReduce job. Thanks, Paul
