Uploaded image for project: 'CarbonData'
  1. CarbonData
  2. CARBONDATA-3452

select query failure when substring on dictionary column with join

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.6.1
    • Component/s: None
    • Labels:
      None

      Description

      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

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Ajantha_Bhat Ajantha Bhat
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 13h 20m
                13h 20m