Pavel Grafkin created IMPALA-7045:

             Summary: CTAS doesn't allow NULL values
                 Key: IMPALA-7045
             Project: IMPALA
          Issue Type: Bug
         Environment: impalad version 2.7.0-cdh5.10.0 RELEASE (build 
Built on Fri Jan 20 12:03:56 PST 2017
            Reporter: Pavel Grafkin

When I run following:

{{CREATE TABLE temp_test AS SELECT CAST(null AS bigint) as nullable_int }}

with the error:

{{Unsupported type 'null_type' in column 'nullable_int' of table 'temp_test'}}

The reason for this, I assume, is following. In the INSERT statements data 
types of result set's columns are retrieved from the resulting values:

Whereas in CTAS they are calculated via base table of the column (and there is 
no base table for NULL):


This message was sent by Atlassian JIRA

Reply via email to