delete Subquery Unsupported

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

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
Reply | Threaded
Open this post in threaded view
|

Re: delete Subquery Unsupported

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.
Reply | Threaded
Open this post in threaded view
|

Re: delete Subquery Unsupported

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