Bug 1252340
Summary: | HBase translator - INSERT could rewrite the data | ||
---|---|---|---|
Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | Juraj Duráni <jdurani> |
Component: | Teiid, Documentation | Assignee: | David Le Sage <dlesage> |
Status: | CLOSED CURRENTRELEASE | QA Contact: | Juraj Duráni <jdurani> |
Severity: | unspecified | Docs Contact: | |
Priority: | unspecified | ||
Version: | 6.2.0 | CC: | atangrin, vhalbert |
Target Milestone: | CR2 | Keywords: | Documentation |
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: | 2015-09-29 00:57:12 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: |
Description
Juraj Duráni
2015-08-11 08:23:49 UTC
Kylin Soong <ksoong> updated the status of jira TEIID-3622 to Closed Juraj Duráni <jdurani> updated the status of jira TEIID-3622 to Reopened Need to document the HBase translator behavior: The HBase translator will rewrite the data in the following scenario: Standard behavior: Queries: CREATE TABLE TableA (id integer PRIMARY KEY, name varchar(10)); INSERT INTO TableA (id, name) VALUES (1, 'name1'); INSERT INTO TableA (id, name) VALUES (1, 'name2'); ---> this command will fail because uniqueness of the PRIMARY KEY would be corrupted Table after queries: id name 1 name1 Behavior of the HBase translator: Queries: CREATE TABLE TableA (id integer PRIMARY KEY, name varchar(10)); INSERT INTO TableA (id, name) VALUES (1, 'name1'); INSERT INTO TableA (id, name) VALUES (1, 'name2'); ---> this command will NOT fail and will rewrite the data Table after queries: id name 1 name2 The behavior is that Teiid will convert INSERT into UPSERT, for which is sent to HBase. Info about HBase behaviour added to topic "JDBC Translator: Translator Types" in the Reference Guide. Steven Hawkins <shawkins> updated the status of jira TEIID-3622 to Resolved Steven Hawkins <shawkins> updated the status of jira TEIID-3622 to Closed |