[jira] [Commented] (HIVE-26872) INSERT UNION with LATERAL VIEW does not produce data

[Jan Filipiak (Jira)]

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

Jan Filipiak commented on HIVE-26872:
-

https://issues.apache.org/jira/browse/HIVE-21100 this should fix it for you

> INSERT UNION with LATERAL  VIEW does not produce data
> -
>
> Key: HIVE-26872
> URL: https://issues.apache.org/jira/browse/HIVE-26872
> Project: Hive
>  Issue Type: Bug
>  Components: Tez
>Affects Versions: 2.3.9, 3.1.2
>Reporter: FangBO
>Priority: Major
>
> {code:java}
> // code placeholder
> DROP TABLE union_test;
> CREATE TABLE union_test(id INT) PARTITIONED BY (`dt` STRING);
> DROP TABLE json_src;
> CREATE TABLE json_src(message STRING) PARTITIONED BY (`dt` STRING);
> INSERT OVERWRITE TABLE json_src PARTITION(dt='1219') VALUES('{"id":1}');
> INSERT OVERWRITE TABLE json_src PARTITION(dt='1220') VALUES('{"id":2}');
> INSERT OVERWRITE TABLE union_test PARTITION (dt='1221')
> SELECT id FROM json_src LATERAL  VIEW json_tuple(message, 'id') b AS id WHERE 
> dt='1219'
> UNION ALL
> SELECT id FROM json_src LATERAL  VIEW json_tuple(message, 'id') b AS id WHERE 
> dt='1220'
> ; {code}
> The script above does not produce data in partition dt='1221'



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Commented] (HIVE-3491) Expose column names to UDFs

[Jan Filipiak (JIRA)]

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

Jan Filipiak commented on HIVE-3491:


Hello just want to let people know that I actually do this asterisk thing now 
and ran into exactly this limitation. Now i will probably need todo mapping to 
the user expected StructOi output by ordinal position, wich makes schema 
evolution a lot harder :( 

Anyone plans on getting this done?

> Expose column names to UDFs
> ---
>
> Key: HIVE-3491
> URL: https://issues.apache.org/jira/browse/HIVE-3491
> Project: Hive
>  Issue Type: New Feature
>  Components: Query Processor, UDF
>Reporter: Adam Kramer
>
> If I run
> SELECT MY_FUNC(a.foo, b.bar) FROM baz1 a JOIN baz2 b;
> ...the parsed query structure (i.e., that "foo" and "bar" are the name of the 
> columns) should be available to the UDF in some manner.



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