[ https://issues.apache.org/jira/browse/HIVE-24094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
zhaolong updated HIVE-24094: ---------------------------- Attachment: image-2020-09-04-10-59-36-780.png > cast type mismatch and use is not null, the results are error if cbo is true > ---------------------------------------------------------------------------- > > Key: HIVE-24094 > URL: https://issues.apache.org/jira/browse/HIVE-24094 > Project: Hive > Issue Type: Bug > Components: CBO > Affects Versions: 3.1.0 > Reporter: zhaolong > Priority: Major > Attachments: image-2020-08-31-10-01-26-250.png, > image-2020-08-31-10-02-39-154.png, image-2020-09-04-10-54-43-141.png, > image-2020-09-04-10-56-00-764.png, image-2020-09-04-10-56-07-286.png, > image-2020-09-04-10-59-36-780.png > > > 1.CREATE TABLE IF NOT EXISTS testa > ( > SEARCHWORD STRING, > COUNT_NUM BIGINT, > WORDS STRING > ) > ROW FORMAT DELIMITED FIELDS TERMINATED BY '\27' > STORED AS TEXTFILE; > 2.insert into testa values('searchword', 1, 'a'); > 3.set hive.cbo.enable=false; > 4.SELECT > CASE > WHEN CAST(searchword as bigint) IS NOT NULL THEN CAST(CAST(searchword as > bigint) as String) > ELSE searchword > END AS WORDS, > searchword FROM testa; > !image-2020-08-31-10-01-26-250.png! > 5.set hive.cbo.enable=true; > 6.SELECT > CASE > WHEN CAST(searchword as bigint) IS NOT NULL THEN CAST(CAST(searchword as > bigint) as String) > ELSE searchword > END AS WORDS, > searchword FROM testa; > !image-2020-08-31-10-02-39-154.png! -- This message was sent by Atlassian Jira (v8.3.4#803005)