phoenix + search engine

2019-11-24 Thread Nicolas Paris
hi there is an interesting project called elassandra[1] mixing apache cassandra and elasticsearch. The secondary indexes, and the text column are indexed with es. The interesting part is es is embedded within cassandra and both share the same JVM. The benefit of this, is rich indexes, aggregation

Re: Materialized views in Hbase/Phoenix

2019-10-11 Thread Nicolas Paris
> If one of the tables fails to write, we need some kind of a rollback > mechanism, > which is why I was considering a transaction. We cannot be in a partial state > where some of the ‘views’ are written and some aren’t. why not writing to tables to phoenix and if both succeed, then rename the o

Re: Phoenix Performances & Uses Cases

2018-10-29 Thread Nicolas Paris
Thanks Josh, On Mon, Oct 29, 2018 at 10:47:42AM -0400, Josh Elser wrote: > Use Hive when Hive does things well, and use Phoenix when Phoenix does > it well. That would be great. My concern is the phoenix "joins" do not compete with postgresql in my actual tests. Phoenix + hive is ok, however Phoe

Phoenix Performances & Uses Cases

2018-10-27 Thread Nicolas Paris
Hi I am benchmarking phoenix to better understand its strength and weaknesses. My basis is to compare to postgresql for OLTP workload and hive llap for OLAP workload. I am testing on a 10 computer cluster instance with hive (2.1) and phoenix (4.8) 220 GO RAM/32CPU versus a postgresql (9.6) 128GO

Re: Cannot access from jdbc

2018-05-23 Thread Nicolas Paris
ied by the hostname in the log message. > > Most of the time when you see this error, it's a result of HBase rejecting > the incoming request for a Kerberos authentication issue. > > > On 5/23/18 12:10 PM, Nicolas Paris wrote: > >> hi team >> >> I am hav

Re: Cannot access from jdbc

2018-05-23 Thread Nicolas Paris
Phoenix 4.7.0 made it into that fork. > > Thanks, > James > > On Wed, May 23, 2018 at 9:26 AM, Nicolas Paris > wrote: > >> Hi James. >> >> I tried to make the update myself but without success. >> This actualy a custom 4.7 version (here the commit

Re: Cannot access from jdbc

2018-05-23 Thread Nicolas Paris
t; > On Wed, May 23, 2018 at 9:10 AM, Nicolas Paris > wrote: > >> hi team >> >> I am having this error while trying to connect from a java program to a >> working phoenix 4.7 (hdp build) instance: >> >> >> Wed May 23 16:40:56 CEST 2018, null,

Cannot access from jdbc

2018-05-23 Thread Nicolas Paris
hi team I am having this error while trying to connect from a java program to a working phoenix 4.7 (hdp build) instance: Wed May 23 16:40:56 CEST 2018, null, java.net.SocketTimeoutException: callTimeout=6, callDuration=69037: Call to /: failed on local exception: java.io.IOException: Conn

Re: Binary fields and compression

2018-05-13 Thread Nicolas Paris
B.TEXT VARCHAR, B.LABEL VARCHAR, B.DATE_CREATE TIMESTAMP) > B.COMPRESSION='GZ' > > On Sun, May 13, 2018 at 3:50 AM Nicolas Paris wrote: > >> Hi, >> >> My use case is storing pdf files from one side, and it's content as text >> from the other. Two

Binary fields and compression

2018-05-13 Thread Nicolas Paris
Hi, My use case is storing pdf files from one side, and it's content as text from the other. Two kind of queries would either get the text, or the pdf from the primary key. Rarely both. Then I guess the option is to create two columns family, one containing a VARBINARY column to store the binary