[jira] [Updated] (CARBONDATA-3452) select query failure when substring on dictionary column with join

[Akash R Nilugal (Jira)]

     [ https://issues.apache.org/jira/browse/CARBONDATA-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ajantha Bhat updated CARBONDATA-3452:
-------------------------------------
    Fix Version/s: 1.6.1

> select query failure when substring on dictionary column with join
> ------------------------------------------------------------------
>
>                 Key: CARBONDATA-3452
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-3452
>             Project: CarbonData
>          Issue Type: Bug
>            Reporter: Ajantha Bhat
>            Priority: Major
>             Fix For: 1.6.1
>
>          Time Spent: 13h 20m
>  Remaining Estimate: 0h
>
> h1. select query failure when substring on dictionary column with join
> "select a.ch from (select substring(s1,1,2) as ch from t1) a join t2 h on (a.ch = h.t2)"
> problem: select query failure when substring on dictionary column with join.
> cause: when dictionary include is present, data type is updated to int from string in plan attribute. so substring was unresolved on int column. Join operation try to reference this attribute which is unresolved.
> solution: skip updating datatype if dictionary is included in the plan
>  

--
This message was sent by Atlassian Jira
(v8.3.4#803005)