Thanks Noam.
As we are doing this via oozie, it will be either EL Action of something
else
I will just get around with a temp table and do a join with temp table with
date column
On Thu, Aug 20, 2015 at 5:27 PM, Noam Hasson
wrote:
> I observed in other situation, when ever you run queries where
I observed in other situation, when ever you run queries where you don't
specify statistics partitions, Hive doesn't pre-compute which one to take
so it will take all the table.
I would suggest implementing the max date by code in a separate query.
On Thu, Aug 20, 2015 at 12:16 PM, Nitin Pawar
any help guys ?
On Thu, Aug 13, 2015 at 2:52 PM, Nitin Pawar
wrote:
> Hi,
>
> right now hive does not support the equality clause in sub-queries.
> for ex: select * from A where date = (select max(date) from B)
>
> It though supports IN clause
> select * from A where date in (select max(date) f
