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: [email protected]
For additional commands, e-mail: [email protected]
