marymwu created SPARK-16089:
-------------------------------
Summary: Spark2.0 doesn't support the certain static partition SQL
statment as "insert overwrite table targetTB PARTITION (partition field=xx)
select field1,field2,...,partition field from sourceTB where partition
field=xx" while Spark 1.6 supports
Key: SPARK-16089
URL: https://issues.apache.org/jira/browse/SPARK-16089
Project: Spark
Issue Type: Bug
Affects Versions: 2.0.0
Reporter: marymwu
Priority: Minor
Spark2.0 doesn't support the certain static partition SQL statment as "insert
overwrite table targetTB PARTITION (partition field=xx) select
field1,field2,...,partition field from sourceTB where partition field=xx" while
Spark 1.6 supports.
Testcase:
"insert overwrite table d_test_tpc_2g_txt.marytest1 PARTITION (dt='2016-06-21')
select nid, price, dt from d_test_tpc_2g_txt.marytest where dt = '2016-06-21';"
Error: org.apache.spark.sql.AnalysisException: unresolved operator
'InsertIntoTable MetastoreRelation d_test_tpc_2g_txt, marytest1, None, Map(dt
-> Some(2016-06-21)), true, false; (state=,code=0)
see attachment for reference.
Note:
The same SQL statement succeeded in Spark 1.6.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
