[teiid-issues] [JBoss JIRA] (TEIID-3623) HBase translator - boolean and biginteger values are not translated correctly

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3623?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13160675#comment-13160675 ] 

RH Bugzilla Integration commented on TEIID-3623:
------------------------------------------------

Filip Elias <felias at redhat.com> changed the Status of [bug 1252385|https://bugzilla.redhat.com/show_bug.cgi?id=1252385] from VERIFIED to CLOSED

> HBase translator - boolean and biginteger values are not translated correctly
> -----------------------------------------------------------------------------
>
>                 Key: TEIID-3623
>                 URL: https://issues.jboss.org/browse/TEIID-3623
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.7.1.6_2
>         Environment: Hbase: 1.1.1
> Phoenix: 4.5.0-HBase-1.1
>            Reporter: Juraj Duráni
>            Assignee: Steven Hawkins
>             Fix For: 8.7.1.6_2, 8.12
>
>         Attachments: insert_biginteger.log, inser_boolean.log
>
>
> *1. Boolean values:* The Teiid translates the value true/false as 1/0, but HBase does not support integer representation of boolean values [1].
> *2. BigInteger values ( <= -2):* Teiid's bigInteger data type is wider than HBase's bigint (as wide as long) type, so it make sense to define column in HBase as e.g. _decimal(30,0)_ and map it to Teiid's biginteger type.
> From Teiid's point of view: There is no problem if inserted value is greater than or equal to -1. But if the value is less than -1, then a ClassCastException is thrown [2]. Phoenix driver require something like "UPSERT INTO smalla (intkey, bigintegervalue) VALUES (1, -10 *.0*)"
> [1]
> *Query:* insert into hbase.smalla (intkey, booleanvalue) values (55, true)
> *Column definition:*
> - source: booleanvalue boolean
> - VDB: BooleanValue boolean OPTIONS (nameinsource 'booleanvalue', NATIVE_TYPE 'boolean')
> *Stack trace:*
> insert_boolean.log
> [2]
> *Query:* insert into hbase.smalla (intkey, bigintegervalue) values (55, -10)
> *Column definition:*
> - source: bigintegervalue decimal(20,0)
> - VDB: BigIntegerValue biginteger OPTIONS (nameinsource 'bigintegervalue', NATIVE_TYPE 'decimal')
> *Stack trace:*
> insert_biginteger.log



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)