[
https://issues.apache.org/jira/browse/KYLIN-4382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17489229#comment-17489229
]
ASF GitHub Bot commented on KYLIN-4382:
---------------------------------------
hit-lacus commented on pull request #1813:
URL: https://github.com/apache/kylin/pull/1813#issuecomment-1033315596
Merged
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
> 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
> Fix For: v4.0.2
>
>
> 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)
