[
https://issues.apache.org/jira/browse/IMPALA-13018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17843357#comment-17843357
]
Wenzhe Zhou edited comment on IMPALA-13018 at 5/3/24 10:19 PM:
---------------------------------------------------------------
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
coordinator. 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}
Since data type of 'd_date' is string and we don't have metadata of remote
table, we cannot determine the data type of the data in remote table.
was (Author: wzhou):
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
coordinator. 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}
Since data type of 'd_date' is string and we don't have metadata of remote
table, we cannot determine the data type of the data in remote type.
> 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: [email protected]
For additional commands, e-mail: [email protected]
