You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues-all@impala.apache.org by "Wenzhe Zhou (Jira)" <ji...@apache.org> on 2024/04/10 22:47:00 UTC

[jira] [Updated] (IMPALA-12983) Performance improvement for impala-impala federation

     [ https://issues.apache.org/jira/browse/IMPALA-12983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Wenzhe Zhou updated IMPALA-12983:
---------------------------------
    Summary: Performance improvement for impala-impala federation  (was: Push down 'order by' to remote database server)

> Performance improvement for impala-impala federation
> ----------------------------------------------------
>
>                 Key: IMPALA-12983
>                 URL: https://issues.apache.org/jira/browse/IMPALA-12983
>             Project: IMPALA
>          Issue Type: Sub-task
>          Components: Frontend
>            Reporter: Wenzhe Zhou
>            Assignee: Pranav Yogi Lodha
>            Priority: Major
>
> "order by" cannot be pushed down to JDBC right now, but most of tpcds/tpch queries are using "order by ... limit ...", e.g top n. This results JDBC handler to retrieve all rows of remote table on remote database server, hence bad performance.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org