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

["Nishant Kelkar (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-8642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14187864#comment-14187864 ] 

Nishant Kelkar commented on HIVE-8642:
--------------------------------------

Pardon me if I've missed out on any details in this ticket. This is my first ticket on this Jira board (well, first technical ticket). 

Tagging you in case I've missed something [~leftylev]!

> 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)