delete Subquery Unsupported

Posted by yixu2001 on
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/delete-Subquery-Unsupported-tp12713.html

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