Re: Fwd: Need urgent help in hive query

2013-06-28 Thread dyuti a
> *To:* user@hive.apache.org > *Sent:* Friday, June 28, 2013 10:58 AM > *Subject:* Fwd: Need urgent help in hive query > > 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. I

Re: Fwd: Need urgent help in hive query

2013-06-28 Thread Michael Malak
Just copy and paste the whole long expressions to their second occurrences. From: dyuti a To: user@hive.apache.org Sent: Friday, June 28, 2013 10:58 AM Subject: Fwd: Need urgent help in hive query Hi Experts, I'm trying with the below SQL query in

Fwd: Need urgent help in hive query

2013-06-28 Thread 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