[
https://issues.apache.org/jira/browse/HIVE-9483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Eugene Koifman updated HIVE-9483:
---------------------------------
Description:
{noformat}
hive> explain extended insert into foo values(1,2,3);
OK
ABSTRACT SYNTAX TREE:
TOK_QUERY
TOK_FROM
null
null
Values__Tmp__Table__13
TOK_INSERT
TOK_INSERT_INTO
TOK_TAB
TOK_TABNAME
foo
TOK_SELECT
TOK_SELEXPR
TOK_ALLCOLREF
{noformat}
Note the 'null's under TOK_FROM
but
new ParseDriver().parse("insert into page_view values(1,2)").toStringTree()
returns
{noformat}
(TOK_QUERY
(TOK_FROM
(TOK_VIRTUAL_TABLE
(TOK_VIRTUAL_TABREF TOK_ANONYMOUS)
(TOK_VALUES_TABLE (TOK_VALUE_ROW 1 2))))
(TOK_INSERT (TOK_INSERT_INTO (TOK_TAB (TOK_TABNAME page_view)))
(TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))
{noformat}
insert/update rewrite the AST but I don't think it should produce 'null' 'null'
was:
{noformat}
hive> explain extended insert into foo values(1,2,3);
OK
ABSTRACT SYNTAX TREE:
TOK_QUERY
TOK_FROM
null
null
Values__Tmp__Table__13
TOK_INSERT
TOK_INSERT_INTO
TOK_TAB
TOK_TABNAME
foo
TOK_SELECT
TOK_SELEXPR
TOK_ALLCOLREF
{noformat}
Note the 'null's under TOK_FROM
but
new ParseDriver().parse("insert into page_view values(1,2)")
returns
{noformat}
(TOK_QUERY
(TOK_FROM
(TOK_VIRTUAL_TABLE
(TOK_VIRTUAL_TABREF TOK_ANONYMOUS)
(TOK_VALUES_TABLE (TOK_VALUE_ROW 1 2))))
(TOK_INSERT (TOK_INSERT_INTO (TOK_TAB (TOK_TABNAME page_view)))
(TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))
{noformat}
insert/update rewrite the AST but I don't think it should produce 'null' 'null'
> EXPLAIN EXTENDED for Insert ... values... is missing info in AST
> ----------------------------------------------------------------
>
> Key: HIVE-9483
> URL: https://issues.apache.org/jira/browse/HIVE-9483
> Project: Hive
> Issue Type: Bug
> Components: Query Processor, SQL
> Affects Versions: 0.14.0
> Reporter: Eugene Koifman
> Assignee: Eugene Koifman
> Priority: Minor
>
> {noformat}
> hive> explain extended insert into foo values(1,2,3);
> OK
> ABSTRACT SYNTAX TREE:
>
> TOK_QUERY
> TOK_FROM
> null
> null
> Values__Tmp__Table__13
> TOK_INSERT
> TOK_INSERT_INTO
> TOK_TAB
> TOK_TABNAME
> foo
> TOK_SELECT
> TOK_SELEXPR
> TOK_ALLCOLREF
> {noformat}
> Note the 'null's under TOK_FROM
> but
> new ParseDriver().parse("insert into page_view values(1,2)").toStringTree()
> returns
> {noformat}
> (TOK_QUERY
> (TOK_FROM
> (TOK_VIRTUAL_TABLE
> (TOK_VIRTUAL_TABREF TOK_ANONYMOUS)
> (TOK_VALUES_TABLE (TOK_VALUE_ROW 1 2))))
> (TOK_INSERT (TOK_INSERT_INTO (TOK_TAB (TOK_TABNAME page_view)))
> (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))
> {noformat}
> insert/update rewrite the AST but I don't think it should produce 'null'
> 'null'
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
