longfeiJiang created KYLIN-5496:
-----------------------------------
Summary: The query result is incorrect after converting the string
type data in 'yyyy-mm-dd' format to timestamp type and querying with filter of
this column
Key: KYLIN-5496
URL: https://issues.apache.org/jira/browse/KYLIN-5496
Project: Kylin
Issue Type: Bug
Reporter: longfeiJiang
The query result is incorrect after converting the string type data in
'yyyy-mm-dd' format to timestamp type and querying with filter of this column.
Steps to reproduce:
1. Create a hive table, the field type is string, and insert data 2022-12-01
{code:java}
create table test(dt string);
insert into test values('2022-12-01'); {code}
2. Use kylin loads the table and builds the model
3. Query as follows sql, result is empty
select dt,cast(dt as timestamp) from TEST.TEST where cast(dt as
timestamp)='2022-12-01 00:00:00.0'
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
