[jira] [Work logged] (HIVE-27253) Support array type when query does not produce any rows

[ASF GitHub Bot (Jira)]

     [ 
https://issues.apache.org/jira/browse/HIVE-27253?focusedWorklogId=856422&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-856422
 ]

ASF GitHub Bot logged work on HIVE-27253:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 12/Apr/23 12:11
            Start Date: 12/Apr/23 12:11
    Worklog Time Spent: 10m 
      Work Description: zabetak commented on PR #4223:
URL: https://github.com/apache/hive/pull/4223#issuecomment-1505163499

   Also regarding the empty ARRAY<INT> representation should it be the A1 or A1?
   **A1**
   ```
            TOK_SELEXPR
               TOK_FUNCTION
                  array
                  TOK_FUNCTION
                     TOK_INT
                     TOK_NULL
   ```
   **A2**
   ```
            TOK_SELEXPR
               TOK_FUNCTION
                  array
                  TOK_FUNCTION
                     TOK_INT
                     TOK_NULL
                  TOK_FUNCTION
                     TOK_INT
                     TOK_NULL
   ```
   I see that **A2** is mentioned in the description of the PR but I would 
expect that it was **A1**.




Issue Time Tracking
-------------------

    Worklog Id:     (was: 856422)
    Time Spent: 20m  (was: 10m)

> Support array type when query does not produce any rows
> -------------------------------------------------------
>
>                 Key: HIVE-27253
>                 URL: https://issues.apache.org/jira/browse/HIVE-27253
>             Project: Hive
>          Issue Type: Improvement
>          Components: CBO
>            Reporter: Krisztian Kasa
>            Assignee: Krisztian Kasa
>            Priority: Major
>              Labels: pull-request-available
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> {code}
> CREATE TABLE T1 (c1 int, c2 array<int>);
> CREATE TABLE T2 AS SELECT * FROM T1 LIMIT 0;
> describe formatted t2;
> {code}
> The new {{t2}} table schema should be
> {code}
> POSTHOOK: Input: default@t2
> # col_name                    data_type               comment             
> c1                    int                                         
> c2                    array<int>                                  
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)