[teiid-issues] [JBoss JIRA] (TEIID-3622) HBase translator - INSERT could rewrite the data
Kylin Soong (JIRA)
issues at jboss.org
Wed Aug 12 04:32:02 EDT 2015
[ https://issues.jboss.org/browse/TEIID-3622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kylin Soong closed TEIID-3622.
------------------------------
Resolution: Won't Fix
As TEIID-3619, if auto commit be configured, this should work as your assumption. Feel free re-open if necessary.
> 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