[
https://issues.apache.org/jira/browse/IMPALA-12815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17822922#comment-17822922
]
ASF subversion and git services commented on IMPALA-12815:
----------------------------------------------------------
Commit 96964be7a31a78058dea08b43c3b4115fb93dea7 in impala's branch
refs/heads/master from gaurav1086
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=96964be7a ]
IMPALA-12815: Support timestamp for scan predicates
for external data source table.
Binary SCAN predicates involving timestamp literals are pushed down
to remote Database. The current logic assumes ISO 8601 (SQL standard)
format for timestamp literals - 'yyyy-mm-dd hh:mm:ss.ms'
Testing:
- Added custom cluster tests for timestamp predicates with operators:
'=', '>', '<', '>=', '<=', '!=', 'BETWEEN' for postgres, mysql
and remote impala.
- Added coverage for timestamp with/without time in the timestamp
- Added coverage for timestamp with/without milliseconds in timestamp.
- Added Planner tests to check predicate pushdown for date/timestamp
literals, date/timestamp functions and CASTs
Change-Id: If6ffe672b4027e2cee094cec4f99b9df9308e441
Reviewed-on: http://gerrit.cloudera.org:8080/21015
Tested-by: Impala Public Jenkins <[email protected]>
Reviewed-by: Wenzhe Zhou <[email protected]>
> Support timestamp data type for predicates for external data source table
> -------------------------------------------------------------------------
>
> Key: IMPALA-12815
> URL: https://issues.apache.org/jira/browse/IMPALA-12815
> Project: IMPALA
> Issue Type: Sub-task
> Components: Backend, Frontend
> Reporter: gaurav singh
> Assignee: gaurav singh
> Priority: Major
> Fix For: Impala 4.4.0
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
