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)