[
https://issues.apache.org/jira/browse/DRILL-756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chun Chang resolved DRILL-756.
------------------------------
Resolution: Fixed
Fix Version/s: (was: Future)
0.6.0
#Thu Oct 02 17:49:48 PDT 2014
git.commit.id.abbrev=29dde76
It works with this commit:
0: jdbc:drill:schema=dfs> select radians(cast(c_decimal28 as decimal(28,9)))
from data where c_row < 12;
+------------+
| EXPR$0 |
+------------+
| 0.0 |
| 0.017453292519943295 |
| 2154727.451989918 |
| 1.7453292502490003E7 |
| -1.7453292502490003E7 |
| 1.7453292519943295E-10 |
| -1.7453292519943295E-10 |
| 215.4727451989918 |
| 2154727.454144645 |
| 1.7453292519943296E16 |
| -1.7453292519943296E16 |
+------------+
11 rows selected (0.171 seconds)
> radians function on decimal28 fails with unsupported operation exception
> ------------------------------------------------------------------------
>
> Key: DRILL-756
> URL: https://issues.apache.org/jira/browse/DRILL-756
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Affects Versions: Future
> Reporter: Chun Chang
> Assignee: Chun Chang
> Priority: Minor
> Fix For: 0.6.0
>
>
> drill:
> 0: jdbc:drill:schema=dfs> select radians(cast(c_decimal28 as decimal(28,9)))
> from data where c_row < 12;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
> running query.[error_id: "15740859-e9e4-4f0e-84a6-063cf6985e15"
> endpoint {
> address: "qa-node120.qa.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while running fragment. < UnsupportedOperationException:[
> DECIMAL28SPARSE ]"
> ]
> Error: exception while executing query (state=,code=0)
> postgres:
> foodmart=# select radians(cast(c_decimal28 as decimal(28,9))) from data where
> c_row < 12;
> radians
> -----------------------
> 0
> 0.0174532925199433
> 2154727.45198992
> 17453292.50249
> -17453292.50249
> 1.74532925199433e-10
> -1.74532925199433e-10
> 215.472745198992
> 2154727.45414465
> 1.74532925199433e+16
> -1.74532925199433e+16
> (11 rows)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
