Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-9132 CBO: Calcite Operator To Hive Operator (Calcite Return Path)
  3. HIVE-10400

CBO (Calcite Return Path): Exception when column name contains dot or colon characters

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.2.0
    • 1.2.0
    • CBO
    • None

    Description

      If return path is on, this query produces the problem:

      select cbo_t3.c_int, c, count(*)
      from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1
      where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)
      group by c_float, cbo_t1.c_int, key order by a) cbo_t1
      join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2
      where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)
      group by c_float, cbo_t2.c_int, key order by q/10 desc, r asc) cbo_t2 on cbo_t1.a=p
      join cbo_t3 on cbo_t1.a=key
      where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0)
      group by cbo_t3.c_int, c order by cbo_t3.c_int+c desc, c;
      

      Attachments

        1. HIVE-10400.patch
          0.7 kB
          jcamachorodriguez

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            jcamacho Jesús Camacho Rodríguez Assign to me
            jcamacho Jesús Camacho Rodríguez
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment