Re: [External] Re: Cassandra ad hoc search options

2017-01-31 Thread Justin Cameron
+1 On Tue, 31 Jan 2017 at 10:04 Jonathan Haddad <j...@jonhaddad.com> wrote: > With regards to having DCs for specific workloads, it would be nice to > have per DC indexes. See > https://issues.apache.org/jira/browse/CASSANDRA-12663. > > On Tue, Jan 31, 2017 at 9:52 A

Re: [External] Re: Cassandra ad hoc search options

2017-01-31 Thread Justin Cameron
; Thanks! > > John > -- > > NOTICE OF CONFIDENTIALITY: > This message may contain information that is considered confidential and > which may be prohibited from disclosure under applicable law or by > contractual agreement. The information is intended

Re: Extract big data to file

2017-02-08 Thread Justin Cameron
y! > I've take a look to the result file and is empty, perhaps is cooking the > result in memory to in the end past to disk. > > Is there another approach like this on ACID databases: > copy (select kafka from red where datetimestamp >= '2017-02-02 00:00:00' > and datetimes

Re: Extract big data to file

2017-02-08 Thread Justin Cameron
s on ACID databases: > copy (select kafka from red where datetimestamp >= '2017-02-02 00:00:00' > and datetimestamp < '2017-02-02 15:00:01') to 'result.csv' WITH CSV HEADER; > > Thanks in advance. > > > -- > > Justin Cameron > > Senior Software Engineer | Ins

Re: How does cassandra achieve Linearizability?

2017-02-09 Thread Justin Cameron
rdering across > multiple clients. > > Thanks! > > > On Thu, Feb 9, 2017 at 4:16 PM, Justin Cameron <jus...@instaclustr.com> > wrote: > > Hi Kant, > > Clock synchronization is important - you should ensure that ntpd is > properly configured on all nodes. If y

Re: How does cassandra achieve Linearizability?

2017-02-09 Thread Justin Cameron
teed to be consistent with actual > event ordering due to clock skew. isn't it? > > Thanks! > -- Justin Cameron Senior Software Engineer | Instaclustr This email has been sent on behalf of Instaclustr Pty Ltd (Australia) and Instaclustr Inc (USA). This email and any att

Re: how to get the size of the particular partition key belonging to an sstable ??

2016-10-28 Thread Justin Cameron
n > sstable ?? can we find it using index or summary or Statistics.db files ?? > does reading the hexdump of these files help ?? > > > > Thanks > Pranay. > > > > > > -- > > Oleg Krayushkin > -- Justin Cameron Senior Software Engineer | Instaclustr

Re: how to get the size of the particular partition key belonging to an sstable ??

2016-10-28 Thread Justin Cameron
nodetool cfhistograms / nodetool tablehistograms will also output partition size statistics for a given table: http://docs.datastax.com/en/cassandra/3.0/cassandra/tools/toolsTablehisto.html On Fri, 28 Oct 2016 at 12:32 Justin Cameron <jus...@instaclustr.com> wrote: > If you'

Re: store individual inventory items in a table, how to assign them correctly

2016-11-07 Thread Justin Cameron
thout having any race conditions etc? > > Thanks. > -- Justin Cameron Senior Software Engineer | Instaclustr This email has been sent on behalf of Instaclustr Pty Ltd (Australia) and Instaclustr Inc (USA). This email and any attachments may contain confidential and legally p

Re: Does anyone store larger values in Cassandra E.g. 500 KB?

2016-10-20 Thread Justin Cameron
the issues you are facing . I Would like to know the tweaks also > which you are considering. > > Thanks, > Vikas > -- Justin Cameron Senior Software Engineer | Instaclustr This email has been sent on behalf of Instaclustr Pty Ltd (Australia) and Instaclustr Inc (USA). Th

Re: Improving cassandra documentation

2016-11-03 Thread Justin Cameron
assandra docs. Is there a > right & easy way to report them? > > Thanks. > > -- > > Oleg Krayushkin > > > > > -- > *Scott Hirleman* > *Head of US Marketing and Sales* > www.smartcat.io > https://github.com/smartcat-labs <http://www.smartcat.io/

Re: Java Driver - Specifying parameters for an IN() query?

2016-10-11 Thread Justin Cameron
<ali.rac...@gmail.com> wrote: Do you send the values themselves, or send them as an array / collection? Or will both work? On Tue, Oct 11, 2016 at 7:10 PM, Justin Cameron <jus...@instaclustr.com> wrote: You can pass multiple values to the IN clause, however they can only be used on the

Re: Java Driver - Specifying parameters for an IN() query?

2016-10-11 Thread Justin Cameron
#in-java.lang.String-java.util.List- On Tue, 11 Oct 2016 at 07:24 Ali Akhtar <ali.rac...@gmail.com> wrote: Justin, I'm asking how to bind a parameter for IN queries thru the java driver. On Tue, Oct 11, 2016 at 7:22 PM, Justin Cameron <jus...@instaclustr.com> wrote: You need to specif

Re: Java Driver - Specifying parameters for an IN() query?

2016-10-11 Thread Justin Cameron
pass in an array as the 2nd > variable? > -- Justin Cameron Senior Software Engineer | Instaclustr This email has been sent on behalf of Instaclustr Pty Ltd (Australia) and Instaclustr Inc (USA). This email and any attachments may contain confidential and legally privileged informat

Re: Cannot achieve consistency level LOCAL_ONE

2017-07-09 Thread Justin Cameron
other superuser, so in the end you still have superuser access to your > cluster. > > Cheers, > -- > Alex > > -- *Justin Cameron*Senior Software Engineer <https://www.instaclustr.com/> This email has been sent on behalf of Instaclustr Pty. Limited (Australia) and Inst

Re: reduced num_token = improved performance ??

2017-07-11 Thread Justin Cameron
much appreciate your insights. > > > > Thank you > > Asad > -- *Justin Cameron*Senior Software Engineer <https://www.instaclustr.com/> This email has been sent on behalf of Instaclustr Pty. Limited (Australia) and Instaclustr Inc (USA). This email and any attachments may c

Re: Sync Spark Data with Cassandra Using Incremental Data Loading

2017-07-19 Thread Justin Cameron
are available > in C* to do incremental backup/restore/load? > > > > Thanks > -- *Justin Cameron*Senior Software Engineer <https://www.instaclustr.com/> This email has been sent on behalf of Instaclustr Pty. Limited (Australia) and Instaclustr Inc (USA). This email and a

Re: UDF for sorting

2017-07-03 Thread Justin Cameron
and >> *select * from ks.cf <http://ks.cf> where pk1=123 and status=1;* >> In this case , I want rows to be sorted based on 'disp_name' (asc/desc) . >> >> Can I achieve the same using UDF or anything else ?? (Sorry If my >> understanding about UDF is wrong). >

Re: UDF for sorting

2017-07-04 Thread Justin Cameron
com> wrote: > Hi Justin, > > Thanks for the reply. > We are using c*-2.1.17 , does lucene plugin works with this version?? > > On Tue, Jul 4, 2017 at 4:49 AM, Justin Cameron <jus...@instaclustr.com> > wrote: > >> While you can't do this with Cassandra,

Re: How can I efficiently export the content of my table to KAFKA

2017-04-26 Thread Justin Cameron
possible to create a job-list in a KAFKA > topic, and have each Producer pick jobs from there, and read up data from > Cassandra based on the partition key (token) and then post the JSON on the > export KAFKA topic. > > https://dzone.com/articles/data-locality-w-cassandra-how >

Re: How can I efficiently export the content of my table to KAFKA

2017-04-26 Thread Justin Cameron
e enough > > Although I admit that this could still be a way forward we have not > evaluated it 100% yet, so I have not completely given up that thought > > > > -Tobias > > > > > > *From: *Justin Cameron <jus...@instaclustr.com> > *Reply-To: *"

Re: Migrating a cluster

2017-05-01 Thread Justin Cameron
REMOTE to 0 - seems like that would be > an important thing to do? > > Thank you. > -- *Justin Cameron*Senior Software Engineer <https://www.instaclustr.com/> This email has been sent on behalf of Instaclustr Pty. Limited (Australia) and Instaclustr Inc (USA). This email and any att

Re: Reg:- Multi DC Configuration

2017-06-08 Thread Justin Cameron
.0.2, 192.16.0.3 > DC2 Name :- USA > Nodes :- 172.16.0.1 , 172.16.0.2 > > Please help me to know which files I need to make changes for configuring > Multi DC successfully. > > I am using Ubuntu 16.04 Operating System. > > Thanks and Best Regards, > Nandan Priyadarshi

Re: Huge Batches

2017-06-08 Thread Justin Cameron
Iterator cns = cf.getColumnNames().iterator();* > *CellName cn = cns.next();* > *cn.dataSize();* > *}* > > *String format = "Batch of prepared statements for {} is of > size {}, exceeding specified threshold of {} by {}.";* > * logge

Re: Definition of QUORUM consistency level

2017-06-08 Thread Justin Cameron
t;> We have CL.TWO. >>>> >>>> >>>> >>> This was actually the original motivation for CL.TWO and CL.THREE if >>> memory serves: >>> https://issues.apache.org/jira/browse/CASSANDRA-2013 >>> >> >> >> >> -

Re: Definition of QUORUM consistency level

2017-06-08 Thread Justin Cameron
> read and write requests, so that we can reduce one replica request in read > path. > > Any concerns? > > Thanks! > > > -- > Dikang > > -- *Justin Cameron*Senior Software Engineer <https://www.instaclustr.com/> This email has been sent on behalf of Insta

Re: Cassandra is always CP or AP in terms of CAP theorem

2017-06-19 Thread Justin Cameron
rong? > > Thanks in Advance. > > Regards, > > Kaushal > -- *Justin Cameron*Senior Software Engineer <https://www.instaclustr.com/> This email has been sent on behalf of Instaclustr Pty. Limited (Australia) and Instaclustr Inc (USA). This email and any attachments may c

Re: token distribution in multi-dc

2017-05-02 Thread Justin Cameron
sent >> cluster right ?. >> Please prove >> >> >> On Mon, May 1, 2017 at 7:54 PM, Justin Cameron <jus...@instaclustr.com> >> wrote: >> >>> Hi Vasu, >>> >>> Each DC has a complete token range. >>> >>> Cheers, >>>

Re: token distribution in multi-dc

2017-05-02 Thread Justin Cameron
that there are no > collisions. Unless you are hardcoding your vnode tokens in the yaml > manually, in which case I'd be curious to understand why. > > > All the best, > > > Sebastián > > > > > On Tue, May 2, 2017 at 8:45 PM, Justin Cameron <jus...@ins

Re: token distribution in multi-dc

2017-05-01 Thread Justin Cameron
d. > How token ranges will be distributed in cluster ? > > Is complete cluster has completed one token range ? > Or each DC has complete token range? > > > -- *Justin Cameron*Senior Software Engineer <https://www.instaclustr.com/> This email has been sent

Re: Elastic IP for Cassandra in AWS

2017-10-17 Thread Justin Cameron
ou remove the > scale in/our component it gets a lot easier, but then you likely don’t > really need an ASG at all. > > > > -- > Jeff Jirsa > > > On Oct 16, 2017, at 10:06 PM, Justin Cameron <jus...@instaclustr.com> > wrote: > > I wouldn't recommend puttin

Re: Elastic IP for Cassandra in AWS

2017-10-16 Thread Justin Cameron
use to populate the yaml/env files >> with the correct IP addresses.​ >> > > -- *Justin Cameron*Senior Software Engineer <https://www.instaclustr.com/> This email has been sent on behalf of Instaclustr Pty. Limited (Australia) and Instaclustr Inc (USA). This email a

Re: Alter table gc_grace_seconds

2017-10-02 Thread Justin Cameron
_retry = '99PERCENTILE'; > > cassandra@cqlsh:mat> select gc_grace_seconds from system_schema.tables > where keyspace_name = 'mat' and table_name = 'number_item'; > > gc_grace_seconds > -- > 3600 > > (1 rows) > > Bye, > Gábor Auth

Re: space left for compaction

2017-10-01 Thread Justin Cameron
nz, Austria, Freist > <https://maps.google.com/?q=4040+Linz,+Austria,+Freist%C3%A4dterstra%C3%9Fe+313=gmail=g> > ädterstra > <https://maps.google.com/?q=4040+Linz,+Austria,+Freist%C3%A4dterstra%C3%9Fe+313=gmail=g> > ße 313 > <https://maps.google.com/?q=4040+Linz,+Austr

Re: How quickly we can bootstrap

2017-11-19 Thread Justin Cameron
staclustr> >> <https://twitter.com/instaclustr> >> <https://www.linkedin.com/company/instaclustr> >> >> Read our latest technical blog posts here >> <https://www.instaclustr.com/blog/>. >> >> This email has been sent on behalf of Instacl

Re: Time series modeling in C* for range queries

2017-11-19 Thread Justin Cameron
alue text, > PRIMARY KEY ((day), datetime) > ) WITH CLUSTERING ORDER BY (datetime ASC) > > [image: Mixmax] > <https://mixmax.com/r/592fe3b429b79365389d2354> Not using Mixmax yet? > <https://mixmax.com/r/592fe3b429b79365389d2354> > > > but this

Re: Golang + Cassandra + Text Search

2017-10-24 Thread Justin Cameron
rks with Go has > specific recommendations for as simple framework to add text search on top > of cassandra? > > (Apologies if this is off topic—I am not quite sure what forum in the > cassandra community would be best for this type of question) > > Thanks, >

Re: Schema version mismatch

2018-06-07 Thread Justin Cameron
for what are all the changes > schema version is changed? > > why do we see schema version mismatch other than upgrades time? > Can we solve the schema version mismatch without restart the > Cassandra nodes > > > > > -- > Thanks & Regards, > Nanda Kishore > --

Re: Is there a plan for Feature like this in C* ?

2018-07-02 Thread Justin Cameron
yes, take a look at http://cassandra.apache.org/doc/latest/operating/cdc.html On Tue, 3 Jul 2018 at 01:20 Kant Kodali wrote: > https://www.cockroachlabs.com/docs/v2.1/change-data-capture.html > -- *Justin Cameron*Senior Software Engineer <https://www.instaclustr.com/> This em

Re: Is there a plan for Feature like this in C* ?

2018-07-02 Thread Justin Cameron
l 2, 2018, at 6:50 PM, Kant Kodali wrote: > > Hi Justin, > > Thanks, Looks like a very early stage feature and no integration with > Kafka yet I suppose. > > Thanks! > > On Mon, Jul 2, 2018 at 6:24 PM, Justin Cameron > wrote: > >> yes, take a look at >> h

Re: Is there a plan for Feature like this in C* ?

2018-07-02 Thread Justin Cameron
Sorry - you'd need a source connector, not the sink. On Tue, 3 Jul 2018 at 04:24 Justin Cameron wrote: > Yeah, if you're using Kafka Connect you could use the Cassandra sink > connector > > On Tue, 3 Jul 2018 at 02:37 Jeff Jirsa wrote: > >> Its a stable API - the project

Re: server connection in authenticator

2017-10-26 Thread Justin Cameron
; > > > We are building up an authenticator using certificates. So far we > > came up with a solution, but implies changing some files in Cassandra > > code base in order to have the connection in the new Authenticator. > > > > So, here are my questions: > &g

Re: Integrating Cassandra With Hadoop

2017-10-22 Thread Justin Cameron
nsubscr...@cassandra.apache.org > For additional commands, e-mail: user-h...@cassandra.apache.org > > -- *Justin Cameron*Senior Software Engineer <https://www.instaclustr.com/> This email has been sent on behalf of Instaclustr Pty. Limited (Australia) and Instaclustr Inc (USA). This ema

Re: cassandra non-super user login fails but super user works

2017-10-22 Thread Justin Cameron
additional commands, e-mail: user-h...@cassandra.apache.org > > -- *Justin Cameron*Senior Software Engineer <https://www.instaclustr.com/> This email has been sent on behalf of Instaclustr Pty. Limited (Australia) and Instaclustr Inc (USA). This email and any attachments may contain confiden

Re: unable to start cassandra 3.11.1

2018-02-01 Thread Justin Cameron
1.1] > at > org.apache.cassandra.service.CassandraDaemon.setup(CassandraDaemon.java:188) > [apache-cassandra-3.11.1.jar:3.11.1] > at > org.apache.cassandra.service.CassandraDaemon.activate(CassandraDaemon.java:600) > [apache-cassandra-3.11.1.jar:3.11.1] > at > org.apache.cassand

Re: Data Deleted After a few days of being off

2018-02-26 Thread Justin Cameron
y > upcoming project. I created a test keyspace and table on my dev laptop. > Loaded it with some data on a Friday and closed her down. Returned on > Monday and looked up the data and it was gone. The keyspace and table was > there, but table was empty. This has happened twice so far.

Re: How to connect a Cassandra database to Microsoft Power BI ?

2018-07-18 Thread Justin Cameron
prohibited. > Unauthorized export or re-export is prohibited. If you have received this > e-mail in error, please advise the sender immediately and delete this > e-mail and all attached documents from your computer system." > # > -- *Justin Cameron*Senior Software E

Re: DCAwareRoundRobinPolicy question

2018-03-06 Thread Justin Cameron
age or any attachment or disclose the contents to anyone else. If this > e-mail was sent to you by mistake please notify the sender immediately and > delete this e-mail. > > > --------- > To unsubscribe, e-mail: user-unsubscr...@

Re: Disable Truststore CA check for internode_encryption

2019-02-28 Thread Justin Cameron
bscr...@cassandra.apache.org >> >> For additional commands, e-mail: user-h...@cassandra.apache.org >> >> >> >> - >> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org >> F