[ 
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: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org

Reply via email to