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)
