[ https://issues.apache.org/jira/browse/IMPALA-13018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17843357#comment-17843357 ]
Wenzhe Zhou commented on IMPALA-13018: -------------------------------------- For "d_date between cast('2000-08-23' as date) and (cast('2000-08-23' as date) + interval 30 days)", following query is generated to be sent to remote Impala cluster. Predicates are pushed to remote Impala coordinator. {code:java} SELECT d_date_sk FROM date_dim WHERE (d_date >= '2000-08-23') AND (d_date <= '2000-09-22') {code} For "cast(d_date as timestamp) between cast('2000-08-23' as timestamp) and (cast('2000-08-23' as timestamp) + interval 30 days)", following query is generated to be sent to remote Impala cluster, casting for d_date is executed on local coordinator so that predicate "CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00'" are not pushed down to remote coordinator, applied on local coordinator instead. {code:java} SELECT d_date_sk, d_date FROM date_dim {code} For "d_date between cast('2000-08-23' as timestamp) and (cast('2000-08-23' as timestamp) + interval 30 days)", following query is generated to be sent to remote Impala cluster. Wrong predicates are pushed to remote Impala coordinator. {code:java} SELECT d_date_sk FROM date_dim WHERE (d_date >= '2000-08-23 00:00:00') AND (d_date <= '2000-09-22 00:00:00') {code} > Fix > test_tpcds_queries.py/TestTpcdsQueryForJdbcTables.test_tpcdstpcds-decimal_v2-q80a > failure > --------------------------------------------------------------------------------------------- > > Key: IMPALA-13018 > URL: https://issues.apache.org/jira/browse/IMPALA-13018 > Project: IMPALA > Issue Type: Sub-task > Components: Backend, Frontend > Reporter: Wenzhe Zhou > Assignee: Pranav Yogi Lodha > Priority: Major > > The returned rows are not matching expected results for some decimal type of > columns. -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org