[jira] [Commented] (KYLIN-4382) Unable to use DATE type in prepared statements

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

    [ https://issues.apache.org/jira/browse/KYLIN-4382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17046057#comment-17046057 ] 

Yaqian Zhang commented on KYLIN-4382:
-------------------------------------

Hi Gabor:

Thank you for your report!

I will try to reproduce it.

> Unable to use DATE type in prepared statements
> ----------------------------------------------
>
>                 Key: KYLIN-4382
>                 URL: https://issues.apache.org/jira/browse/KYLIN-4382
>             Project: Kylin
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: Gabor Arki
>            Priority: Major
>
> h4. Environment
>  * Kylin JDBC driver: 3.0.0
>  * Kylin server: 3.0.0
> h4. Reproduction steps
>  * Use a cube with a DATE column (like the derived day_start)
>  * Create a prepared statement and try to filter with this column in a where clause
>  * Pass the values as java.sql.Date type
> h4. Expected result
>  * The proper response is provided for the query with the values for the specified date(s)
> h4. Actual result
>  * No data is returned
>  * StreamStorageQuery's _Skip cube segment_ log message is containing the filter with an epoch day value, for example: {{DAY_START GTE [18231]}}
>  * Executing the same query from the web UI you get the expected response. Now the same log message is containing the filter in epoch millis format, for example: {{DAY_START IN [1580774400000, 1580860800000]}}
>  * Passing the value as String instead of java.sql.Date fails on server-side with: {{exception while executing query: java.lang.String cannot be cast to java.lang.Integer}}
>  * Passing the value as java.sql.Timestamp or java.util.Date fails on server-side with: {{exception while executing query: java.lang.Long cannot be cast to java.lang.Integer}}
>  * Trying to CAST a String to DATE fails with the error described here: https://issues.apache.org/jira/browse/CALCITE-3100
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)