You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Xianqing He (Jira)" <ji...@apache.org> on 2021/07/15 11:48:00 UTC
[jira] [Created] (IMPALA-10799) Analysis slowdown with inline views
and thousands of column
Xianqing He created IMPALA-10799:
------------------------------------
Summary: Analysis slowdown with inline views and thousands of column
Key: IMPALA-10799
URL: https://issues.apache.org/jira/browse/IMPALA-10799
Project: IMPALA
Issue Type: Improvement
Components: Frontend
Reporter: Xianqing He
Assignee: Xianqing He
If there are thousands of columns in the inlineview, it‘s very slow in analysis. For example, this sql will take almost 4s in analysis.
{code:java}
select c1 from (select c1, c2... c10000 from T) T
Query Compilation: 3s880ms
- Translate start: 968.000ns (968.000ns)
- Translate finished: 4.318ms (4.317ms)
- Metadata of all 1 tables cached: 42.219ms (37.900ms)
- Analysis finished: 3s776ms (3s734ms)
- Value transfer graph computed: 3s806ms (30.163ms)
- Single node plan created: 3s869ms (62.556ms)
- Runtime filters computed: 3s874ms (5.603ms)
- Distributed plan created: 3s874ms (128.086us)
- Planning finished: 3s880ms (5.836ms)
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)