Posted by
杰 on
Oct 31, 2016; 2:17am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/jira-Created-CARBONDATA-344-Exists-query-not-working-tp2470.html
hi, Prabhat
when u create a hive table in spark-sql, then query, this problem also happens.
so its not the problem of carbon, it's happens in hiveql parser in spark, that
TOK_SUBQUERY_EXPR is not supported. if possible, pls raise this problem to
apache spark.
regards
Jay
------------------ 原始邮件 ------------------
发件人: "Prabhat Kashyap (JIRA)";<
[hidden email]>;
发送时间: 2016年10月28日(星期五) 下午3:59
收件人: "dev"<
[hidden email]>;
主题: [jira] [Created] (CARBONDATA-344) Exists query not working
Prabhat Kashyap created CARBONDATA-344:
------------------------------------------
Summary: Exists query not working
Key: CARBONDATA-344
URL:
https://issues.apache.org/jira/browse/CARBONDATA-344 Project: CarbonData
Issue Type: Bug
Reporter: Prabhat Kashyap
Whenever I m trying to execute 'exists' query, I'm getting the following error:
Error: org.apache.spark.sql.AnalysisException:
Unsupported language features in query: select id from emp2 where exists(select id from emp3 where emp2.id=emp3.id)
TOK_QUERY 1, 0,29, 15
TOK_FROM 1, 4,6, 15
TOK_TABREF 1, 6,6, 15
TOK_TABNAME 1, 6,6, 15
emp2 1, 6,6, 15
TOK_INSERT 0, -1,29, 0
TOK_DESTINATION 0, -1,-1, 0
TOK_DIR 0, -1,-1, 0
TOK_TMP_FILE 0, -1,-1, 0
TOK_SELECT 1, 0,2, 7
TOK_SELEXPR 1, 2,2, 7
TOK_TABLE_OR_COL 1, 2,2, 7
id 1, 2,2, 7
TOK_WHERE 1, 8,29, 26
TOK_SUBQUERY_EXPR 1, 10,29, 26
TOK_SUBQUERY_OP 1, 10,10, 26
exists 1, 10,10, 26
TOK_QUERY 1, 11,29, 48
TOK_FROM 1, 16,18, 48
TOK_TABREF 1, 18,18, 48
TOK_TABNAME 1, 18,18, 48
emp3 1, 18,18, 48
TOK_INSERT 0, -1,28, 0
TOK_DESTINATION 0, -1,-1, 0
TOK_DIR 0, -1,-1, 0
TOK_TMP_FILE 0, -1,-1, 0
TOK_SELECT 1, 12,14, 40
TOK_SELEXPR 1, 14,14, 40
TOK_TABLE_OR_COL 1, 14,14, 40
id 1, 14,14, 40
TOK_WHERE 1, 20,28, 66
= 1, 22,28, 66
. 1, 22,24, 63
TOK_TABLE_OR_COL 1, 22,22, 59
emp2 1, 22,22, 59
id 1, 24,24, 64
. 1, 26,28, 71
TOK_TABLE_OR_COL 1, 26,26, 67
emp3 1, 26,26, 67
id 1, 28,28, 72
scala.NotImplementedError: No parse rules for ASTNode type: 864, text: TOK_SUBQUERY_EXPR :
TOK_SUBQUERY_EXPR 1, 10,29, 26
TOK_SUBQUERY_OP 1, 10,10, 26
exists 1, 10,10, 26
TOK_QUERY 1, 11,29, 48
TOK_FROM 1, 16,18, 48
TOK_TABREF 1, 18,18, 48
TOK_TABNAME 1, 18,18, 48
emp3 1, 18,18, 48
TOK_INSERT 0, -1,28, 0
TOK_DESTINATION 0, -1,-1, 0
TOK_DIR 0, -1,-1, 0
TOK_TMP_FILE 0, -1,-1, 0
TOK_SELECT 1, 12,14, 40
TOK_SELEXPR 1, 14,14, 40
TOK_TABLE_OR_COL 1, 14,14, 40
id 1, 14,14, 40
TOK_WHERE 1, 20,28, 66
= 1, 22,28, 66
. 1, 22,24, 63
TOK_TABLE_OR_COL 1, 22,22, 59
emp2 1, 22,22, 59
id 1, 24,24, 64
. 1, 26,28, 71
TOK_TABLE_OR_COL 1, 26,26, 67
emp3 1, 26,26, 67
id 1, 28,28, 72
" +
org.apache.spark.sql.hive.HiveQl$.nodeToExpr(HiveQl.scala:1721)
; (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)