[ https://issues.apache.org/jira/browse/SPARK-7099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14951661#comment-14951661 ]
kevin yu commented on SPARK-7099: --------------------------------- Hello Ryan: I tried the similar query with exponent format on spark-submit and spark-shell on 1.5.1, both worked, can you try on 1.5 or the latest version? scala> sqlContext.sql("LOAD DATA LOCAL INPATH 'sql/hive/src/test/resources/data/files/kv1.txt' INTO TABLE src") res2: org.apache.spark.sql.DataFrame = [result: string] scala> sqlContext.sql("FROM src select key WHERE key = 1E6 ").collect().foreach(println) scala> sqlContext.sql("FROM src select key WHERE key < 1E6 ").collect().foreach(println) [238] [86] [311] [27] [165] [409] [255] [278] [98] > Floating point literals cannot be specified using exponent > ---------------------------------------------------------- > > Key: SPARK-7099 > URL: https://issues.apache.org/jira/browse/SPARK-7099 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 1.2.1 > Environment: Windows, Linux, Mac OS X > Reporter: Peter Hagelund > Priority: Minor > > Floating point literals cannot be expressed in scientific notation using an > exponent, like e.g. 1.23E4. -- 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