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)