Hi All,
One of my Teradata query is
SUBSTR(PRESG_ID,INDEX(PRESG_ID,' ')+1,1) IN ('1','2','3')
Any idea of the above to convert to hive, It seems to be a simple qus but
am stuck...didn't get a chance to try it out in cluster :(
-Thanks
Hi Experts,
I'm working with Teradata query conversion to hive environment (Hive
version 0.10.0).The challenge that am facing here is in converting the
below line in query.
In SELECT clause:
ROW_NUMBER() OVER (PARTITION BY CLMST_KEY2
ORDER BY COUNTER) AS CLMST_ORDR_NBR
When searched found like
rk; second, optimize.
>
> Robin
>
> From: dyuti a
> Reply-To: "user@hive.apache.org"
> Date: Friday, June 28, 2013 12:05 PM
> To: "user@hive.apache.org"
> Subject: Re: Need urgent help in hive query
>
> Hi Robin,
> Thanks for your reply. H
Hi Experts,
I'm working with Teradata query conversion to hive environment (Hive
version 0.10.0).The challenge that am facing here is in converting the
below line in query.
In SELECT clause:
ROW_NUMBER() OVER (PARTITION BY CLMST_KEY2
ORDER BY COUNTER) AS CLMST_ORDR_NBR
When searched found like
query on that, then drop the temporary table.
>
> Robin
>
> From: dyuti a
> Reply-To: "user@hive.apache.org"
> Date: Friday, June 28, 2013 10:54 AM
> To: "user@hive.apache.org" , Michael Malak <
> michaelma...@yahoo.com>
> Subject: Re: Fwd
Hi Michael,
Thanks for your help, is there any other possible options apart from this.
On Fri, Jun 28, 2013 at 10:33 PM, Michael Malak wrote:
> Just copy and paste the whole long expressions to their second occurrences.
>
> --
> *From:* dyuti a
Hi Experts,
I'm trying with the below SQL query in Hive, which does not support column
alias access in subsequent columns as shown below in the query. Is there
any other way to rewrite the same without using alias? any of your help are
really appreciated.
INSERT INTO CAUD
(
pst_cc
pst_no
group by fdc_client_id,receive_dd,receive_hh,receive_hh+1;
>
>
>
> On Tue, Oct 30, 2012 at 1:51 AM, dyuti a wrote:
> > Hi All,
> >
> > I want to perform (No.of .approvals in an hour/No.of transactions in that
> > hour)*100.
> >
> > //COUNT(1) AS cn
_day=7
> ORDER BY start_time;
>
> On Mon, Oct 22, 2012 at 4:41 PM, dyuti a wrote:
> > Hi all,
> > I have a hive table with 235 million records.
> >
> > SAMPLE INPUT:
> > receive_yearreceive_day receive_hour client
> > 2012
