[
https://issues.jboss.org/browse/TEIID-3619?page=com.atlassian.jira.plugin...
]
Kylin Soong edited comment on TEIID-3619 at 8/11/15 10:41 AM:
--------------------------------------------------------------
In my previous test, I have found Phoenix Connection AutoCommit default is false,
doesn't like other vendors.
Can you share the vdb file/test code, and DDL for create/map table in Phoenix?
was (Author: kylin):
Can you share the vdb file/test code, and DDL for create/map table in Phoenix?
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)