You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Ravindra Pesala (JIRA)" <ji...@apache.org> on 2014/11/03 16:27:35 UTC
[jira] [Created] (SPARK-4207) Query which has syntax like 'not
like' is not working in Spark SQL
Ravindra Pesala created SPARK-4207:
--------------------------------------
Summary: Query which has syntax like 'not like' is not working in Spark SQL
Key: SPARK-4207
URL: https://issues.apache.org/jira/browse/SPARK-4207
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 1.1.0
Reporter: Ravindra Pesala
Queries which has 'not like' is not working in Spark SQL. Same works in Spark HiveQL.
{code}
sql("SELECT * FROM records where value not like 'val%'")
{code}
The above query fails with below exception
{code}
Exception in thread "main" java.lang.RuntimeException: [1.39] failure: ``IN'' expected but `like' found
SELECT * FROM records where value not like 'val%'
^
at scala.sys.package$.error(package.scala:27)
at org.apache.spark.sql.catalyst.AbstractSparkSQLParser.apply(SparkSQLParser.scala:33)
at org.apache.spark.sql.SQLContext$$anonfun$1.apply(SQLContext.scala:75)
at org.apache.spark.sql.SQLContext$$anonfun$1.apply(SQLContext.scala:75)
at org.apache.spark.sql.catalyst.SparkSQLParser$$anonfun$org$apache$spark$sql$catalyst$SparkSQLParser$$others$1.apply(SparkSQLParser.scala:186)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org