You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Daniel Becker (Jira)" <ji...@apache.org> on 2022/10/12 22:06:00 UTC
[jira] [Resolved] (IMPALA-10356) Analyzed query in explain plan is not quite right for insert with values clause
[ https://issues.apache.org/jira/browse/IMPALA-10356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Daniel Becker resolved IMPALA-10356.
------------------------------------
Resolution: Fixed
> 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.0
> Reporter: Tim Armstrong
> Assignee: Daniel Becker
> Priority: Major
> Labels: newbie, ramp-up
>
> 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.20.10#820010)