回复：[jira] [Created] (CARBONDATA-344) Exists query not working

[杰]

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)