[HIVE-10400] CBO (Calcite Return Path): Exception when column name contains dot or colon characters

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Fix Version/s: 1.2.0
• Component/s: CBO
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 20/Apr/15 14:54
• Updated: 27/Feb/24 22:23
• Resolved: 20/Apr/15 21:57

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;