drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chun Chang (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-756) radians function on decimal28 fails with unsupported operation exception
Date Mon, 06 Oct 2014 18:33:35 GMT

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

Mime
View raw message