[ https://issues.apache.org/jira/browse/HIVE-8642?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nishant Kelkar updated HIVE-8642: --------------------------------- Summary: Hive stack() UDTF Doesn't Support NULL Insert Values (was: Hive stack() Method Doesn't Support NULL Insert Values) > Hive stack() UDTF 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)