[jira] [Created] (CARBONDATA-3477) Throw out exception when use sql: 'update table select\n...'

["Zhichao Zhang (JIRA)" <ji...@apache.org>]

Zhichao  Zhang created CARBONDATA-3477:
------------------------------------------

             Summary: Throw out exception when use sql: 'update table select\n...'
                 Key: CARBONDATA-3477
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-3477
             Project: CarbonData
          Issue Type: Bug
            Reporter: Zhichao  Zhang
            Assignee: Zhichao  Zhang


When use below sql to update table:

UPDATE IUD_table2 a
 SET (a.IUD_table2_country, a.IUD_table2_salary) = (select
b.IUD_table1_country, b.IUD_table1_salary from IUD_table1 b where b.IUD_table1_id = 8)
WHERE a.IUD_table2_id < 6 or a.IUD_table2_id > 15

It will throw out exception:

Exception in thread "main" org.apache.spark.sql.AnalysisException: == Parse1 ==

mismatched input '.' expecting <EOF>(line 2, pos 1)

== SQL ==
select select
b.IUD_table1_country, b.IUD_table1_salary from IUD_table1 b where b.IUD_table1_id = 8 from iud_table2 a
-^^^

== Parse2 ==
[1.1] failure: identifier matching regex (?i)ALTER expected

select select



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)