[
https://issues.apache.org/jira/browse/HIVE-27253?focusedWorklogId=856405&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-856405
]
ASF GitHub Bot logged work on HIVE-27253:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 12/Apr/23 11:03
Start Date: 12/Apr/23 11:03
Worklog Time Spent: 10m
Work Description: kasakrisz opened a new pull request, #4223:
URL: https://github.com/apache/hive/pull/4223
<!--
Thanks for sending a pull request! Here are some tips for you:
1. If this is your first time, please read our contributor guidelines:
https://cwiki.apache.org/confluence/display/Hive/HowToContribute
2. Ensure that you have created an issue on the Hive project JIRA:
https://issues.apache.org/jira/projects/HIVE/summary
3. Ensure you have added or run the appropriate tests for your PR:
4. If the PR is unfinished, add '[WIP]' in your PR title, e.g.,
'[WIP]HIVE-XXXXX: Your PR title ...'.
5. Be sure to keep the PR description updated to reflect all changes.
6. Please write your PR title to summarize what this PR proposes.
7. If possible, provide a concise example to reproduce the issue for a
faster review.
-->
### What changes were proposed in this pull request?
When converting {{HiveValues([])}} which represents an operator never
produces rows to AST handle array types.
AST representation of an array of int with NULL elements should be
```
TOK_SELEXPR
TOK_FUNCTION
array
TOK_FUNCTION
TOK_INT
TOK_NULL
TOK_FUNCTION
TOK_INT
TOK_NULL
```
### Why are the changes needed?
Support array types
### Does this PR introduce _any_ user-facing change?
Yes. In case of CTAS statements when the query in the statement does not
produce any rows and the source table has an array type column where the
element type is other than string the target table still inherit the source
table schema.
### How was this patch tested?
```
vn test -Dtest.output.overwrite -Dtest=TestMiniLlapLocalCliDriver
-Dqfile=empty_result_ctas.q -pl itests/qtest -Pitests
```
Issue Time Tracking
-------------------
Worklog Id: (was: 856405)
Remaining Estimate: 0h
Time Spent: 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
> Time Spent: 10m
> 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)
