[teiid-issues] [JBoss JIRA] (TEIID-3622) HBase translator - INSERT could rewrite the data

[Juraj Duráni (JIRA)]

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)