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)

Reply via email to