hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gaurav Kohli (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-11217) CTAS statements throws error, when the table is stored as ORC File format and select clause has NULL/VOID type column
Date Thu, 09 Jul 2015 14:23:05 GMT

     [ 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)

Mime
View raw message