You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cassandra.apache.org by Shaurya Gupta <sh...@gmail.com> on 2020/12/18 09:32:31 UTC
Regarding Materialized Views
Hi
A couple of questions on materialized views in cassandra -
1. When will MVs be enabled for production use again ?
2. Is there any plan to support secondary indexes on materialized views ?
Thanks
--
Shaurya Gupta
Re: Regarding Materialized Views
Posted by Benjamin Lerer <be...@datastax.com>.
Not for the moment. Before looking into that we need production ready MVs.
On Fri, Dec 18, 2020 at 11:31 AM Shaurya Gupta <sh...@gmail.com>
wrote:
> Thanks for your replies.
>
> Yes the query is partition restricted on the MV partition key. Is there any
> plan to support ?
>
> On Fri, Dec 18, 2020 at 3:30 PM Benjamin Lerer <
> benjamin.lerer@datastax.com>
> wrote:
>
> > Hi Shaurya,
> >
> > 1. When will MVs be enabled for production use again ?
> > >
> >
> > It is difficult to give an exact target but as Zhao pointed out it is in
> > our radar for after 4.0
> >
> >
> >
> > On Fri, Dec 18, 2020 at 10:50 AM Jasonstack Zhao Yang <
> > jasonstack.zhao@gmail.com> wrote:
> >
> > > Hi,
> > >
> > > > 1. When will MVs be enabled for production use again ?
> > >
> > > at least 4.x, it will be assessed after CASSANDRA-15921
> > > <https://issues.apache.org/jira/browse/CASSANDRA-15921>
> > >
> > > > 2. Is there any plan to support secondary indexes on materialized
> > views ?
> > >
> > > unless your index query is partition-restricted on new MV partition
> key,
> > > querying 2i on MV won't be faster than 2i on base table.
> > >
> > >
> > > On Fri, 18 Dec 2020 at 17:33, Shaurya Gupta <sh...@gmail.com>
> > > wrote:
> > >
> > > > Hi
> > > > A couple of questions on materialized views in cassandra -
> > > > 1. When will MVs be enabled for production use again ?
> > > > 2. Is there any plan to support secondary indexes on materialized
> > views ?
> > > >
> > > > Thanks
> > > > --
> > > > Shaurya Gupta
> > > >
> > >
> >
>
>
> --
> Shaurya Gupta
>
Re: Regarding Materialized Views
Posted by Shaurya Gupta <sh...@gmail.com>.
Thanks for your replies.
Yes the query is partition restricted on the MV partition key. Is there any
plan to support ?
On Fri, Dec 18, 2020 at 3:30 PM Benjamin Lerer <be...@datastax.com>
wrote:
> Hi Shaurya,
>
> 1. When will MVs be enabled for production use again ?
> >
>
> It is difficult to give an exact target but as Zhao pointed out it is in
> our radar for after 4.0
>
>
>
> On Fri, Dec 18, 2020 at 10:50 AM Jasonstack Zhao Yang <
> jasonstack.zhao@gmail.com> wrote:
>
> > Hi,
> >
> > > 1. When will MVs be enabled for production use again ?
> >
> > at least 4.x, it will be assessed after CASSANDRA-15921
> > <https://issues.apache.org/jira/browse/CASSANDRA-15921>
> >
> > > 2. Is there any plan to support secondary indexes on materialized
> views ?
> >
> > unless your index query is partition-restricted on new MV partition key,
> > querying 2i on MV won't be faster than 2i on base table.
> >
> >
> > On Fri, 18 Dec 2020 at 17:33, Shaurya Gupta <sh...@gmail.com>
> > wrote:
> >
> > > Hi
> > > A couple of questions on materialized views in cassandra -
> > > 1. When will MVs be enabled for production use again ?
> > > 2. Is there any plan to support secondary indexes on materialized
> views ?
> > >
> > > Thanks
> > > --
> > > Shaurya Gupta
> > >
> >
>
--
Shaurya Gupta
Re: Regarding Materialized Views
Posted by Benjamin Lerer <be...@datastax.com>.
Hi Shaurya,
1. When will MVs be enabled for production use again ?
>
It is difficult to give an exact target but as Zhao pointed out it is in
our radar for after 4.0
On Fri, Dec 18, 2020 at 10:50 AM Jasonstack Zhao Yang <
jasonstack.zhao@gmail.com> wrote:
> Hi,
>
> > 1. When will MVs be enabled for production use again ?
>
> at least 4.x, it will be assessed after CASSANDRA-15921
> <https://issues.apache.org/jira/browse/CASSANDRA-15921>
>
> > 2. Is there any plan to support secondary indexes on materialized views ?
>
> unless your index query is partition-restricted on new MV partition key,
> querying 2i on MV won't be faster than 2i on base table.
>
>
> On Fri, 18 Dec 2020 at 17:33, Shaurya Gupta <sh...@gmail.com>
> wrote:
>
> > Hi
> > A couple of questions on materialized views in cassandra -
> > 1. When will MVs be enabled for production use again ?
> > 2. Is there any plan to support secondary indexes on materialized views ?
> >
> > Thanks
> > --
> > Shaurya Gupta
> >
>
Re: Regarding Materialized Views
Posted by Jasonstack Zhao Yang <ja...@gmail.com>.
Hi,
> 1. When will MVs be enabled for production use again ?
at least 4.x, it will be assessed after CASSANDRA-15921
<https://issues.apache.org/jira/browse/CASSANDRA-15921>
> 2. Is there any plan to support secondary indexes on materialized views ?
unless your index query is partition-restricted on new MV partition key,
querying 2i on MV won't be faster than 2i on base table.
On Fri, 18 Dec 2020 at 17:33, Shaurya Gupta <sh...@gmail.com> wrote:
> Hi
> A couple of questions on materialized views in cassandra -
> 1. When will MVs be enabled for production use again ?
> 2. Is there any plan to support secondary indexes on materialized views ?
>
> Thanks
> --
> Shaurya Gupta
>