Bug 1252385

Summary: HBase translator - boolean and biginteger values are not translated correctly
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Juraj Duráni <jdurani>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED CURRENTRELEASE QA Contact: Juraj Duráni <jdurani>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: atangrin, vhalbert
Target Milestone: CR1Keywords: QA-Closed
Target Release: 6.2.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Hbase: 1.1.1 Phoenix: 4.5.0-HBase-1.1
Last Closed: 2016-02-10 08:48:49 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
insert boolean
none
insert biginteger none

Description Juraj Duráni 2015-08-11 09:46:07 UTC 
Created attachment 1061420 [details]
insert boolean

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
Comment 1 Juraj Duráni 2015-08-11 09:46:30 UTC 
Created attachment 1061421 [details]
insert biginteger
Comment 2 JBoss JIRA Server 2015-08-11 21:23:19 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-3623 to Resolved
Comment 3 JBoss JIRA Server 2015-10-11 19:18:34 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-3623 to Closed