Xuebin Su created IMPALA-14927:
----------------------------------
Summary: Different but compatible types are not supported in the
UNPIVOT clause
Key: IMPALA-14927
URL: https://issues.apache.org/jira/browse/IMPALA-14927
Project: IMPALA
Issue Type: Bug
Reporter: Xuebin Su
For example, if we run the following query
{code:java}
with t1 (a, v1, v2) as (
values (1, 2, 3.0)
)select * from t1 unpivot (
c for b in (v1 as 'v1', v2 as 'v2')
) as t; {code}
we will get an error like
{code:java}
AnalysisException: Columns in the UNPIVOT clause should have the same type
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)