No error on executing 'IN' operator without specifying any column name

[prabhatkashyap]

Hello,

I've tried to use the following query in carbon data and hive :

select * from mytable where IN(1,2);

While executing it on carbon data it gave me output of "No row selected" but I think there should be an exception/error. whereas when executed in Hive it gave me parse exception:

FAILED: ParseException line 1:31 cannot recognize input near 'IN' '(' '1' in expression specification

Please confirm.

Thanks

[杰]

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.


regards
jay
 






------------------ Original ------------------
From:  "prabhatkashyap";<[hidden email]>;
Date:  Fri, Oct 28, 2016 04:07 PM
To:  "dev"<[hidden email]>;

Subject:  No error on executing 'IN' operator without specifying any columnname



Hello,

I've tried to use the following query in carbon data and hive :



While executing it on carbon data it gave me output of "/No row selected/"
but I think there should be an exception/error. whereas when executed in
Hive it gave me parse exception:



Please confirm.

Thanks




--
View this message in context: http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/No-error-on-executing-IN-operator-without-specifying-any-column-name-tp2424.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at Nabble.com.

[prabhatkashyap]

When ever I'm trying to run following command in HIVE:

select id from nt1 where nt1.id IN (select id from nt2);

it executes normally in HIVE, but the same query gives the following error in CARBONDATA :

org.apache.spark.sql.AnalysisException:
Unsupported language features in query: select id from emp4 where emp4.id IN (select id from emp5)
TOK_QUERY 1, 0,24, 15
  TOK_FROM 1, 4,6, 15
    TOK_TABREF 1, 6,6, 15
      TOK_TABNAME 1, 6,6, 15
        emp4 1, 6,6, 15
  TOK_INSERT 0, -1,24, 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,24, 34
      TOK_SUBQUERY_EXPR 1, 10,24, 34
        TOK_SUBQUERY_OP 1, 14,14, 34
          IN 1, 14,14, 34
        TOK_QUERY 1, 16,24, 53
          TOK_FROM 1, 21,23, 53
            TOK_TABREF 1, 23,23, 53
              TOK_TABNAME 1, 23,23, 53
                emp5 1, 23,23, 53
          TOK_INSERT 0, -1,19, 0
            TOK_DESTINATION 0, -1,-1, 0
              TOK_DIR 0, -1,-1, 0
                TOK_TMP_FILE 0, -1,-1, 0
            TOK_SELECT 1, 17,19, 45
              TOK_SELEXPR 1, 19,19, 45
                TOK_TABLE_OR_COL 1, 19,19, 45
                  id 1, 19,19, 45
        . 1, 10,12, 30
          TOK_TABLE_OR_COL 1, 10,10, 26
            emp4 1, 10,10, 26
          id 1, 12,12, 31

scala.NotImplementedError: No parse rules for ASTNode type: 864, text: TOK_SUBQUERY_EXPR :
TOK_SUBQUERY_EXPR 1, 10,24, 34
  TOK_SUBQUERY_OP 1, 14,14, 34
    IN 1, 14,14, 34
  TOK_QUERY 1, 16,24, 53
    TOK_FROM 1, 21,23, 53
      TOK_TABREF 1, 23,23, 53
        TOK_TABNAME 1, 23,23, 53
          emp5 1, 23,23, 53
    TOK_INSERT 0, -1,19, 0
      TOK_DESTINATION 0, -1,-1, 0
        TOK_DIR 0, -1,-1, 0
          TOK_TMP_FILE 0, -1,-1, 0
      TOK_SELECT 1, 17,19, 45
        TOK_SELEXPR 1, 19,19, 45
          TOK_TABLE_OR_COL 1, 19,19, 45
            id 1, 19,19, 45
  . 1, 10,12, 30
    TOK_TABLE_OR_COL 1, 10,10, 26
      emp4 1, 10,10, 26
    id 1, 12,12, 31
" +
         
org.apache.spark.sql.hive.HiveQl$.nodeToExpr(HiveQl.scala:1721)
          ; (state=,code=0)

Please confirm is it Carbon Data bug or Spark one.