Kevin Liew created PHOENIX-2380:
-----------------------------------
Summary: 'decimal' columns cannot hold the max 'float' value
Key: PHOENIX-2380
URL: https://issues.apache.org/jira/browse/PHOENIX-2380
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.5.0
Reporter: Kevin Liew
{noformat}
CREATE TABLE test.DECIMAL_TABLE(
KeyColumn VARCHAR(255) PRIMARY KEY,
Column1 DECIMAL(38, 0));
{noformat}
Phoenix will not upsert values larger than or equal to the max float value.
{noformat}
upsert into test.decimal_table values ('test', 3.402823466e+38);
java.sql.SQLException: error while executing SQL "upsert into
test.decimal_table values ('test', 3.402823466e+38)": response code 500
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:112)
at
org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:121)
at sqlline.Commands.execute(Commands.java:822)
at sqlline.Commands.sql(Commands.java:732)
at sqlline.SqlLine.dispatch(SqlLine.java:808)
at sqlline.SqlLine.begin(SqlLine.java:681)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:292)
Caused by: java.lang.RuntimeException: response code 500
at
org.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:45)
at
org.apache.calcite.avatica.remote.JsonService.apply(JsonService.java:207)
at
org.apache.calcite.avatica.remote.RemoteMeta.prepareAndExecute(RemoteMeta.java:169)
at
org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:477)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:109)
... 7 more
0: jdbc:phoenix:thin:url=http://localhost:876> upsert into test.decimal_table
values ('MaxFloat', 3.402823466e+37);
1 row affected (0.113 seconds)
{noformat}
or using the bulk loader tool
{noformat}
15/11/05 23:17:15 ERROR util.CSVCommonsLoader: Error upserting record
[MaxFloat, 3.402823466e+38]: ERROR 206 (22003): The data exceeds the max
capacity for the data type. value=340282346600000000000000000000000000000
columnName=COLUMN1
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
