[jira] [Created] (KYLIN-5496) 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

["longfeiJiang (Jira)" <ji...@apache.org>]

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)