phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt L <matt.l...@gmail.com>
Subject Re: Upsert works using /sqlline-thin.py and /sqlline.py but not in Zeppelin or other remote jdbc clients
Date Sat, 26 Nov 2016 20:39:53 GMT
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 <jamestaylor@apache.org>
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 <matt.liem@gmail.com> 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!
>>
>

Mime
View raw message