You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2018/01/09 21:34:00 UTC
[jira] [Created] (HIVE-18416) Initial support for TABLE function
Jesus Camacho Rodriguez created HIVE-18416:
----------------------------------------------
Summary: Initial support for TABLE function
Key: HIVE-18416
URL: https://issues.apache.org/jira/browse/HIVE-18416
Project: Hive
Issue Type: Bug
Components: Parser
Affects Versions: 3.0.0
Reporter: Jesus Camacho Rodriguez
Assignee: Jesus Camacho Rodriguez
Include support for TABLE function derived table. In SQL standard, it is defined as:
{noformat}
<table function derived table> ::=
TABLE <left paren> <collection value expression> <right paren>
{noformat}
Further, include limited support for its usage as LATERAL derived table.
This will allow Hive to execute queries such as:
{code}
SELECT tf.col1, tf.col2, tf.col3
FROM
TABLE(VALUES('A', 10, 30.0),('B', 20, 30.0)) AS tf(col1, col2, col3);
SELECT tf.col1, tf.col2, tf.col3
FROM
(SELECT key, value FROM src) t,
LATERAL TABLE(VALUES('A', 10, t.key),('B', 20, t.key)) AS tf(col1, col2, col3);
{code}
The idea is to rely on AST rewriting for such cases, as TABLE can be implemented using {{inline}} UDTF with an {{array}} of {{structs}} representing the rows in the {{VALUES}} clause.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)