[
https://issues.apache.org/jira/browse/IMPALA-8533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840659#comment-16840659
]
Todd Lipcon commented on IMPALA-8533:
-------------------------------------
Interestingly, a UNION ALL with all constants produces a 0-size row, but a
normal SELECT with all constants produces a row with space for the values:
{code}
Query: explain select 1 v from (select 1 union all select 1) t
+-----------------------------------------------------------------------------+
| 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(1 AS TINYINT) v FROM (SELECT CAST(1 AS TINYINT) |
| UNION ALL SELECT CAST(1 AS TINYINT)) t |
| |
| F00:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 |
| PLAN-ROOT SINK |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | |
| 00:UNION |
| constant-operands=2 |
| mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| tuple-ids=0 row-size=0B cardinality=2 |
| in pipelines: <none> |
+-----------------------------------------------------------------------------+
Query: explain select 1 v from (select 1 ) t
+--------------------------------------------------------------------------------+
| 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(1 AS TINYINT) v FROM (SELECT CAST(1 AS TINYINT))
t |
|
|
| F00:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|
| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
|
| PLAN-ROOT SINK
|
| | mem-estimate=0B 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=1B cardinality=1
|
| in pipelines: <none>
|
+--------------------------------------------------------------------------------+
{code}
> Impala daemon crash on sort
> ---------------------------
>
> Key: IMPALA-8533
> URL: https://issues.apache.org/jira/browse/IMPALA-8533
> Project: IMPALA
> Issue Type: Bug
> Components: Backend
> Affects Versions: Impala 3.2.0
> Reporter: Jeremy Beard
> Assignee: Todd Lipcon
> Priority: Blocker
> Labels: crash
> Attachments: fatal_error.txt, hs_err_pid8552.log, query.txt
>
>
> Running the attached data generation query crashes the Impala coordinator
> daemon.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
