delete Subquery Unsupported
Posted by
yixu2001 on
May 16, 2017; 6:34am
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-tableExamples:
DELETE FROM columncarbonTable1
WHERE column1 IN (SELECT column11 FROM sourceTable2)
yixu2001