[teiid-issues] [JBoss JIRA] (TEIID-3622) HBase translator - INSERT could rewrite the data
Juraj Duráni (JIRA)
issues at jboss.org
Tue Aug 11 04:22:01 EDT 2015
Juraj Duráni created TEIID-3622:
-----------------------------------
Summary: HBase translator - INSERT could rewrite the data
Key: TEIID-3622
URL: https://issues.jboss.org/browse/TEIID-3622
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
The HBase translator translates INSERT as UPSERT, which is an "alias" for both INSERT and UPDATE statement. It means, if user issues same INSERT statement twice, no exception is thrown [1]. I expect that [2] could rewrite the data.
*Additional note*: I was not able to verify my assumption because of https://issues.jboss.org/browse/TEIID-3619
[1]
INSERT INTO smalla (intkey) VALUES (55) is translated as UPSERT INTO smalla (intkey) VALUES (55)
http://phoenix.apache.org/language/index.html#upsert_values
[2]
INSERT INTO smalla (intkey, name) VALUES (1, 'name1')
INSERT INTO smalla (intkey, name) VALUES (1, 'name2')
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
More information about the teiid-issues
mailing list