Java (ORM like) client library for apache phoenix is open sourced

2016-03-24 Thread Vijay Vangapandu
Hi Guys, As I mentioned, we have been working on ORM library for java to apache phoenix – Hbase. We recently open sourced the project, this library is in production for more than 4 months and system is stable. I hope this will complement the phoenix library and makes java integration simple.

Re: How do I query the phoenix query server?

2016-03-24 Thread Steve Terrell
As I recall, I did try setting auto commit to True, but it did not help. With/without auto commit, my writes would work soon after I started SQuirreL Client, but always stopped working after some time passed until I restarted the client. I discovered I needed the extra jar when I had a complex

Re: Kerberos ticket renewal

2016-03-24 Thread Josh Elser
Also, setting -Dsun.security.krb5.debug=true when you launch your Java application will give you lots of very helpful information about what is happening "under the hood". Sanooj Padmakumar wrote: Thanks Josh and everyone else .. Shall try this suggestion On 22 Mar 2016 09:36, "Josh Elser"

Re: How do I query the phoenix query server?

2016-03-24 Thread Josh Elser
Correct, James: Phoenix-4.7.0 uses Calcite-1.6.0. This included lots of goodies includes commit/rollback support. Phoenix-4.6.0 used Calcite-1.3.0. In general, if you want to use the QueryServer, I'd strongly recommend trying to go with Phoenix-4.7.0. You'll inherit *lots* of

Re: How do I query the phoenix query server?

2016-03-24 Thread James Taylor
Steve, For deletes and upsets through the query server in 4.6, did you set auto commit to be true by default (set phoenix.connection.autoCommit to true)? In 4.7 this has been fixed, but prior to this, I believe commit and rollback were a noop. Is that right, Josh? Thanks, James On Thursday, March

Re: How do I query the phoenix query server?

2016-03-24 Thread Steve Terrell
I forgot to mention, although the docs say only one jar is needed, I found that I also had to have commons-collections-3.2.1.jar in the class path, too. On Thu, Mar 24, 2016 at 10:07 AM, Steve Terrell wrote: > Hi! Everything I say below pertains only to Phoenix 4.6.0.

Re: How do I query the phoenix query server?

2016-03-24 Thread Steve Terrell
Hi! Everything I say below pertains only to Phoenix 4.6.0. Don't know what changes in 4.7.0. Judging from the port number, you must be using the thin client server. Have you seen this page? https://phoenix.apache.org/server.html . It has JDBC info. I got the thin client jar to work with

csv bulk load with auto increment

2016-03-24 Thread ajay khandelwal
Hello Group, Is there a utility in phoenix which allows to bulk load csv data along with option to auto increment a particular column. The use case I have is that .. there is a csv file with bunch of columns but none of them is unique in nature. Hence I need a unique column to create PK.