[jira] [Created] (IMPALA-7027) Multiple Cast to Varchar with different limit fails with "AnalysisException: null CAUSED BY: IllegalArgumentException: "

["Meenakshi (JIRA)" <ji...@apache.org>]

Meenakshi created IMPALA-7027:
---------------------------------

             Summary: Multiple Cast to Varchar with different limit fails with "AnalysisException: null CAUSED BY: IllegalArgumentException: "
                 Key: IMPALA-7027
                 URL: https://issues.apache.org/jira/browse/IMPALA-7027
             Project: IMPALA
          Issue Type: Bug
          Components: Clients
    Affects Versions: Impala 2.9.0
            Reporter: Meenakshi


If we have multiple cast of '' to varchar statements in a impala query which has a distinct like below, the query breaks for scenario when the cast to varchar limit in the SQL is lower than the previous cast.

 

 Query 1> Fails with " AnalysisException: null CAUSED BY: IllegalArgumentException: targetType=VARCHAR(100) type=VARCHAR(101)"

SELECT DISTINCT CAST('' as VARCHAR(101)) as CLAIM_COMMENTS,CAST('' as VARCHAR(100))  as CA_USER_ID FROM pinnga1ph_ds_prd_wh_gbd.concept_flat_dtl limit 1

Where as the below query succeeds

Query 2> Success

 SELECT DISTINCT CAST('' as VARCHAR(100)) as CLAIM_COMMENTS,CAST('' as VARCHAR(101))  as CA_USER_ID FROM  pinnga1ph_ds_prd_wh_gbd.concept_flat_dtl limit 1

The Query succeeds is we remove the distinct clause or add set enable_expr_rewrites=false;



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)