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 2016/01/24 04:13:39 UTC
[jira] [Updated] (PHOENIX-1615) Problem using PDataType.DOUBLE
[ https://issues.apache.org/jira/browse/PHOENIX-1615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor updated PHOENIX-1615:
----------------------------------
Summary: Problem using PDataType.DOUBLE (was: [PHOENIX] Problem using PDataType.DOUBLE)
> Problem using PDataType.DOUBLE
> ------------------------------
>
> Key: PHOENIX-1615
> URL: https://issues.apache.org/jira/browse/PHOENIX-1615
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.1.0
> Environment: Linux Suse11 SP3 + Hbase 0.98.7-hadoop2 + Phoenix 4.1.x
> Reporter: Laveine Frederic
>
> We’re using HBase 0.98.7-hadoop2 with Phoenix (phoenix-4.1.0-server-hadoop2.jar) and we have some problems with PDataType.Double
> When we look with HBase Shell, the data are good (except sign which is flipped but it’s normal)
> hbase(main):010:0> scan 'RESM_RESULTAT_RUBRIQUE', {STARTROW => 'DRO050/201405/02003027 ', ENDROW => 'DRO050/201405/02003027~', COLUMNS => ['F:R3957_1_01_MNT:toDouble']}
> ROW COLUMN+CELL
> DRO050/201405/02003027//20141124102508 column=F:R3957_1_01_MNT, timestamp=1422362595520, value=-5.76
> hbase(main):005:0> scan 'RESM_RESULTAT_RUBRIQUE', {STARTROW => 'DRO050/201405/02000937 ', ENDROW => 'DRO050/201405/02000937~', COLUMNS => ['F:R3957_1_01_MNT:toDouble']}
> ROW COLUMN+CELL
> DRO050/201405/02000937//20141124102508 column=F:R3957_1_01_MNT, timestamp=1422362590187, value=-2.53
> But if we use Phoenix sqlline.py, Phoenix API through Squirrel or Java Code, all the values are not well restituted (Ex : 2.5300000000000002 instead of 2.53)
> 0: jdbc:phoenix:lx1675> select PAC, MOIS_DE_PAIE, MATRICULE, DATE_TRAITEMENT, R3957_1_01_MNT from RESM_RESULTAT_RUBRIQUE (R3957_1_01_MNT Double)
> . . . . . . . . . . . > where PAC='DRO050' and MOIS_DE_PAIE='201405' and MATRICULE in ('02000937','02003027');
> +------------+--------------+------------+---------------------+----------------+
> | PAC | MOIS_DE_PAIE | MATRICULE | DATE_TRAITEMENT | R3957_1_01_MNT |
> +------------+--------------+------------+---------------------+----------------+
> | DRO050 | 201405 | 02000937 | 2014-11-24 | 2.5300000000000002 |
> | DRO050 | 201405 | 02003027 | 2014-11-24 | 5.76 |
> +------------+--------------+------------+---------------------+----------------+
> 2 rows selected (0.219 seconds)
> Thanks for your help
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)