[
https://issues.apache.org/jira/browse/SPARK-5926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14329251#comment-14329251
]
Yanbo Liang edited comment on SPARK-5926 at 2/20/15 5:59 PM:
-------------------------------------------------------------
The following is the output of each query
#1:
{code|borderStyle=solid}
== Parsed Logical Plan ==
LogicalRDD [], ParallelCollectionRDD[7] at parallelize at commands.scala:65
== Analyzed Logical Plan ==
LogicalRDD [], ParallelCollectionRDD[7] at parallelize at commands.scala:65
== Optimized Logical Plan ==
LogicalRDD [], ParallelCollectionRDD[7] at parallelize at commands.scala:65
== Physical Plan ==
PhysicalRDD [], ParallelCollectionRDD[7] at parallelize at commands.scala:65
#2:
== Parsed Logical Plan ==
'CreateTableAsSelect None, tb, false, Some(TOK_CREATETABLE)
'Project [*]
'Filter ('key > 490)
'UnresolvedRelation [src], None
== Analyzed Logical Plan ==
CreateTableAsSelect [Database:default, TableName: tb, InsertIntoHiveTable]
Project [key#43,value#44]
Filter (key#43 > 490)
MetastoreRelation default, src, None
== Optimized Logical Plan ==
CreateTableAsSelect [Database:default, TableName: tb, InsertIntoHiveTable]
Project [key#43,value#44]
Filter (key#43 > 490)
MetastoreRelation default, src, None
== Physical Plan ==
ExecutedCommand (CreateTableAsSelect [Database:default, TableName: tb,
InsertIntoHiveTable]
Project [key#43,value#44]
Filter (key#43 > 490)
MetastoreRelation default, src, None
)
{code}
was (Author: yanboliang):
The following is the output of each query
#1:
== Parsed Logical Plan ==
LogicalRDD [], ParallelCollectionRDD[7] at parallelize at commands.scala:65
== Analyzed Logical Plan ==
LogicalRDD [], ParallelCollectionRDD[7] at parallelize at commands.scala:65
== Optimized Logical Plan ==
LogicalRDD [], ParallelCollectionRDD[7] at parallelize at commands.scala:65
== Physical Plan ==
PhysicalRDD [], ParallelCollectionRDD[7] at parallelize at commands.scala:65
#2:
== Parsed Logical Plan ==
'CreateTableAsSelect None, tb, false, Some(TOK_CREATETABLE)
'Project [*]
'Filter ('key > 490)
'UnresolvedRelation [src], None
== Analyzed Logical Plan ==
CreateTableAsSelect [Database:default, TableName: tb, InsertIntoHiveTable]
Project [key#43,value#44]
Filter (key#43 > 490)
MetastoreRelation default, src, None
== Optimized Logical Plan ==
CreateTableAsSelect [Database:default, TableName: tb, InsertIntoHiveTable]
Project [key#43,value#44]
Filter (key#43 > 490)
MetastoreRelation default, src, None
== Physical Plan ==
ExecutedCommand (CreateTableAsSelect [Database:default, TableName: tb,
InsertIntoHiveTable]
Project [key#43,value#44]
Filter (key#43 > 490)
MetastoreRelation default, src, None
)
> [SQL] DataFrame.explain() return false result for DDL command
> -------------------------------------------------------------
>
> Key: SPARK-5926
> URL: https://issues.apache.org/jira/browse/SPARK-5926
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Reporter: Yanbo Liang
>
> This bug is easy to reproduce, the following two queries should print out the
> same explain result, but it's not.
> sql("create table tb as select * from src where key > 490").explain(true)
> sql("explain extended create table tb as select * from src where key > 490")
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
