Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
3.1.0
-
None
Description
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;
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;
Attachments
Attachments
Issue Links
- is fixed by
-
HIVE-21001 Upgrade to calcite-1.19
- Closed