[
https://issues.apache.org/jira/browse/KYLIN-4382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabor Arki updated KYLIN-4382:
------------------------------
Description:
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
was:
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}}
> 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)
