Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-5410

Error parsing scientific notation in a select statement

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.0
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:

      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] ...

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              hmf Hugo Ferrira
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: