unsubscribe

unsubscribe

Re: Improve data load performance

Bro, Please explain your question as much as possible. This is not a single line Q session where we will able to understand your in-depth queries in a single line. For better and suitable reply, Please ask a question and elaborate what steps you took for your question and what issue are you

Re: cqlsh COPY ... TO ... doesn't work if one node down

CQL Copy command will not work in case if you are trying to copy from all NODES because COPY command will check all N nodes UP and RUNNING Status. If you want to complete then you have 2 options:- 1) Remove DOWN NODE from COPY command 2) Make it UP and NORMAL status. On Mon, Jul 2, 2018 at

Re:

Check with Java Using version. On Tue, Jun 19, 2018 at 6:18 PM, Deniz Acay wrote: > Hello there, > > Let me get straight to the point. Yesterday our three node Cassandra > production cluster had a problem and we could not find a solution yet. > Before taking more radical actions, I would like

Re: Restoring snapshot

Before restoring check version od sstables which you are using to import data into your schema. , as you remove and add age, due to this, already there will be no data for that column. now if you want that your old data should be shown here, then you have to use proper sstable for dumping the

Re: Cassandra Node free memory very low even with 32GB RAM

Hi, As per I understood, You increased your RAM and CPU but still, you are not able to check free memory space. Did you allocate Java Process Manually? As this is occurring because Java process allocated memory automatically. for Memory visualization, please use jconsole and check what is showing.

Re: performance on reading only the specific nonPk column

First question:- [Just as Concern] How are you making sure that your PK is giving Uniqueness? For Example:- At the same time, 10 users will write data then how's your schema going to tackle that. Now on your question:- does the read on the specific node happen first bringing all the

Re: Data Deleted After a few days of being off

tps://yho.com/footer0> > > > On Monday, February 26, 2018, 9:23 PM, @Nandan@ < > nandanpriyadarshi...@gmail.com> wrote: > > Hi A, > As I am able to understand your question :- > 1) You inserted some data into your table and that was inserted > successfully. > 2

Re: Data Deleted After a few days of being off

Hi A, As I am able to understand your question :- 1) You inserted some data into your table and that was inserted successfully. 2) Then you stop the cassandra servie. 3) After few days you started your service and you checked your Table and there were no data. Did you cross verified once you

Re: Cassandra is not running

Downgrade your Java version please On Feb 13, 2018 11:46 PM, "Irtiza Ali" wrote: > Thank you > > On 13 Feb 2018 20:45, "Jürgen Albersdorfer" > wrote: > >> 1.8.0_161 is not yet supported - try 1.8.0_151 >> >> Am 13.02.2018 um 16:44 schrieb Irtiza Ali

Re: Cassandra is not running

What error message or WARN you got in system.log file and also check output.log file .. On Feb 13, 2018 11:34 PM, "Irtiza Ali" wrote: > What should I do now? > > On 13 Feb 2018 20:21, "Irtiza Ali" wrote: > >> Thank you i will check it >> >> >> On 13 Feb 2018 20:16,

Re: does copy command will clear all the old data?

Hi Peng, Copy command will append upsert all data [based on size] to your existing Cassandra table. Just for testing, I executed before for 50 data by using COPY command into small cql table and it work very fine. Point to make sure :- Please check your primary key before play with COPY

Use Oracle Virtual Machine to Set Up Multiple Node 2 DC cluster

. Nandan

Reg:- limitation as PROS and CONS of Using Collections in Data modeling

Hi All, I want to know, what will be a limitation in case of using Collections such as SET, LIST, MAP? Like in my condition, which inserting Video details, I have to insert language based such as Language:- English Title:- Video Name Language:- Hindi Title:- Video_name in Hindi Language:- Chinese

Reg:- Data Modelling Concept ** Amazon Video **

details by which I can able to do it and solve it all queries in coming time. Thanks. Nandan Priyadarshi

Re: Reg:- Data modelling For E-Commerce Pattern data modelling for Search

gt; pointed out https://github.com/strapdata/elassandra and https > ://github.com/Stratio/cassandra-lucene-index, but I haven’t used either > one. > > Jon > > > On Dec 7, 2017, at 5:59 PM, @Nandan@ <nandanpriyadarshi...@gmail.com> > wrote: > > Hi Jon, > Do you

Re: Reg:- Data modelling For E-Commerce Pattern data modelling for Search

wn. Even > with SASI. > 2. Maybe, but it’s complicated, and doing it right takes a lot of > experience. I’d use Elastic Search instead. > > > > > On Dec 7, 2017, at 5:39 PM, @Nandan@ <nandanpriyadarshi...@gmail.com> > wrote: > > > > Hi Peoples,

Reg:- Data modelling For E-Commerce Pattern data modelling for Search

modeling which gives complex Search patterned as Amazon or eBay is using? 2) If we will use denormalized data modeling then is it will be effective? Please clarify this. Thanks and Best regards, Nandan Priyadarshi

Re: update a record which does not exists

In Cassandra, We are having Upsert concept. That means, Suppose if you inserting data then it is going to store based on your PK, once you will Update records based on PK, then there will be 2 possibilities as:- 1) Either It updates the Existed data with new Timestamp [as we know that record

Re: Nodetool repair on read only cluster

Hi Roger, As you provide incomplete information which is so tough to analyse . But if you like to refer then please check below JIRA link to check out is it useful or not. ? https://issues.apache.org/jira/browse/CASSANDRA-6616 Thanks. On Thu, Nov 30, 2017 at 9:42 AM, Roger Warner

Re: Reg:- CassandraRoleManager skipped default role setup Issue

ri, Nov 24, 2017 at 9:08 AM, Jai Bheemsen Rao Dhanwada < jaibheem...@gmail.com> wrote: > yes, > > I had it in one of my cluster. try restarting the node once again and see > if it creates the default role. > > On Thu, Nov 23, 2017 at 5:05 PM, @Nandan@ <nandanpriyada

Re: Reg:- CassandraRoleManager skipped default role setup Issue

art the node second time it actually created the default roles. I > haven't dig deeper on the root cause. it happened to me only on one cluster > out of 10+ clusters. > > On Wed, Nov 22, 2017 at 5:13 PM, @Nandan@ <nandanpriyadarshi...@gmail.com> > wrote: > >> Hi Jai, >

Re: Reg:- CassandraRoleManager skipped default role setup Issue

Hi Jai, I checked nodetool describecluster and got same schema version on all 4 nodes. > [nandan@node-1 ~]$ nodetool describecluster Cluster Information: Name: Nandan Snitch: org.apache.cassandra.locator.DynamicEndpointSnitch Partitioner: org.apache.cassandra.dht.Murmur3Partitioner Sch

Reg:- CassandraRoleManager skipped default role setup Issue

I need to check for this. ? Thanks in Advance, Nandan Priyadarshi

Re: Solr Search With Apache Cassandra

Sorry, For my mistakes. I mean that Using Apache Cassandra for storage and Solr for search facility from DSE. Thanks for your Suggestion, will check with DSE mates. Thanks Nandan On Mon, Nov 20, 2017 at 5:36 PM, Jacques-Henri Berthemet < jacques-henri.berthe...@genesys.com> wrote:

Re: Solr Search With Apache Cassandra

search, it’s Datastax Entreprise that > supports such feature, you should contact Datastax support for such > questions. > > > > Regards, > > *--* > > *Jacques-Henri Berthemet* > > > > *From:* @Nandan@ [mailto:nandanpriyadarshi...@gmail.com] > *Sent:* lu

Solr Search With Apache Cassandra

such as 4-5 seconds. even currently READ and WRITE operations are not on the massive scale. So please tell me what's the cause and how to resolve this. Thanks Nandan Priyadarshi

Re: Reg :- Multiple Node Cluster set up in Virtual Box

; 172.16.51.185 > WARN [GossipStage:1] 2017-11-07 17:01:42,722 TokenMetadata.java:215 - > Token -3989195857321645521 changing ownership from /172.16.51.160 to / > 172.16.51.185 > WARN [GossipStage:1] 2017-11-07 17:01:42,723 TokenMetadata.java:215 - > Token -6852043742105779264 changing own

Re: Reg :- Multiple Node Cluster set up in Virtual Box

is there any internal configuration required or I need to select specific Network Adapter into Virtual Boxs by which I will get IP1,IP2,IP3 for node1,node2,node3 respectively. Please give me some ideas. Thanks in advance, Nandan Priyadarshi On Tue, Nov 7, 2017 at 8:28 AM, James Briggs <james.

Re: Reg :- Multiple Node Cluster set up in Virtual Box

o changing seeds. Please clarify these doubts. Thanks and Best Regards, Nandan Priyadarshi On Nov 6, 2017 10:44 PM, "Jeff Jirsa" <jji...@gmail.com> wrote: > Looks like official docs for first-time-setup are pretty lacking. > > One node at a time: > - Install the deb pa

Re: Reg :- Multiple Node Cluster set up in Virtual Box

nodes. Thanks for reply. Hope we will work on this . Thanks, Nandan Priyadarshi On Nov 6, 2017 10:29 PM, "Varun Barala" <varunbaral...@gmail.com> wrote: > you can try *CCM* > https://academy.datastax.com/planet-cassandra/getting- > started-with-ccm-cassandra-cluster-mana

Reg :- Multiple Node Cluster set up in Virtual Box

be working perfectly. Just hope to get some step by step guidelines from all of you. Thanks in advance and best regards, Nandan Priyadarshi

Reg:- Install / Configure Cassandra on 2 DCs with 3 nodes

On all nodes , I want to use UBUNTU 16.04 . Please suggest best way to configure my DCs as well as may be in Future I will extend my DCs more. Best Regards, Nandan Priyadarshi

Re: why the cluster does not work well after addding two new nodes

you have to do node rebalance. There are 2 different way by which you can do rebalance. A) Use OpsCenter -> And select Rebalance Cluster. B) Use onnodetool cleanup that node afterward to clean up data no longer belonging to that node. Best Regards, Nandan On Wed, Aug 30, 2017 at 12:14 PM, 赵豫

Re: Help in c* Data modelling

Hi , The best way will go with per query per table plan.. and distribute the common column into both tables. This will help you to support queries as well as Read and Write will be fast. Only Drawback will be, you have to insert common data into both tables at the same time which can be easily

Reg:- Data Modelling Conceptual [DISCUSS]

Hi All, I am working on the data model. Just want to discuss based on below conditions with valid pros and cons. Requirment:- 1) User Registration Module 1.1) Multi types of Users such as Buyer, Seller. 1.2) Registration pages are different for different types of users which contain different

Re: LIKE

If you are sure , that you want to do LIKE , then you can go with SASI . https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/useSASIIndex.html Hope this will help you . On Wed, Jun 21, 2017 at 2:44 PM, web master wrote: > I have this table > > CREATE TABLE

Re: Secondary Index

Hi , Better you can go with denormalized the data based on status. create table ks1.sta1(status int,id1 bigint,id2 binint,resp text,primary key(status,id1)); This will allow you to do as you want.. select * from ks1.sta1 where status = 0 and id1 = 123; Please make sure, that (status and id1)

Re: Reg:- Cassandra Data modelling for Search

in a lot of time fixing bugs, I'd recommend > avoiding 3.0's materialized views and manage them yourself. > > On Mon, Jun 12, 2017 at 6:11 PM @Nandan@ <nandanpriyadarshi...@gmail.com> > wrote: > >> Correct, Our first concern is to store huge READ and WRITE, for that >&

Re: Reg:- Cassandra Data modelling for Search

-your-legacy-application/7 >>>> >>>> <http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/> >>>>. >>>> >>>> >>>> >>>> >>>> On Mon, Jun 12, 2017 at 5:08

Re: Reg:- Cassandra Data modelling for Search

gt; -- > Michael Mior > mm...@apache.org > > > 2017-06-11 22:40 GMT-04:00 @Nandan@ <nandanpriyadarshi...@gmail.com>: > >> Hi, >> >> Currently, I am working on data modeling for Video Company in which we >> have different types of users as well as diffe

Re: Reg:- Cassandra Data modelling for Search

a de las dos Castillas, 33, Ática 4, 3ª Planta > 28224 Pozuelo de Alarcón, Madrid > Tel: +34 91 828 6473 <+34%20918%2028%2064%2073> // www.stratio.com // > *@stratiobd > <https://twitter.com/StratioBD>* > > 2017-06-12 12:36 GMT+02:00 @Nandan@ <nandanpriyadar

Re: Reg:- Cassandra Data modelling for Search

And due to single table videos, maybe it will go with around 15,20 columns, then we need to also think very carefully about partition sizes also. On Mon, Jun 12, 2017 at 6:33 PM, @Nandan@ <nandanpriyadarshi...@gmail.com> wrote: > Yes this is only Option I am also thinking like this as

Re: Reg:- Cassandra Data modelling for Search

2028%2064%2073> // www.stratio.com // > *@stratiobd > <https://twitter.com/StratioBD>* > > 2017-06-12 11:54 GMT+02:00 @Nandan@ <nandanpriyadarshi...@gmail.com>: > >> So In short we have to go with one single table as videos and put primary >> key as videoid

Re: Reg:- Cassandra Data modelling for Search

Pozuelo de Alarcón, Madrid > Tel: +34 91 828 6473 <+34%20918%2028%2064%2073> // www.stratio.com // > *@stratiobd > <https://twitter.com/StratioBD>* > > 2017-06-12 11:18 GMT+02:00 @Nandan@ <nandanpriyadarshi...@gmail.com>: > >> Hi Eduardo, >> >> And As we

Re: Reg:- Cassandra Data modelling for Search

, 2017 at 5:11 PM, @Nandan@ <nandanpriyadarshi...@gmail.com> wrote: > Hi Edurado, > > As you mentioned queries 1-6 , > In this condition, we have to proceed with a table like as below :- > create table videos ( > videoid uuid primary key, > title text, > actor text, &

Re: Reg:- Cassandra Data modelling for Search

s://twitter.com/StratioBD>* > > 2017-06-12 10:58 GMT+02:00 Eduardo Alonso <eduardoalo...@stratio.com>: > >> Hi Nandan: >> >> So, your system must provide these queries: >> >> 1 - SELECT video FROM ... WHERE actor = '...'; >> 2 - SELECT video FRO

Re: Reg:- Cassandra Data modelling for Search

search , I am getting confused. On Mon, Jun 12, 2017 at 3:47 PM, Oskar Kjellin <oskar.kjel...@gmail.com> wrote: > I haven't run solr with Cassandra myself. I just meant to run > elasticsearch as a completely separate service and write there as well. > > On 12 Jun 2017,

Re: Reg:- Cassandra Data modelling for Search

. Is it like this ? On Mon, Jun 12, 2017 at 3:19 PM, Oskar Kjellin <oskar.kjel...@gmail.com> wrote: > Why not elasticsearch for this use case? It will make your life much > simpler > > > On 12 Jun 2017, at 04:40, @Nandan@ <nandanpriyadarshi...@gmail.com> > wrote: >

Reg:- Cassandra Data modelling for Search

Hi, Currently, I am working on data modeling for Video Company in which we have different types of users as well as different user functionality. But currently, my concern is about Search video module based on different fields. Query patterns are as below:- 1) Select video by actor. 2) select

Re: Reg:- Data Modelling For Hierarchy Data

do.com/everything-need-know-cassandra-materialized-views/ > > > > I don’t have experience on MVs, I’m stuck on 2.2 for now. > > > > Regards, > > *--* > > *Jacques-Henri Berthemet* > > > > *From:* @Nandan@ [mailto:nandanpriyadarshi...@gmail.com] &g

Re: Reg:- Data Modelling For Hierarchy Data

secondary index on user_type by which client will able to access Only Buyer or Seller Records. Please suggest the best way. Best Regards. Nandan On Fri, Jun 9, 2017 at 3:59 PM, Jacques-Henri Berthemet < jacques-henri.berthe...@genesys.com> wrote: > Hi, > > > > According to

Reg:- Data Modelling For Hierarchy Data

have unique email id condition, so should I go with email id as a primary key or user_id UUID will be the best choice. Best regards, Nandan Priyadarshi - To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional

Reg:- Multi DC Configuration

for configuring Multi DC successfully. I am using Ubuntu 16.04 Operating System. Thanks and Best Regards, Nandan Priyadarshi

Reg:- Generate dummy data for Cassandra Tables

int,primary key(userid)); Table4:- user_login create table user_login(email text primary key,password text,userid uuid); Please help me to know how to generate dummy data and insert into all tables which satisfy the distributive nature. Thanks. Nandan

Reg:- Data Modelling Documentation

in Advance. Best Regards, Nandan Priyadarshi

Re: Reg:- Data Modelling Concepts

that it changed from A->B->C without storing it > twice. > > On Tue, May 16, 2017 at 6:36 PM @Nandan@ <nandanpriyadarshi...@gmail.com> > wrote: > >> The requirement is to create DB in which we have to keep data of Updated >> values as well as which use

Reg:- Data Modelling Concepts

recent update to a particular book? What are the updates that have been made to a particular book? What are the details for a particular update? Update frequently will be like Update will happen based on Title, name, Author, price , publisher like. So not very high frequently. Best Regards, Nandan

Reg:- DSE 5.1.0 Issue

/dse/lib /usr/share/dse /usr/share/dse/common . Please make sure there is only one. I searched so many article , but till now not able to find the solution. Please help me to get out of this mess. Thanks and Best Regards, Nandan Priyadarshi.

Reg:- Data Modelling based on Update History details

Hi , I am currently working on Book Management System in which I have a table which contains Books details in which PRIMARY KEY is book_id uuid. The requirement is to create DB in which we have to keep data of Updated values as well as which user update the particular book details and what they

Reg:- CQL SOLR Query Not gives result

Hi , In my table, I am having few records and implemented SOLR for partial search but not able to retrieve data. SELECT * from revall_book_by_title where solr_query = 'language:中'; SELECT * from revall_book_by_title where solr_query = 'language:中*'; None of them are working. Any suggestions.

Reg:- Apache Solr with DSE Query

Hi, Details are as below:- 1) Have table:- video_info 2) PRIMARY KEY:- video_id UUID 3) having records around 5. 4) Table is having around 30-35 columns 5) Using DSE 4.8 Need clarifications and suggestions:- 1) I need to search by few 3-4 columns like Video_title, video_actor etc.. 2) If I