[
https://issues.apache.org/jira/browse/HIVE-23229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jesus Camacho Rodriguez updated HIVE-23229:
-------------------------------------------
Target Version/s: 4.0.0
> 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
> Priority: Major
>
> 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)
