[jira] [Commented] (HIVE-26872) INSERT UNION with LATERAL VIEW does not produce data
[ 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
[ 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)