[ 
https://issues.apache.org/jira/browse/SPARK-6768?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Zhongshuai Pei updated SPARK-6768:
----------------------------------
    Description: 
Do not support sql like that :
...
select cast(12.2056999 as float) from testData limit 1
union
select cast(12.2041 as decimal(7, 4)) from testData limit 1
...
```
select cast(12.2056999 as double) from testData limit 1
union
select cast(12.2041 as decimal(7, 4)) from testData limit 1
```
```
select cast(1241.20 as decimal(6, 2)) from testData limit 1
union
select cast(1.204 as decimal(5, 3)) from testData limit 1
```


  was:
Do not support sql like that :
```
select cast(12.2056999 as float) from testData limit 1
union
select cast(12.2041 as decimal(7, 4)) from testData limit 1
```
```
select cast(12.2056999 as double) from testData limit 1
union
select cast(12.2041 as decimal(7, 4)) from testData limit 1
```
```
select cast(1241.20 as decimal(6, 2)) from testData limit 1
union
select cast(1.204 as decimal(5, 3)) from testData limit 1
```



> Do not support "float/double union decimal and decimal(a ,b) union decimal(c, 
> d)"
> ---------------------------------------------------------------------------------
>
>                 Key: SPARK-6768
>                 URL: https://issues.apache.org/jira/browse/SPARK-6768
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>            Reporter: Zhongshuai Pei
>
> Do not support sql like that :
> ...
> select cast(12.2056999 as float) from testData limit 1
> union
> select cast(12.2041 as decimal(7, 4)) from testData limit 1
> ...
> ```
> select cast(12.2056999 as double) from testData limit 1
> union
> select cast(12.2041 as decimal(7, 4)) from testData limit 1
> ```
> ```
> select cast(1241.20 as decimal(6, 2)) from testData limit 1
> union
> select cast(1.204 as decimal(5, 3)) from testData limit 1
> ```



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

Reply via email to