[jira] [Created] (SPARK-16089) 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

[marymwu (JIRA)]

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: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org