[jira] [Created] (HIVE-11217) CTAS statements throws error, when the table is stored as ORC File format and select clause has NULL/VOID type column

Thu, 09 Jul 2015 07:23:46 -0700 

Gaurav Kohli created HIVE-11217:
-----------------------------------

             Summary: 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;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to