[
https://issues.apache.org/jira/browse/HIVE-11217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gaurav Kohli updated HIVE-11217:
--------------------------------
Description:
If you try to use create-table-as-select (CTAS) statement and create a ORC File
format based table, then you can't use NULL as a column value in select clause
CREATE TABLE empty (x int);
CREATE TABLE orc_table_with_null
STORED AS ORC
AS
SELECT
x,
null
FROM empty;
Erro: FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.IllegalArgumentException:
Unknown primitive type VOID
was:
If you try to use create-table-as-select (CTAS) statement and create a ORC File
format based table, then you can't use NULL as a column value in select clause
CREATE TABLE empty (x int);
CREATE TABLE orc_table_with_null
STORED AS ORC
AS
SELECT
x,
null
FROM empty;
> CTAS statements throws error, when the table is stored as ORC File format and
> select clause has NULL/VOID type column
> ----------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-11217
> URL: https://issues.apache.org/jira/browse/HIVE-11217
> Project: Hive
> Issue Type: Bug
> Components: File Formats
> Affects Versions: 0.13.1
> Reporter: Gaurav Kohli
> Priority: Minor
>
> If you try to use create-table-as-select (CTAS) statement and create a ORC
> File format based table, then you can't use NULL as a column value in select
> clause
> CREATE TABLE empty (x int);
> CREATE TABLE orc_table_with_null
> STORED AS ORC
> AS
> SELECT
> x,
> null
> FROM empty;
> Erro: FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.IllegalArgumentException:
> Unknown primitive type VOID
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
