delete Subquery Unsupported

[yixu2001]

dev
 
  Step to Reproduce
1.scala> cc.sql("delete  from qqdata.gg_quninfo  where  qunnum in (select  qunnum11 from  qqdata.yang_group2)").show;
 
Error:
org.apache.spark.sql.AnalysisException:
Unsupported language features in query: select tupleId from qqdata.gg_quninfo  where   qunnum in (select  qunnum11 from  qqdata.yang_group2)
TOK_QUERY 1, 0,31, 20
  TOK_FROM 1, 4,8, 20
    TOK_TABREF 1, 6,8, 20
      TOK_TABNAME 1, 6,8, 20
        qqdata 1, 6,6, 20
        gg_quninfo 1, 8,8, 27
  TOK_INSERT 0, -1,31, 0
 
 

But carbondata Examples supported why ?

http://carbondata.apache.org/dml-operation-on-carbondata.html#update-carbondata-table
Examples:
DELETE FROM columncarbonTable1
WHERE column1 IN (SELECT column11 FROM sourceTable2)
 


yixu2001

[ravikiran23]

In spark 1.6, The IN function is not supported by spark. that is the reason you are getting the  error. In spark 2.1 this issue is resolved and so in the update and delete also In will work.

Regarding the example need to remove this example of sub query in spark 1.6.

[ravipesala]

And also update/delete function is not yet supported in spark 2.1 so we are
going to support it in next release.

Regards,
Ravindra.

On 16 May 2017 at 15:49, ravikiran23 <[hidden email]> wrote:

> In spark 1.6, The IN function is not supported by spark. that is the reason
> you are getting the  error. In spark 2.1 this issue is resolved and so in
> the update and delete also In will work.
>
> Regarding the example need to remove this example of sub query in spark
> 1.6.
>
>
>
> --
> View this message in context: http://apache-carbondata-dev-
> mailing-list-archive.1130556.n5.nabble.com/delete-Subquery-
> Unsupported-tp12713p12719.html
> Sent from the Apache CarbonData Dev Mailing List archive mailing list
> archive at Nabble.com.
>

--
Thanks & Regards,
Ravi