>inputs.
>
>Thanks,
>Hazarath.
>
>-Original Message-
>From: Xuefu Zhang [mailto:xzh...@cloudera.com]
>Sent: Monday, March 24, 2014 7:36 PM
>To: dev@hive.apache.org
>Subject: Re: hive partition questions
>
>I'm on latest trunk, as named above. 0.9 mig
I have tried Join but it's taking too much time. Thanks Zhang for your inputs.
Thanks,
Hazarath.
-Original Message-
From: Xuefu Zhang [mailto:xzh...@cloudera.com]
Sent: Monday, March 24, 2014 7:36 PM
To: dev@hive.apache.org
Subject: Re: hive partition questions
I'm on latest
nal Message-
> From: Xuefu Zhang [mailto:xzh...@cloudera.com]
> Sent: Monday, March 24, 2014 6:07 PM
> To: dev@hive.apache.org
> Subject: Re: hive partition questions
>
> I'm on latest trunk, and the following similar query worked for me:
>
> select * from test as X whe
Which trunk are you in, am in 0.9.
Thanks,
Hazarath.
-Original Message-
From: Xuefu Zhang [mailto:xzh...@cloudera.com]
Sent: Monday, March 24, 2014 6:07 PM
To: dev@hive.apache.org
Subject: Re: hive partition questions
I'm on latest trunk, and the following similar query worked f
tion
>
> Thanks,
> Hazarath.
>
> -Original Message-
> From: Xuefu Zhang [mailto:xzh...@cloudera.com]
> Sent: Monday, March 24, 2014 5:53 PM
> To: dev@hive.apache.org
> Subject: Re: hive partition questions
>
> You may try:
>
> select * from page_view as
#x27; 'max' '('
in expression specification
Thanks,
Hazarath.
-Original Message-
From: Xuefu Zhang [mailto:xzh...@cloudera.com]
Sent: Monday, March 24, 2014 5:53 PM
To: dev@hive.apache.org
Subject: Re: hive partition questions
You may try:
select * from page_view as PV1 where PV
ry .. select * from page_view where dt=(select max(dt) from
> page_view)..i tried this but its failing with syntax.
>
> Thanks,
> Hazarath.
>
> -Original Message-
> From: Xuefu Zhang [mailto:xzh...@cloudera.com]
> Sent: Monday, March 24, 2014 3:21 PM
> To: dev@hive.a
...@cloudera.com]
Sent: Monday, March 24, 2014 3:21 PM
To: dev@hive.apache.org
Subject: Re: hive partition questions
As far as I know, select * from table gives you all data across all partitions,
and I don't think there is a config option to ask Hive to read "latest"
partition.
-
As far as I know, select * from table gives you all data across all
partitions, and I don't think there is a config option to ask Hive to read
"latest" partition.
--Xuefu
On Mon, Mar 24, 2014 at 12:34 PM, Darapaneni, Hazarath
wrote:
> Hi Team,
>
>
> I have a scenario that I need help from you g