Jesus Camacho Rodriguez created HIVE-23229:
----------------------------------------------
Summary: CAST to string on column instead of simplification over
literal column
Key: HIVE-23229
URL: https://issues.apache.org/jira/browse/HIVE-23229
Project: Hive
Issue Type: Improvement
Components: CBO
Reporter: Jesus Camacho Rodriguez
After HIVE-23100 went in, we end up for one of the queries with CAST over a
column instead of applying CAST on literal and comparing in CHAR, which can be
seen in ql/src/test/results/clientpositive/in_typecheck_char.q.out .
{code}
filterExpr: (((s = 'a') and (t = 'a ')) or (null and (t =
'bb '))) is null (type: boolean)
{code}
was replaced by:
{code}
filterExpr: (((CAST( s AS STRING) = 'a') and (CAST( t AS STRING) =
'a')) or (null and (CAST( t AS STRING) = 'bb'))) is null (type: boolean)
{code}
Probably this is as a result of the changes introduced in HIVE-23100 wrt IN
handling.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
