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 metric
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.
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 data
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 to
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 9:15
Bro, Please explain your question as much as possible.
This is not a single line Q&A 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 getti
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 am
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.
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 upd
/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.
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
t changed from A->B->C without storing it
> twice.
>
> On Tue, May 16, 2017 at 6:36 PM @Nandan@
> wrote:
>
>> 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
>> th
Advance.
Best Regards,
Nandan Priyadarshi
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
configuring
Multi DC successfully.
I am using Ubuntu 16.04 Operating System.
Thanks and Best Regards,
Nandan Priyadarshi
As we 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 addit
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
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]
> *S
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 vid
it like this ?
On Mon, Jun 12, 2017 at 3:19 PM, Oskar Kjellin
wrote:
> Why not elasticsearch for this use case? It will make your life much
> simpler
>
> > On 12 Jun 2017, at 04:40, @Nandan@
> wrote:
> >
> > Hi,
> >
> > Currently, I am working on d
search , I am
getting confused.
On Mon, Jun 12, 2017 at 3:47 PM, Oskar Kjellin
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, at 09:45, @Nandan@ wrote:
>
t;
> 2017-06-12 10:58 GMT+02:00 Eduardo Alonso :
>
>> Hi Nandan:
>>
>> So, your system must provide these queries:
>>
>> 1 - SELECT video FROM ... WHERE actor = '...';
>> 2 - SELECT video FROM ... WHERE producer = '...';
>> 3
, 2017 at 5:11 PM, @Nandan@
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,
> producer text,
> release_date
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@ :
>
>> Hi Eduardo,
>>
>> And As we are trying to build an advanced search functionality in which
>>
cs.datastax.com/en/cql/3.1/cql/cql_using/use_collections_c.html>
> .
> 5/10 actors per movie is ok.
>
>
> Eduardo Alonso
> Ví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
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@
wrote:
> Yes this is only Option I am also thinking like this as my second options.
> Before this
, 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@ :
>
>> And due to single table vide
> mm...@apache.org
>
>
> 2017-06-11 22:40 GMT-04:00 @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 co
09/advanced-search-for-your-legacy-application/>
>>>>.
>>>>
>>>>
>>>>
>>>>
>>>> On Mon, Jun 12, 2017 at 5:08 PM, Michael Mior
>>>> wrote:
>>>>
>>>>> For queries 1-5 this seems like a pot
ing bugs, I'd recommend
> avoiding 3.0's materialized views and manage them yourself.
>
> On Mon, Jun 12, 2017 at 6:11 PM @Nandan@
> wrote:
>
>> Correct, Our first concern is to store huge READ and WRITE, for that
>> Cassandra is our First and Best Choice. But a
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) gives
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 users_by_username (
> username
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 numb
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 hand
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, 赵豫峰
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
working perfectly.
Just hope to get some step by step guidelines from all of you.
Thanks in advance and best regards,
Nandan Priyadarshi
nodes.
Thanks for reply. Hope we will work on this .
Thanks,
Nandan Priyadarshi
On Nov 6, 2017 10:29 PM, "Varun Barala" wrote:
> you can try *CCM*
> https://academy.datastax.com/planet-cassandra/getting-
> started-with-ccm-cassandra-cluster-manager
>
> Thanks
>
>
rbed due to changing seeds.
Please clarify these doubts.
Thanks and Best Regards,
Nandan Priyadarshi
On Nov 6, 2017 10:44 PM, "Jeff Jirsa" wrote:
> Looks like official docs for first-time-setup are pretty lacking.
>
> One node at a time:
> - Install the deb package: http:
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 wrote
; 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 owner
time 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
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:* lundi
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:
>
I need to check for this. ?
Thanks in Advance,
Nandan Priyadarshi
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
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@
> wrote:
>
>> Hi Jai,
>> I checked nodetool descr
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@
> wrote:
>
>
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 wrote:
>
>
> W
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 having
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
I.
> 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@
> wrote:
> >
> > Hi Peoples,
> >
> > As currently around the world 60-70% websites are exce
b.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@
> wrote:
>
> Hi Jon,
> Do you mean Elastic search for storing data or Data should be store in
by which I can able to do it and solve it
all queries in coming time.
Thanks.
Nandan Priyadarshi
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
T
.
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
comman
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, "Nicolas Guyomar"
>> wrote:
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 :
>>
>> 1.8.0_161
>>
>>
>>
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 inser
ectly and queried it many times
> through cqlsh> as well as through node.js.
>
> I started going through the logs and haven't noticed anything yet... Very
> unexpected behavior.
>
> Thanks.
> A
>
>
> Sent from Yahoo Mail for iPad <https://yho.com/footer0>
unsubscribe
62 matches
Mail list logo
