Re: data modeling appointment scheduling

2018-11-04 Thread I PVP
s? On Sun, Nov 4, 2018 at 12:46 PM I PVP mailto:i...@hotmail.com>> wrote: Could you please provide advice on the modeling approach for the following appointment scheduling scenario? I am struggling to model in an way that allows to satisfy the requirement to be able to update an

data modeling appointment scheduling

2018-11-04 Thread I PVP
Could you please provide advice on the modeling approach for the following appointment scheduling scenario? I am struggling to model in an way that allows to satisfy the requirement to be able to update an appointment, specially to be able to change the start datetime and consequently the buc

Re: Working With Prepared Statements

2017-08-29 Thread I PVP
Hi Shalom, If that helps.. From the documentation : "You should prepare only once, and cache the PreparedStatement in your application (it is thread-safe). If you call prepare multiple times with the same query string, the driver will log a warning” On August 29, 2017 at 12:04:34 PM, Shalom S

Cassandra + Stratio’s Cassandra Lucene Index for online quering

2017-07-28 Thread I PVP
Considering that Stratio’s Cassandra Lucene Index, "..is a plugin for Apache Cassandra that extends its index functionality to provide near real time search such as ElasticSearch or Solr..". Can I use Stratio’s Cassandra Lucene Index to build a online reporting functionality within my applicat

Re: /etc/init.d/cassandra for RHEL

2017-03-29 Thread I PVP
This one worked fine https://blog.tomas.cat/sites/default/files/cassandra.initd On March 29, 2017 at 2:17:17 AM, I PVP (i...@hotmail.com<mailto:i...@hotmail.com>) wrote: i tried using the https://github.com/apache/cassandra/blob/trunk/redhat/cassandra won’t start using my own values

Re: /etc/init.d/cassandra for RHEL

2017-03-28 Thread I PVP
wrote: On 03/28/2017 10:53 PM, Michael Shuler wrote: > On 03/28/2017 09:36 PM, I PVP wrote: >> any recommend /etc/init.d/cassandra for RHEL when installing it from >> apache-cassandra-3.10-bin.tar.gz ? >> >> i goggled it but could not find anything that seems to be &qu

/etc/init.d/cassandra for RHEL

2017-03-28 Thread I PVP
any recommend /etc/init.d/cassandra for RHEL when installing it from apache-cassandra-3.10-bin.tar.gz ? i goggled it but could not find anything that seems to be "proven"

Re: Modeling Audit Trail on Cassandra

2016-03-18 Thread I PVP
Jack/Tom Thanks for answering. Here is the table definition so far: CREATE TABLE audit_trail ( auditid timeuuid, actiontype text, objecttype text, executedby uuid ( or timeuuid?), executedat timestamp, objectbefore text, objectafter text, clientipaddr text, serveripaddr text, servername text, cha

Modeling Audit Trail on Cassandra

2016-03-15 Thread I PVP
Hi everyone, I am looking for your feedback or advice on modeling an audit trail log table on Cassandra that stores information from tracking everything an employee changes within the application. The existing application is being migrated from mysql to Cassandra. Is text the most appropriate

RE: Modeling transactional messages

2016-03-04 Thread I PVP
jectID Set TTL on these rows (either default or with the insert) to get the purge to be automatic. Sean Durity From: I PVP [mailto:i...@hotmail.com] Sent: Thursday, March 03, 2016 7:51 PM To: user@cassandra.apache.org Subject: Modeling transactional messages Hi everyone, Can anyone please let

Modeling transactional messages

2016-03-03 Thread I PVP
Hi everyone, Can anyone please let me know if I am heading to an antiparttern or somethingelse bad? How would you model the following ... ? I am migrating from MYSQL to Cassandra, I have a scenario in which need to store the content of "to be sent" transactional email messages that the custom

Modeling approach to widely used textual information

2016-01-14 Thread I PVP
Hi everyone, I am new to Cassandra and moving a existing myqql application to Cassandra. As a generic rule, what is the recommended approach for keeping textual information like a user_nickname, a company_name, product_title, that will potentially be updated at some time and is routinely and re

Re: Modeling contact list, plain table or List

2016-01-12 Thread I PVP
sses from a user, I can do this: cqlsh:test> delete addresses['home'] from user where user_id = 1; Hope that helps, Jon On Mon, Jan 11, 2016 at 1:20 PM I PVP mailto:i...@hotmail.com>> wrote: Well…the way it is now it is not possible to delete a specific contact row f

Re: Modeling contact list, plain table or List

2016-01-11 Thread I PVP
when the base table changes, including deletions, which is why all of the PK columns from the base table needed to be in the MV PK. -- Jack Krupansky On Mon, Jan 11, 2016 at 3:41 PM, I PVP mailto:i...@hotmail.com>> wrote: The below table and materialized view will solve the SELECT requ

Re: Modeling contact list, plain table or List

2016-01-11 Thread I PVP
The below table and materialized view will solve the SELECT requirements of my current application . The challenge now is when the user decides to DELETE one specific contact from his contact list. I could add the objectid to a composite partition key together with the userid. But that would mak