[
https://issues.apache.org/jira/browse/SPARK-4154?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Armbrust resolved SPARK-4154.
-------------------------------------
Resolution: Fixed
Fix Version/s: 1.2.0
Issue resolved by pull request 3017
[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
> Fix For: 1.2.0
>
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
