Re: Materialized views in Hbase/Phoenix

2019-10-12 Thread sudhir patil
of the ‘views’ are written and some aren’t. > > > > > > > > > > > > From: Pedro Boado [mailto:pedro.bo...@gmail.com] > > Sent: Friday, September 27, 2019 7:22 AM > > To: user@phoenix.apache.org > > Subject: Re: Materialized views in Hbas

Re: Materialized views in Hbase/Phoenix

2019-10-11 Thread Nicolas Paris
Pedro Boado [mailto:pedro.bo...@gmail.com] > Sent: Friday, September 27, 2019 7:22 AM > To: user@phoenix.apache.org > Subject: Re: Materialized views in Hbase/Phoenix > > > > CAUTION: This email originated from outside the Allen Institute. Please do not > click links

Re: Materialized views in Hbase/Phoenix

2019-09-30 Thread Josh Elser
ich 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. *From:*Pedro Boado [mailto:pedro.bo...@gmail.com] *Sent:* Friday, September 27, 2019 7:22 AM *To:* user@phoenix.apache.org *Subject:* Re: Materialized views in Hba

Re: Materialized views in Hbase/Phoenix

2019-09-27 Thread Pedro Boado
ta consistency between the tables created for each matrix. > > > > *From:* Pedro Boado [mailto:pedro.bo...@gmail.com] > *Sent:* Friday, September 27, 2019 10:53 AM > *To:* user@phoenix.apache.org > *Subject:* Re: Materialized views in Hbase/Phoenix > > > > *CAUTION:* T

RE: Materialized views in Hbase/Phoenix

2019-09-27 Thread Gautham Acharya
created for each matrix. From: Pedro Boado [mailto:pedro.bo...@gmail.com] Sent: Friday, September 27, 2019 10:53 AM To: user@phoenix.apache.org Subject: Re: Materialized views in Hbase/Phoenix CAUTION: This email originated from outside the Allen Institute. Please do not click links or open

Re: Materialized views in Hbase/Phoenix

2019-09-27 Thread Pedro Boado
column when all rows are grouped by a certain row > property). > > > > Precomputing seems much more efficient. > > > > *From:* Pedro Boado [mailto:pedro.bo...@gmail.com] > *Sent:* Friday, September 27, 2019 9:27 AM > *To:* user@phoenix.apache.org > *Subject:*

RE: Materialized views in Hbase/Phoenix

2019-09-27 Thread Gautham Acharya
. From: Pedro Boado [mailto:pedro.bo...@gmail.com] Sent: Friday, September 27, 2019 9:27 AM To: user@phoenix.apache.org Subject: Re: Materialized views in Hbase/Phoenix CAUTION: This email originated from outside the Allen Institute. Please do not click links or open attachments unless you've

Re: Materialized views in Hbase/Phoenix

2019-09-27 Thread Pedro Boado
> *From:* Pedro Boado [mailto:pedro.bo...@gmail.com] > *Sent:* Friday, September 27, 2019 7:22 AM > *To:* user@phoenix.apache.org > *Subject:* Re: Materialized views in Hbase/Phoenix > > > > *CAUTION:* This email originated from outside the Allen Institute. Please > do not

RE: Materialized views in Hbase/Phoenix

2019-09-27 Thread Gautham Acharya
state where some of the ‘views’ are written and some aren’t. From: Pedro Boado [mailto:pedro.bo...@gmail.com] Sent: Friday, September 27, 2019 7:22 AM To: user@phoenix.apache.org Subject: Re: Materialized views in Hbase/Phoenix CAUTION: This email originated from outside the Allen Institute

Re: Materialized views in Hbase/Phoenix

2019-09-27 Thread Pedro Boado
e? > > > > --gautham > > > > > > *From:* anil gupta [mailto:anilgupt...@gmail.com] > *Sent:* Friday, September 27, 2019 6:58 AM > *To:* user@phoenix.apache.org > *Subject:* Re: Materialized views in Hbase/Phoenix > > > > *CAUTION:* This email ori

RE: Materialized views in Hbase/Phoenix

2019-09-27 Thread Gautham Acharya
[mailto:anilgupt...@gmail.com] Sent: Friday, September 27, 2019 6:58 AM To: user@phoenix.apache.org Subject: Re: Materialized views in Hbase/Phoenix CAUTION: This email originated from outside the Allen Institute. Please do not click links or open attachments unless you've validated the sender and know

Re: Materialized views in Hbase/Phoenix

2019-09-27 Thread anil gupta
For your use case, i would suggest to create another table that stores the matrix. Since this data doesnt change that often, maybe you can write a nightly spark/MR job to update/rebuild the matrix table.(If you want near real time that is also possible with any streaming system) Have you looked