[teiid-issues] [JBoss JIRA] (TEIID-3619) HBase translator - INSERT and UPDATE statements have no effect

[Juraj Duráni (JIRA)]

Juraj Duráni created TEIID-3619:
-----------------------------------

             Summary: HBase translator - INSERT and UPDATE statements have no effect
                 Key: TEIID-3619
                 URL: https://issues.jboss.org/browse/TEIID-3619
             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


Teiid's INSERT and UPDATE statement have no effect [1]. Both statements are translated as UPSERT which needs Connection.commit() to take effect [2].

[1]
*select intkey, stringkey from hbase.smalla where intkey = 5*
|intkey|stringkey|
|5|5|
*update hbase.smalla set stringkey = '1000' where intkey = 5*
no exception here
*select intkey, stringkey from hbase.smalla where intkey = 5*
|intkey|stringkey|
|5|5|
[2]
http://phoenix.apache.org/faq.html#I_want_to_get_started_Is_there_a_Phoenix_Hello_World section "2. Using java"



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)