Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1252307

Summary: HBase translator - INSERT and UPDATE statements have no effect
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, dlesage, vhalbert
Target Milestone: ER1   
Target Release: 6.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
When using the HBase translator, Teiid's INSERT and UPDATE statement have no effect. Both statements are translated to UPSERT which needs Connection.commit() to take effect.
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-08-24 11:42:08 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:
Bug Depends On:    
Bug Blocks: 1252333    

Description Juraj Duráni 2015-08-11 07:08:02 UTC
Teiid's INSERT and UPDATE statement have no effect [1]. Both statements are translated as UPSERT which needs Connection.commit() to take effect [2].

[1]
select intkey, stringkey from hbase.smalla where intkey = 5
|intkey | stringkey |
|5      | 5         |

update hbase.smalla set stringkey = '1000' where intkey = 5
no exception here
select intkey, stringkey from hbase.smalla where intkey = 5
|intkey | stringkey |
|5      | 5         |

[2]
http://phoenix.apache.org/faq.html#I_want_to_get_started_Is_there_a_Phoenix_Hello_World section "2. Using java"

Comment 1 JBoss JIRA Server 2015-08-13 12:31:36 UTC
Kylin Soong <ksoong> updated the status of jira TEIID-3619 to Resolved

Comment 2 Van Halbert 2015-08-18 14:04:59 UTC
Can be targeted to DV 6.2 rollup if needed.

Comment 3 JBoss JIRA Server 2016-01-26 18:00:54 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-3619 to Closed