[jira] [Commented] (SPARK-7099) Floating point literals cannot be specified using exponent

2015-10-13 Thread kevin yu (JIRA) 

[ 
https://issues.apache.org/jira/browse/SPARK-7099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14955790#comment-14955790
 ] 

kevin yu commented on SPARK-7099:
-

Hello Ryan: Can you close this JIRA? Thanks.
Kevin

> 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

[jira] [Commented] (SPARK-7099) Floating point literals cannot be specified using exponent

2015-10-13 Thread Ryan Pham (JIRA) 

[ 
https://issues.apache.org/jira/browse/SPARK-7099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14955962#comment-14955962
 ] 

Ryan Pham commented on SPARK-7099:
--

Hi Kevin. It seems like I can't close this JIRA since I'm not its reporter. 
Unfortunately, Peter is no longer with IBM, so I can't contact him to close it.

> 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

[jira] [Commented] (SPARK-7099) Floating point literals cannot be specified using exponent

2015-10-10 Thread kevin yu (JIRA) 

[ 
https://issues.apache.org/jira/browse/SPARK-7099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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

[jira] [Commented] (SPARK-7099) Floating point literals cannot be specified using exponent

2015-08-25 Thread Ryan Pham (JIRA) 

[ 
https://issues.apache.org/jira/browse/SPARK-7099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14711678#comment-14711678
 ] 

Ryan Pham commented on SPARK-7099:
--

We've moved to spark 1.3.1, but it seems like the exponent format is still not 
supported. The select works when the number is expanded.

SELECT cdescription179858030, cbigintcol823807900, cintcol1455799299, 
csmallintcol2049749987, ctinyintcol1324387732 FROM TABLE_1 WHERE 
(cbigintcol823807900 = 1E6)
15/08/25 10:44:40 ERROR AbstractFunctionalTests: java.lang.RuntimeException: 
[1.179] failure: ``)'' expected but identifier E6 found


 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

[jira] [Commented] (SPARK-7099) Floating point literals cannot be specified using exponent

2015-05-01 Thread Peter Hagelund (JIRA) 

[ 
https://issues.apache.org/jira/browse/SPARK-7099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14523747#comment-14523747
 ] 

Peter Hagelund commented on SPARK-7099:
---

Good news.  We're switching to 1.3.1 anyway, so for us this solves the issue.

 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

[jira] [Commented] (SPARK-7099) Floating point literals cannot be specified using exponent

2015-04-23 Thread Peter Hagelund (JIRA) 

[ 
https://issues.apache.org/jira/browse/SPARK-7099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14509894#comment-14509894
 ] 

Peter Hagelund commented on SPARK-7099:
---

Yes, it's quite common in fact. It makes reuse of SQL much easier - and should 
be an easy fix.

 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