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 hadoop.hiv...@gmail.com 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

Re: Fwd: Need urgent help in hive query

2013-06-28 Thread dyuti a
a hadoop.hiv...@gmail.com *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