[ https://issues.apache.org/jira/browse/HIVE-3490?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Phabricator updated HIVE-3490: ------------------------------ Attachment: HIVE-3490.D8889.1.patch navis requested code review of "HIVE-3490 [jira] Implement * or a.* for arguments to UDFs". Reviewers: JIRA HIVE-3490 Implement * or a.* for arguments to UDFs For a random UDF, we should be able to use * or a.* to refer to "all of the columns in their natural order." This is not currently implemented. I'm reporting this as a bug because it is a manner in which Hive is inconsistent with the SQL spec, and because Hive claims to implement *. hive> select all_non_null(a.*) from table a where a.ds='2012-09-01'; FAILED: ParseException line 1:25 mismatched input '*' expecting Identifier near '.' in expression specification TEST PLAN EMPTY REVISION DETAIL https://reviews.facebook.net/D8889 AFFECTED FILES ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java ql/src/java/org/apache/hadoop/hive/ql/plan/ExprNodeColumnListDesc.java ql/src/test/queries/clientpositive/allcolref_in_udf.q ql/src/test/results/clientpositive/allcolref_in_udf.q.out MANAGE HERALD RULES https://reviews.facebook.net/herald/view/differential/ WHY DID I GET THIS EMAIL? https://reviews.facebook.net/herald/transcript/21621/ To: JIRA, navis > Implement * or a.* for arguments to UDFs > ---------------------------------------- > > Key: HIVE-3490 > URL: https://issues.apache.org/jira/browse/HIVE-3490 > Project: Hive > Issue Type: Bug > Components: Query Processor, UDF > Reporter: Adam Kramer > Assignee: Navis > Attachments: HIVE-3490.D8889.1.patch > > > For a random UDF, we should be able to use * or a.* to refer to "all of the > columns in their natural order." This is not currently implemented. > I'm reporting this as a bug because it is a manner in which Hive is > inconsistent with the SQL spec, and because Hive claims to implement *. > hive> select all_non_null(a.*) from table a where a.ds='2012-09-01'; > FAILED: ParseException line 1:25 mismatched input '*' expecting Identifier > near '.' in expression specification -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira