Re: New column

2019-08-22 Thread Rahul Reddy
a cluster up, use the >> --host to point to it.If you don't have a cluster up, you can spin one >> up in AWS in about 5-10 minutes using our tools: >> https://thelastpickle.com/tlp-cluster/ >> >> Happy testing! >> Jon >> >> >> On Mon, Aug 19, 2019

Re: New column

2019-08-22 Thread Jon Haddad
t; Jon > > > On Mon, Aug 19, 2019 at 1:23 PM Rahul Reddy > wrote: > >> Jon, >> >> If we expect non of our partition key to have more than 100 records and >> pass partition key in where clause we wouldnt see issues using new column >> and allow filter

Re: New column

2019-08-19 Thread Jon Haddad
than 100 records and > pass partition key in where clause we wouldnt see issues using new column > and allow filtering? Can you please point me to any doc how allow > filtering works. I was in assumption of it goes through all the partitions > > > On Sun, Aug 18, 2019, 4:33 PM Jon Ha

Re: New column

2019-08-19 Thread Rahul Reddy
Jon, If we expect non of our partition key to have more than 100 records and pass partition key in where clause we wouldnt see issues using new column and allow filtering? Can you please point me to any doc how allow filtering works. I was in assumption of it goes through all the partitions

Re: New column

2019-08-18 Thread Jon Haddad
; > We have a table and want to add column and select based on existing entire > primary key plus new column using allow filtering. Since my where clause > has all the primary key + new column does the allow filtering scan only the > partions which are listed or does it has to scan

Re: New column

2019-08-18 Thread Stefan Miklosovic
have a table and want to add column and select based on existing entire > primary key plus new column using allow filtering. Since my where clause has > all the primary key + new column does the allow filtering scan only the > partions which are listed or does it has to scan whole table

New column

2019-08-18 Thread Rahul Reddy
Hello, We have a table and want to add column and select based on existing entire primary key plus new column using allow filtering. Since my where clause has all the primary key + new column does the allow filtering scan only the partions which are listed or does it has to scan whole table? What

Re: Adding New Column with Default Value

2019-03-14 Thread Rahul Singh
to another ... with a modification as long as you save to a different table than from where you got it from. On Thu, Mar 14, 2019 at 12:57 AM kumar bharath wrote: > Hi , > > Can anyone suggest a best possible way, how we can add a new column to > the existing table with defaul

Adding New Column with Default Value

2019-03-13 Thread kumar bharath
Hi , Can anyone suggest a best possible way, how we can add a new column to the existing table with default value ? *Column family Size :* 60 Million single partition records. Thanks, Bharath Kumar B

Re: New Column addition and Locking

2017-09-09 Thread Myrle Krantz
> one of those, upgrade first. >> >> -- >> Jeff Jirsa >> >> >>> On Sep 8, 2017, at 7:13 AM, Deepak Panda <deepak.pa...@gmail.com> wrote: >>> >>> Hi, >>> >>> For Cassandra 3.11, when we add a new column is

Re: New Column addition and Locking

2017-09-08 Thread Jeff Jirsa
;> >> -- >> Jeff Jirsa >> >> >>> On Sep 8, 2017, at 7:13 AM, Deepak Panda <deepak.pa...@gmail.com> wrote: >>> >>> Hi, >>> >>> For Cassandra 3.11, when we add a new column is added to an existing >>> table having hug

Re: New Column addition and Locking

2017-09-08 Thread Deepak Panda
er your table and you're on a 3.something version that isn't > one of those, upgrade first. > > -- > Jeff Jirsa > > >> On Sep 8, 2017, at 7:13 AM, Deepak Panda <deepak.pa...@gmail.com> wrote: >> >> Hi, >> >> For Cassandra 3.11, when we add a n

Re: New Column addition and Locking

2017-09-08 Thread Jeff Jirsa
to alter your table and you're on a 3.something version that isn't one of those, upgrade first. -- Jeff Jirsa > On Sep 8, 2017, at 7:13 AM, Deepak Panda <deepak.pa...@gmail.com> wrote: > > Hi, > > For Cassandra 3.11, when we add a new column is added to an existin

New Column addition and Locking

2017-09-08 Thread Deepak Panda
Hi, For Cassandra 3.11, when we add a new column is added to an existing table having huge number of rows and huge data manipulation going on will there be any issues? Will the operations blocked till the column is added? Is the table locked during column addition? If yes, what type of lock