to:mahender.bigd...@outlook.com]
Sent: Wednesday, May 11, 2016 4:03 AM
To: user@hive.apache.org
Subject: Hive cte Alias problem
Hi,
I see peculiar difference while querying using CTE where I'm aliasing one of
column in table to another column name in same table. Instead of getting values
of
Hi,
I see peculiar difference while querying using CTE where I'm aliasing
one of column in table to another column name in same table. Instead of
getting values of source column, hive returns NULLS i.e column 8 values
withcte_temp as
(
select a.COLUMN1, a.Column2,a.Column2 asColumn8,ID
fr
