[
https://issues.jboss.org/browse/TEIID-3619?page=com.atlassian.jira.plugin...
]
Juraj Duráni commented on TEIID-3619:
-------------------------------------
Probably the simplest workaround is to set 'autocommit' for every new connection
(driver's property phoenix.connection.autoCommit).
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: Kylin Soong
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_Phoen...
section "2. Using java"
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)