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

[Akash R Nilugal (Jira)]

     [ https://issues.apache.org/jira/browse/CARBONDATA-3477?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ajantha Bhat updated CARBONDATA-3477:
-------------------------------------
    Fix Version/s:     (was: 1.6.0)
                   1.6.1

> 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
>            Priority: Minor
>             Fix For: 1.6.1
>
>          Time Spent: 4h 50m
>  Remaining Estimate: 0h
>
> When use below sql to update table:
> {code:java}
> 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{code}
> *It will throw out exception:* 
> {code:java}
> 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
> {code}
>  

--
This message was sent by Atlassian Jira
(v8.3.4#803005)