[ https://issues.apache.org/jira/browse/CALCITE-1690?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16020703#comment-16020703 ]
Julian Hyde commented on CALCITE-1690: -------------------------------------- Fixed in Avatica in http://git-wip-us.apache.org/repos/asf/calcite-avatica/commit/3c40e0db; Calcite work will follow after avatica-1.10. > Calcite timestamp literals cannot express precision above millisecond, > TIMESTAMP(3) > ----------------------------------------------------------------------------------- > > Key: CALCITE-1690 > URL: https://issues.apache.org/jira/browse/CALCITE-1690 > Project: Calcite > Issue Type: Bug > Reporter: Remus Rusanu > Assignee: Julian Hyde > Fix For: avatica-1.10.0, 1.13.0 > > > {{RexBuilder.makeTimestampLiteral}} accepts the TS as a Java Calendar > instance. Calendar type has only ms precision, thus types like > {{TIMESTAMP(9)}} cannot be represented. > This results in incorrect results in Hive due to constant reduction: > {noformat} > hive> explain select c17 from testjdbcdriverdatatypetbl where c17='2012-04-22 > 09:00:00.123456789'; > OK > Plan optimized by CBO. > Stage-0 > Fetch Operator > limit:-1 > Select Operator [SEL_2] > Output:["_col0"] > Filter Operator [FIL_4] > predicate:(c17 = 2012-04-22 09:00:00.123) > TableScan [TS_0] > Output:["c17"] > hive> select c17 from testjdbcdriverdatatypetbl where c17='2012-04-22 > 09:00:00.123456789'; > OK > Time taken: 0.687 seconds > hive> set hive.cbo.enable=false; > hive> explain select c17 from testjdbcdriverdatatypetbl where c17='2012-04-22 > 09:00:00.123456789'; > OK > Stage-0 > Fetch Operator > limit:-1 > Select Operator [SEL_2] > Output:["_col0"] > Filter Operator [FIL_4] > predicate:(c17 = '2012-04-22 09:00:00.123456789') > TableScan [TS_0] > Output:["c17"] > hive> select c17 from testjdbcdriverdatatypetbl where c17='2012-04-22 > 09:00:00.123456789'; > OK > 2012-04-22 09:00:00.123 > {noformat} > Note how with CBO enabled the qualified row is missed. The plan shows that > the constant was truncated to ms. -- This message was sent by Atlassian JIRA (v6.3.15#6346)