Persisting Objects thru Phoenix

2015-03-18 Thread Anirudha Khanna
Hi, We are evaluating using Phoenix over HBase for persisting relational data. Has anyone tried doing something similar? Any experience reports would be really helpful. Quick note, some of our objects have upto 3 - 4 levels of parent - child relations. Cheers, Anirudha

Re: Connection params on phoenix

2015-03-18 Thread Gabriel Reid
You can't set auto-commit via the connection properties or JDBC url in version 3.0.0. However, this is possible (via the AutoCommit property) as of version 3.3 and 4.3. Other client-side properties can be set via the Properties object passed in to DriverManager.connect. - Gabriel On Wed, Mar

JPA-Phoenix/HBase

2015-03-18 Thread Kumar Palaniappan
We are exploring using a JPA implementation to persist objects into HBase using Phoenix SQL. Curious to know if anyone is exploring the same. Appreciate the sync-up.

Re: Fwd: java.lang.IllegalAccessError: com/google/protobuf/HBaseZeroCopyByteString

2015-03-18 Thread Samarth Jain
You also want to make sure that you are using compatible versions of client and server jars: phoenix-core version is 4.3.0 and phoenix-server.jar version is 4.2.3 are *NOT* compatible. The server side jar version should always be the same or newer (in version) than the client side jar. In

Re: Persisting Objects thru Phoenix

2015-03-18 Thread Thomas D'Silva
Anirudha At Salesforce, one of the use cases Phoenix and HBase is used for is storing immutable event data such as login information. We periodically run aggregate queries to generate metrics eg. number of logins per user. We select the columns of the primary key based on the filters used while

Re: Fwd: java.lang.IllegalAccessError: com/google/protobuf/HBaseZeroCopyByteString

2015-03-18 Thread Josh Mahonin
Have you tried adding hbase-protocol to the SPARK_CLASSPATH? That worked for me to get Spark playing nicely with Phoenix. On Tue, Mar 17, 2015 at 6:15 PM, Andrew Purtell apurt...@apache.org wrote: This is HBASE-8 (https://issues.apache.org/jira/browse/HBASE-8). Looks like someone else