Chun Chang created DRILL-756:
--------------------------------

             Summary: 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
            Reporter: Chun Chang


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.2#6252)

Reply via email to