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 "Tim Armstrong (Jira)" <ji...@apache.org> on 2020/11/24 18:38:00 UTC
[jira] [Created] (IMPALA-10356) Analyzed query in explain plan is
not quite right for insert with values clause
Tim Armstrong created IMPALA-10356:
--------------------------------------
Summary: Analyzed query in explain plan is not quite right for insert with values clause
Key: IMPALA-10356
URL: https://issues.apache.org/jira/browse/IMPALA-10356
Project: IMPALA
Issue Type: Bug
Components: Frontend
Affects Versions: Impala 4.0
Reporter: Tim Armstrong
In impala-shell:
{noformat}
create table double_tbl (d double) stored as textfile;
set explain_level=2;
explain insert into double_tbl values (-0.43149576573887316);
{noformat}
{noformat}
+----------------------------------------------------------------------------------+
| Explain String |
+----------------------------------------------------------------------------------+
| Max Per-Host Resource Reservation: Memory=0B Threads=1 |
| Per-Host Resource Estimates: Memory=10MB |
| Codegen disabled by planner |
| Analyzed query: SELECT CAST(-0.43149576573887316 AS DECIMAL(17,17)) UNION SELECT |
| CAST(-0.43149576573887316 AS DECIMAL(17,17)) |
| |
| F00:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=8B mem-reservation=0B thread-reservation=1 |
| WRITE TO HDFS [default.double_tbl, OVERWRITE=false] |
| | partitions=1 |
| | output exprs: CAST(-0.43149576573887316 AS DOUBLE) |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | |
| 00:UNION |
| constant-operands=1 |
| mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| tuple-ids=0 row-size=8B cardinality=1 |
| in pipelines: <none> |
+----------------------------------------------------------------------------------+
{noformat}
The analyzed query does not make sense. We should investigate and fix it.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org