Re: Disable Truststore CA check for internode_encryption

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

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

2018-07-18 Thread Justin Cameron
ents by any means whatsoever is strictly 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." > # >

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 - t

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

2018-07-02 Thread Justin Cameron
On Jul 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 >&

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: Schema version mismatch

2018-06-07 Thread Justin Cameron
ra and 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 Kishor

Re: DCAwareRoundRobinPolicy question

2018-03-06 Thread Justin Cameron
t; message 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...@cassandra.apache

Re: Data Deleted After a few days of being off

2018-02-26 Thread Justin Cameron
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. > > Help... > > Thanks, > Ange

Re: unable to start cassandra 3.11.1

2018-02-01 Thread Justin Cameron
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.cassandra.service.CassandraDae

Re: How quickly we can bootstrap

2017-11-19 Thread Justin Cameron
t;>> -- >> >> >> *Ben Slater* >> >> *Chief Product Officer <https://www.instaclustr.com/>* >> >> <https://www.facebook.com/instaclustr> >> <https://twitter.com/instaclustr> >> <https://www.linkedin.com/company/instaclu

Re: Time series modeling in C* for range queries

2017-11-19 Thread Justin Cameron
Y 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 would be a very lar

Re: server connection in authenticator

2017-10-26 Thread Justin Cameron
lo guys, > > > > 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 questio

Re: Golang + Cassandra + Text Search

2017-10-24 Thread Justin Cameron
ific 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, > Riley > > > -- *Justin Came

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

2017-10-22 Thread Justin Cameron
g > 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 email and any attachments may con

Re: Integrating Cassandra With Hadoop

2017-10-22 Thread Justin Cameron
derstanding of life that fills them with compassion, gentleness and a > deep loving concern. Beautiful people do not just happen." - *Elisabeth > Kubler-Ross* > > - > To unsubscribe, e-mail: user-unsubscr...@cassand

Re: Elastic IP for Cassandra in AWS

2017-10-16 Thread Justin Cameron
> 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 > wrote: > > I wouldn't recommend putting your Cassandra nodes in an ASG. Scali

Re: Elastic IP for Cassandra in AWS

2017-10-16 Thread Justin Cameron
the functionality to allocate and associate elastic IPs >> to instances. Generally the API's aren't pretty but they work. What issues >> are you having? If it's a configuration problem there are a variety of >> config management tools that you can use to popul

Re: Alter table gc_grace_seconds

2017-10-01 Thread Justin Cameron
able_flush_period_in_ms = 0 >AND min_index_interval = 128 >AND read_repair_chance = 0.0 >AND speculative_retry = '99PERCENTILE'; > > cassandra@cqlsh:mat> select gc_grace_seconds from system_schema.tables > where keyspace_name = 'mat' and table_name = &

Re: space left for compaction

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

Re: Sync Spark Data with Cassandra Using Incremental Data Loading

2017-07-19 Thread Justin Cameron
ble > 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 any attachments

Re: reduced num_token = improved performance ??

2017-07-11 Thread Justin Cameron
ucing num_token may improve general performance of Cassandra like > having num_token=16 instead of 256 may help! > > > > Can you please suggests if having less num_token would provide real > performance benefits or if it comes with any downsides that we should also > consider?

Re: Cannot achieve consistency level LOCAL_ONE

2017-07-09 Thread Justin Cameron
e user with that name > to be there, there are no implications. This user is not used by Cassandra > tools or the server process internally, so nothing really depends on it. > > Of course, in order to drop a superuser account, you need to create > another superuser, so in the end you

Re: UDF for sorting

2017-07-04 Thread Justin Cameron
i 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 > wrote: > >> While you can't do this with Cassandra, you can get the functionality you >> wa

Re: UDF for sorting

2017-07-03 Thread Justin Cameron
> 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). >> >> Thanks in advance >

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

2017-06-19 Thread Justin Cameron
e. > > 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 contain confidential and leg

Re: Definition of QUORUM consistency level

2017-06-08 Thread Justin Cameron
ead just needs (n/2) nodes, we are >> purely waste the one extra request, and hurts read latency as well. >> >> Thanks >> Dikang. >> >> On Thu, Jun 8, 2017 at 8:20 PM, Nate McCall >> wrote: >> >>> >>> We have CL.TWO. >>>&

Re: Definition of QUORUM consistency level

2017-06-08 Thread Justin Cameron
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 Ins

Re: Huge Batches

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

Re: Reg:- Multi DC Configuration

2017-06-08 Thread Justin Cameron
:- 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 > -- *Justin Cameron*Senio

Re: token distribution in multi-dc

2017-05-02 Thread Justin Cameron
e allocation algorithm will ensure 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:4

Re: token distribution in multi-dc

2017-05-02 Thread Justin Cameron
ed, 3 May 2017 at 08:07 vasu gunja wrote: > I'm confused now. please someone confirm with proof. > > On Tue, May 2, 2017 at 4:54 PM, vasu gunja wrote: > >> In that case there will be duplication of tokens ranges will present >> cluster right ?. >> Please prove

Re: Migrating a cluster

2017-05-01 Thread Justin Cameron
> Secondly, on the assumption that it is: That link gives the impression > that DC-aware clients will not hit the "remote" DC - is that the case for > the Java driver? We don't currently explicitly set PoolingOptions > ConnectionsPerHost for HostDistance.REMOTE to 0 - seems lik

Re: token distribution in multi-dc

2017-05-01 Thread Justin Cameron
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 on behalf of Instaclustr Pty. Limited (A

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

2017-04-26 Thread Justin Cameron
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 > *Reply-To: *"user@cassandra.apache.org" > *Date: *Thursday, 27 Ap

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

2017-04-26 Thread Justin Cameron
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 > > > > > > Would you con

Re: How does cassandra achieve Linearizability?

2017-02-09 Thread Justin Cameron
total ordering across > multiple clients. > > Thanks! > > > On Thu, Feb 9, 2017 at 4:16 PM, Justin Cameron > wrote: > > Hi Kant, > > Clock synchronization is important - you should ensure that ntpd is > properly configured on all nodes. If your particular use case is

Re: How does cassandra achieve Linearizability?

2017-02-09 Thread Justin Cameron
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 attachments may contain con

Re: Extract big data to file

2017-02-08 Thread Justin Cameron
something heavy in the top of the > Enter key. Crazy thing need to enable paging to get ride of out of memory! > 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

Re: Extract big data to file

2017-02-08 Thread Justin Cameron
of memory! > 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'

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 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 AM Justin Cameron > wrote: >

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

2017-01-31 Thread Justin Cameron
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 solely for the use of > the individual or entity named above. If you are not the intended > recip

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

2016-11-07 Thread Justin Cameron
g 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 privileged informa

Re: Improving cassandra documentation

2016-11-03 Thread Justin Cameron
y 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/> > > <https://github.com/smartcat-labs> &g

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 wrote: > If you're trying to determine this in

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

2016-10-28 Thread Justin Cameron
cluster in minutes.* > > > On Thu, 27 Oct 2016 11:45:47 -0400*Pranay akula > >* wrote > > how can i get the size of a particular partition key belonging to an > sstable ?? can we find it using index or summary or Statistics.db files ?? > does reading the hexdump of t

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

2016-10-20 Thread Justin Cameron
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). This email and any attachmen

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

2016-10-11 Thread Justin Cameron
ml#in-java.lang.String-java.util.List- On Tue, 11 Oct 2016 at 07:24 Ali Akhtar 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 wrote: You need to specify the values themselves. CREATE TABLE user ( id

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

2016-10-11 Thread Justin Cameron
d'); On Tue, 11 Oct 2016 at 07:11 Ali Akhtar 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 wrote: You can pass multiple values to the IN clause, however they can only be used on the last col

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

2016-10-11 Thread Justin Cameron
e.g, let me 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 informa