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. |
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. |
Free forum by Nabble | Edit this page |