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

[Akash R Nilugal (Jira)]

Ajantha Bhat created CARBONDATA-3452:
----------------------------------------

             Summary: 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


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
(v7.6.3#76005)