[
https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17519354#comment-17519354
]
Julian Hyde commented on CALCITE-5039:
--
It may not solve this exact problem, but I'm curious how
[
https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17518800#comment-17518800
]
Xurenhe commented on CALCITE-5039:
--
I think it's special case and not a behavior of standard sql.
>
[
https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17517329#comment-17517329
]
itxiangkui commented on CALCITE-5039:
-
Yes! [~wojustme]
My test case is the same as yours, and
[
https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17516270#comment-17516270
]
Xurenhe commented on CALCITE-5039:
--
Hi [~itxiangkui]
||id(int)||c1(varchar)||ts(bigint)||
[
https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17516204#comment-17516204
]
itxiangkui commented on CALCITE-5039:
-
Our DBAs are used to mysql's type system
often in
[
https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17513324#comment-17513324
]
Xurenhe commented on CALCITE-5039:
--
I guess you're using the type of bigint to store time data.
These
[
https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17513116#comment-17513116
]
itxiangkui commented on CALCITE-5039:
-
Perhaps the most ideal way to solve this problem is to use
[
https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17513115#comment-17513115
]
itxiangkui commented on CALCITE-5039:
-
We designed a "time series database" based on mysql. The
[
https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17512583#comment-17512583
]
Julian Hyde commented on CALCITE-5039:
--
I don't understand what you mean by "query the data which
[
https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17506804#comment-17506804
]
itxiangkui commented on CALCITE-5039:
-
I can use TIMESTAMP_WITH_LOCAL_TIME_ZONE data type instead
[
https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17506712#comment-17506712
]
Julian Hyde commented on CALCITE-5039:
--
What change would you like us to make? Are you requesting
[
https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1750#comment-1750
]
itxiangkui commented on CALCITE-5039:
-
I may understand the complexities of timezones.
in a
[
https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17506399#comment-17506399
]
Julian Hyde commented on CALCITE-5039:
--
The SQL TIMESTAMP type is zoneless. For example, the value
[
https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17506035#comment-17506035
]
itxiangkui commented on CALCITE-5039:
-
if you use TIMESTAMP_WITH_LOCAL_TIME_ZONE instread
14 matches
Mail list logo