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

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.6.1
• Assignee: Zhichao Zhang
• Reporter: Zhichao Zhang
• Created: 26/Jul/19 06:52
• Updated: 09/Oct/19 14:53
• Resolved: 08/Aug/19 14:52

Description

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

 

Issue Links

• links to: GitHub Pull Request #3338