Stamatis Zampetakis created HIVE-25053: ------------------------------------------
Summary: Support explicit ROW value constructor in SQL statements Key: HIVE-25053 URL: https://issues.apache.org/jira/browse/HIVE-25053 Project: Hive Issue Type: New Feature Components: Query Processor Reporter: Stamatis Zampetakis Currently, it is possible to create ROW type values by using the implicit syntax with parentheses. However, when the explicit ROW constructor is used a {{ParseException}} is raised. +Example+ {code:sql} CREATE TABLE person (id int, name string, age int); EXPLAIN CBO SELECT (id, name), (name, age) FROM person; EXPLAIN CBO SELECT ROW(id, name), ROW(name, age) FROM person; {code} The first select statement succeeds and returns the CBO plan while the second fails with the exception below: {noformat} org.apache.hadoop.hive.ql.parse.ParseException: line 3:19 cannot recognize input near 'ROW' '(' 'id' in select clause at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:125) at org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:93) at org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:85) at org.apache.hadoop.hive.ql.Compiler.parse(Compiler.java:169) at org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:102) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:492) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:445) {noformat} -- This message was sent by Atlassian Jira (v8.3.4#803005)