You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2015/11/13 23:32:10 UTC
[jira] [Updated] (PHOENIX-2380) Use smallest sized type preserving
precision for float/double/Decimal
[ https://issues.apache.org/jira/browse/PHOENIX-2380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor updated PHOENIX-2380:
----------------------------------
Summary: Use smallest sized type preserving precision for float/double/Decimal (was: 'decimal' columns can only hold 'float' values)
> Use smallest sized type preserving precision for float/double/Decimal
> ---------------------------------------------------------------------
>
> 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
> Labels: newbie
>
> {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 also applies for values smaller than the minimum float value
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)