[
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)
