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
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
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.
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
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
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