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

    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

          People

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

            Dates

              Created:
              Updated:
              Resolved: