[
https://issues.apache.org/jira/browse/KYLIN-4382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xiaoxiang Yu updated KYLIN-4382:
--------------------------------
Affects Version/s: v4.0.1
v3.1.3
> 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
> Affects Versions: v3.1.3, v4.0.1
> 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.20.1#820001)
