You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Krisztian Kasa (Jira)" <ji...@apache.org> on 2023/04/14 04:33:00 UTC

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

     [ https://issues.apache.org/jira/browse/HIVE-27253?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Krisztian Kasa resolved HIVE-27253.
-----------------------------------
    Resolution: Fixed

Merged to master. Thanks [~zabetak] and [~amansinha100] for review.

> 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: 1h 40m
>  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)