You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@carbondata.apache.org by "Prabhat Kashyap (JIRA)" <ji...@apache.org> on 2016/10/28 07:59:59 UTC
[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)