[SPARK-5410] Error parsing scientific notation in a select statement

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Component/s: SQL
• Labels: numeric parsing sql
• Assignee: Unassigned
• Reporter: Hugo Ferrira
• Created: 26/Jan/15 16:37
• Updated: 15/Sep/15 21:37
• Resolved: 15/Sep/15 21:37

Description

I am using the Cassandra DB and am attempting a select through the Spark SQL interface.

SELECT * from key_value WHERE f2 < 2.2E10

And get the following error (no error if I remove the E10):

[info] - should be able to select a subset of applicable features *** FAILED ***
[info] java.lang.RuntimeException: [1.39] failure: ``UNION'' expected but identifier E10 found
[info]
[info] SELECT * from key_value WHERE f2 < 2.2E10
[info] ^
[info] at scala.sys.package$.error(package.scala:27)
[info] at org.apache.spark.sql.catalyst.AbstractSparkSQLParser.apply(SparkSQLParser.scala:33)
[info] at org.apache.spark.sql.SQLContext$$anonfun$1.apply(SQLContext.scala:79)
[info] at org.apache.spark.sql.SQLContext$$anonfun$1.apply(SQLContext.scala:79)
[info] at org.apache.spark.sql.catalyst.SparkSQLParser$$anonfun$org$apache$spark$sql$catalyst$SparkSQLParser$$others$1.apply(SparkSQLParser.scala:174)
[info] at org.apache.spark.sql.catalyst.SparkSQLParser$$anonfun$org$apache$spark$sql$catalyst$SparkSQLParser$$others$1.apply(SparkSQLParser.scala:173)
[info] at scala.util.parsing.combinator.Parsers$Success.map(Parsers.scala:136)
[info] at scala.util.parsing.combinator.Parsers$Success.map(Parsers.scala:135)
[info] at scala.util.parsing.combinator.Parsers$Parser$$anonfun$map$1.apply(Parsers.scala:242)
[info] at scala.util.parsing.combinator.Parsers$Parser$$anonfun$map$1.apply(Parsers.scala:242)
[info] ...