I had set auto.commit = true in my hbase-site.xml bit don't think the JDBC connections are picking that up.
How do I turn it on in the connection or explicitly make the commit? On Sat, Nov 26, 2016 at 3:13 PM, James Taylor <[email protected]> wrote: > Are you committing the data after the upsert (either by turning on auto > commit on the connection or doing an explicit commit)? > > On Fri, Nov 25, 2016 at 12:20 PM Matt L <[email protected]> wrote: > >> Hello All! >> >> Through Zeppelin I am trying to insert data into a table created by >> Phoenix: >> >> %phoenix >> create table “test" (id bigint PRIMARY KEY, “test"."ip" varchar, >> “test"."request_date" bigint, “test"."data" varchar) >> >> %phoenix >> upsert into “test" values (1, '0.0.0.0', 1, 'data') >> >> %phoenix >> select * from "test" limit 100 >> >> returns no results. >> >> When I do the same thing through either sqlline-thin or sqlline (passing >> in ZK with /hbase-unsecure) I am able to UPSERT and see the data when I >> Select *. >> >> Am i missing some configuration or property when I am connecting from a >> remote client? >> >> I have tried playing around with “phoenix.mutate.batchSize” setting it >> to 1 and making sure phoenix.connection.auto.commit is “true”. >> >> I don’t see any errors or logs when I try to upsert through zeppelin. >> >> Thanks fro the help! >> >
