[ https://issues.apache.org/jira/browse/SPARK-4154?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14190462#comment-14190462 ]
Apache Spark commented on SPARK-4154: ------------------------------------- User 'ravipesala' has created a pull request for this issue: https://github.com/apache/spark/pull/3017 > Query does not work if it has "not between " in Spark SQL and HQL > ----------------------------------------------------------------- > > Key: SPARK-4154 > URL: https://issues.apache.org/jira/browse/SPARK-4154 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 1.1.0 > Reporter: Ravindra Pesala > Assignee: Ravindra Pesala > > if the query contains "not between" does not work. > {code} > SELECT * FROM src where key not between 10 and 20 > {code} > It gives the following error > {code} > Exception in thread "main" java.lang.RuntimeException: > Unsupported language features in query: SELECT * FROM src where key not > between 10 and 20 > TOK_QUERY > TOK_FROM > TOK_TABREF > TOK_TABNAME > src > TOK_INSERT > TOK_DESTINATION > TOK_DIR > TOK_TMP_FILE > TOK_SELECT > TOK_SELEXPR > TOK_ALLCOLREF > TOK_WHERE > TOK_FUNCTION > between > KW_TRUE > TOK_TABLE_OR_COL > key > 10 > 20 > scala.NotImplementedError: No parse rules for ASTNode type: 256, text: > KW_TRUE : > KW_TRUE > " + > > org.apache.spark.sql.hive.HiveQl$.nodeToExpr(HiveQl.scala:1088) > > at scala.sys.package$.error(package.scala:27) > at org.apache.spark.sql.hive.HiveQl$.createPlan(HiveQl.scala:251) > at > org.apache.spark.sql.hive.ExtendedHiveQlParser$$anonfun$hiveQl$1.apply(ExtendedHiveQlParser.scala:50) > at > org.apache.spark.sql.hive.ExtendedHiveQlParser$$anonfun$hiveQl$1.apply(ExtendedHiveQlParser.scala:49) > at scala.util.parsing.combinator.Parsers$Success.map(Parsers.scala:136) > at scala.util.parsing.combinator.Parsers$Success.map(Parsers.scala:135) > at > scala.util.parsing.combinator.Parsers$Parser$$anonfun$map$1.apply(Parsers.scala:242) > at > scala.util.parsing.combinator.Parsers$Parser$$anonfun$map$1.apply(Parsers.scala:242) > at > scala.util.parsing.combinator.Parsers$$anon$3.apply(Parsers.scala:222) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org