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

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13097787#comment-13097787 ] 

Steven Hawkins commented on TEIID-3622:
---------------------------------------

Teiid does support a limited merge statement, which is similar to an upsert. We would have to update the engine/translators to support pushdown to fully address this issue.  

Otherwise we either should just document the upsert behavior (I believe mongodb is similar) or we'd have to just not support updates (although delete would be fine, we can't specify just supporting it currently).

> 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)