Re: Help in c* Data modelling

2017-07-23 Thread @Nandan@
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:- CQL SOLR Query Not gives result

2017-05-11 Thread @Nandan@
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:- Data Modelling based on Update History details

2017-05-15 Thread @Nandan@
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:- Apache Solr with DSE Query

2017-05-11 Thread @Nandan@
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

Re: Reg:- Data Modelling Concepts

2017-05-16 Thread @Nandan@
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:- DSE 5.1.0 Issue

2017-05-16 Thread @Nandan@
/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 For Hierarchy Data

2017-06-08 Thread @Nandan@
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

Re: Reg:- Data Modelling For Hierarchy Data

2017-06-09 Thread @Nandan@
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

2017-06-09 Thread @Nandan@
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

Re: Reg:- Cassandra Data modelling for Search

2017-06-12 Thread @Nandan@
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

2017-06-12 Thread @Nandan@
-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

2017-06-12 Thread @Nandan@
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

2017-06-12 Thread @Nandan@
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: Secondary Index

2017-06-20 Thread @Nandan@
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: LIKE

2017-06-21 Thread @Nandan@
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

Reg:- Data Modelling Conceptual [DISCUSS]

2017-06-22 Thread @Nandan@
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

Reg:- Data Modelling Documentation

2017-05-19 Thread @Nandan@
in Advance. Best Regards, Nandan Priyadarshi

Reg:- Data Modelling Concepts

2017-05-16 Thread @Nandan@
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:- Multi DC Configuration

2017-06-06 Thread @Nandan@
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

2017-06-04 Thread @Nandan@
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

Re: Reg:- Cassandra Data modelling for Search

2017-06-12 Thread @Nandan@
. 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: >

Re: Reg:- Cassandra Data modelling for Search

2017-06-12 Thread @Nandan@
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,

Reg:- Cassandra Data modelling for Search

2017-06-11 Thread @Nandan@
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:- Cassandra Data modelling for Search

2017-06-12 Thread @Nandan@
, 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

2017-06-12 Thread @Nandan@
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

2017-06-12 Thread @Nandan@
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-06-12 Thread @Nandan@
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

2017-06-12 Thread @Nandan@
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

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

2017-09-19 Thread @Nandan@
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

2017-08-29 Thread @Nandan@
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: Reg:- CassandraRoleManager skipped default role setup Issue

2017-11-23 Thread @Nandan@
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

2017-11-23 Thread @Nandan@
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, >

Reg:- CassandraRoleManager skipped default role setup Issue

2017-11-21 Thread @Nandan@
I need to check for this. ? Thanks in Advance, Nandan Priyadarshi

Re: Reg:- CassandraRoleManager skipped default role setup Issue

2017-11-22 Thread @Nandan@
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

Re: Nodetool repair on read only cluster

2017-11-29 Thread @Nandan@
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: Solr Search With Apache Cassandra

2017-11-20 Thread @Nandan@
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

2017-11-20 Thread @Nandan@
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

2017-11-19 Thread @Nandan@
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

2017-11-06 Thread @Nandan@
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

2017-11-07 Thread @Nandan@
; 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

2017-11-06 Thread @Nandan@
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

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

2017-11-06 Thread @Nandan@
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

Reg :- Multiple Node Cluster set up in Virtual Box

2017-11-06 Thread @Nandan@
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:- Data modelling For E-Commerce Pattern data modelling for Search

2017-12-07 Thread @Nandan@
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: Reg:- Data modelling For E-Commerce Pattern data modelling for Search

2017-12-07 Thread @Nandan@
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,

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

2017-12-07 Thread @Nandan@
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: update a record which does not exists

2017-12-03 Thread @Nandan@
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

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

2017-12-21 Thread @Nandan@
details by which I can able to do it and solve it all queries in coming time. Thanks. Nandan Priyadarshi

Re: performance on reading only the specific nonPk column

2018-05-21 Thread @Nandan@
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: Restoring snapshot

2018-06-11 Thread @Nandan@
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

2018-06-04 Thread @Nandan@
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: cqlsh COPY ... TO ... doesn't work if one node down

2018-07-01 Thread @Nandan@
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

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

2018-01-11 Thread @Nandan@
. Nandan

Re: Cassandra is not running

2018-02-13 Thread @Nandan@
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

2018-02-13 Thread @Nandan@
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?

2018-02-12 Thread @Nandan@
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

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

2018-01-01 Thread @Nandan@
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

Re: Data Deleted After a few days of being off

2018-02-26 Thread @Nandan@
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:

2018-06-19 Thread @Nandan@
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: Improve data load performance

2018-08-14 Thread @Nandan@
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: Data Deleted After a few days of being off

2018-02-26 Thread @Nandan@
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