[jira] [Created] (HIVE-8642) Hive stack() Method Doesn't Support NULL Insert Values

[Nishant Kelkar (JIRA)]

Nishant Kelkar created HIVE-8642:
------------------------------------

             Summary: Hive stack() Method Doesn't Support NULL Insert Values
                 Key: HIVE-8642
                 URL: https://issues.apache.org/jira/browse/HIVE-8642
             Project: Hive
          Issue Type: Improvement
          Components: SQL, UDF
    Affects Versions: 0.13.0
            Reporter: Nishant Kelkar
            Priority: Minor


The following tables exist:
1. test_table --  schema {"field_a":STRING, "field_b":STRING, "field_c":STRING}
2. dual -- schema {"field_1":INT}

test_table contents:
{code}
en      dbpedia http://dbpedia.org/schools/CMU
{code}

dual contents:
{code}
1
{code}

I tried the following query, and it fails:
{code}
INSERT INTO TABLE test_table SELECT 
stack(1,
"en",
"dbpedia",
NULL
) AS (
field_a,
field_b,
field_c
) FROM dual;
{code}

The error returned: FAILED: NullPointerException null



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