Re: Performance drop of current Java drivers

2020-05-01 Thread Adam Holmberg
ch this >> mailing list (I'm happy to be corrected 🙂 ) so I'd recommend you >> cross-post in the Java driver channels as well. Cheers! >> > -- Adam Holmberg e. adam.holmb...@datastax.com w. www.datastax.com

Re: nulls in prepared statement & tombstones?

2016-03-09 Thread Adam Holmberg
The referenced article is accurate as far as NULL is concerned, but please also note that there is now the ability to specify UNSET to avoid unnecessary tombstones (as of Cassandra 2.2.0): https://issues.apache.org/jira/browse/CASSANDRA-7304 Adam On Tue, Mar 8, 2016 at 12:15 PM, Henry M wrote:

Re: How to make the result of select dateof(now) from system.local be equal to date command ?

2016-01-07 Thread Adam Holmberg
e UTC - 06:00, while the example is showing UTC + 08:00. You might want to check the date settings on your local machine and the database. Regards, Adam Holmberg On Thu, Jan 7, 2016 at 1:58 AM, 土卜皿 wrote: > Hi, all > > When I run the command date: > > [root@localhost ~]# date >

Re: AttributeError python exception when using Models

2015-12-07 Thread Adam Holmberg
. I've created a ticket to improve the error message in these circumstances: https://datastax-oss.atlassian.net/browse/PYTHON-451 Regards, Adam Holmberg

Re: Getting code=2200 [Invalid query] message=Invalid column name ... while executing ALTER statement

2015-11-23 Thread Adam Holmberg
Michael, Thanks for pointing that out. It is a driver issue affecting CQL export (but not the execution API). I created a ticket to track and resolve: https://datastax-oss.atlassian.net/browse/PYTHON-447 Adam On Sat, Nov 21, 2015 at 8:38 AM, Laing, Michael wrote: > Quickly reviewing this spec

Re: Error Connecting to Cassandra

2015-10-29 Thread Adam Holmberg
It's timing out at the default of two seconds while trying to query and build the schema metadata. You can raise this timeout: http://datastax.github.io/python-driver/api/cassandra/cluster.html#cassandra.cluster.Cluster.control_connection_timeout Adam On Thu, Oct 29, 2015 at 10:06 AM, Eduardo Alf

Re: how to grant permissions to OpsCenter keyspace?

2015-10-26 Thread Adam Holmberg
You need to quote the "OpsCenter" identifier to distinguish capital letters: https://cassandra.apache.org/doc/cql3/CQL.html#identifiers Adam On Mon, Oct 26, 2015 at 4:25 PM, Kai Wang wrote: > Hi, > > My understanding is that if I want to enable internal authentication and > authorization on C*

Re: Finding nodes that own a given token/partition key

2015-03-26 Thread Adam Holmberg
/Metadata.html You may not have to construct this yourself. Adam Holmberg On Thu, Mar 26, 2015 at 3:53 PM, Roman Tkachenko wrote: > Hi Dan, > > Have you tried using "nodetool getendpoints"? It shows you nodes that > currently own the specific key. > > Roman > > On

Re: FW: How to use cqlsh to access Cassandra DB if the client_encryption_options is enabled

2015-02-04 Thread Adam Holmberg
Since I don't know what's in your keystore, or how it was generated, I don't know how much help I can be. You probably need "-alias " on the command line, and make sure a cert by the name "" exists in your keystore. You can use "keytool -list ..." to

Re: Unable to create a keyspace

2015-01-30 Thread Adam Holmberg
the schema change. If this yields further information, please raise the issue on the driver's user mailing list. Adam Holmberg On Wed, Jan 28, 2015 at 8:19 PM, Saurabh Sethi wrote: > I have a 3 node Cassandra 2.1.0 cluster and I am using datastax 2.1.4 > driver to create a keyspace

Re: FW: How to use cqlsh to access Cassandra DB if the client_encryption_options is enabled

2015-01-30 Thread Adam Holmberg
: How cqlsh picks up ssl options <https://github.com/apache/cassandra/blob/cassandra-2.1/pylib/cqlshlib/sslhandling.py> Example cqlshrc file <https://github.com/apache/cassandra/blob/cassandra-2.1/conf/cqlshrc.sample> Adam Holmberg On Wed, Jan 28, 2015 at 1:08 AM, Lu, Boying

Re: getting column names

2014-12-17 Thread Adam Holmberg
Stephen, This topic is more appropriate for the python-driver-user list: https://groups.google.com/a/lists.datastax.com/forum/#!forum/python-driver-user Can we pick this up there, with a little further information including your table definition? Adam On Fri, Dec 12, 2014 at 1:04 PM, Stephen Jo

Re: [Consitency on cqlsh command prompt]

2014-12-17 Thread Adam Holmberg
This is something that could easily be improved in cqlsh. I'll get a ticket open today. Adam On Wed, Dec 17, 2014 at 8:38 AM, nitin padalia wrote: > Thanks! Michael. > On Dec 17, 2014 8:02 PM, "Laing, Michael" > wrote: > >> http://datastax.github.io/python-driver/api/cassandra.html >> >> On We

Re: Empty cqlsh cells vs. null

2014-10-23 Thread Adam Holmberg
'null' is how cqlsh displays empty cells: https://github.com/apache/cassandra/blob/trunk/pylib/cqlshlib/formatting.py#L47-L58 On Thu, Oct 23, 2014 at 9:36 AM, DuyHai Doan wrote: > Hello Jens > > What do you mean by "cqlsh explicitely writes 'null' in those cells" ? > Are you seing textual value

Re: cassandra 2.1.0 unable to use cqlsh

2014-09-22 Thread Adam Holmberg
cqlsh in Cassandra 2.1.0 uses the DataStax python driver. The "cassandra.metadata" module is provided by this package. By default it uses the driver from an archive included in the Cassandra distribution (.../lib/cassandra-driver-internal-only-2.1.0.zip). See /usr/local/apache-cassandra-2.1.0/bin/

Re: cqlsh 2.1 to cassandra 2.0.7

2014-09-18 Thread Adam Holmberg
There is now a ticket open to look into this and produce a more informative error message: https://datastax-oss.atlassian.net/browse/PYTHON-157 Adam On Wed, Sep 17, 2014 at 4:47 PM, Adam Holmberg wrote: > This is not really supported. Presently cqlsh hard-codes CQL and protocol > to ve

Re: cqlsh 2.1 to cassandra 2.0.7

2014-09-17 Thread Adam Holmberg
This is not really supported. Presently cqlsh hard-codes CQL and protocol to versions only supported in 2.1: https://github.com/apache/cassandra/blob/cassandra-2.1.0/bin/cqlsh#L144-L147 Your best bet is probably downloading a 2.0.x tarball and running out of there. Adam Holmberg On Wed, Sep 17

Re: select * from table in CQLSH

2014-08-13 Thread Adam Holmberg
I think you just need to quote the "Users" identifier. Without quotes, identifiers are treated as case-insensitive. https://cassandra.apache.org/doc/cql3/CQL.html#identifiers Adam On Wed, Aug 13, 2014 at 9:27 AM, Tim Dunphy wrote: > Hello, > > I am trying to figure out how to do a select * fr

Re: Composite Column Query Modeling

2012-09-14 Thread Adam Holmberg
--- > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 14/09/2012, at 8:31 AM, Adam Holmberg > wrote: > > I'm modeling a new application and considering the use of SuperColumn vs. > Composite Column paradigms. I understan

Composite Column Query Modeling

2012-09-13 Thread Adam Holmberg
ques would be appreciated. Regards, Adam Holmberg P.S./Sidebar: What this seems like to me is a desire for 'multiget' at the second key level analogous to multiget at the row key level. Is this something that could be implemented in the server using SlicePred

StoragePort Socket Leak 0.6.5

2010-10-15 Thread Adam Holmberg
Greetings. I'm operating a several two-node clusters (version 0.6.5) on VMs in our development and test environments. After about a week of operation under similar conditions, one of them started throwing this: WARN [main] 2010-10-12 08:08:31,245 CustomTThreadPoolServer.java (line 104) Transport

Re: NullPointerException in TCP Selector Manager [Cassandra 0.5.1]

2010-09-23 Thread Adam Holmberg
> On Thu, Sep 23, 2010 at 1:18 PM, Adam Holmberg > wrote: > > Hello, > > > > I've been working with Cassandra for some time and get this error > > intermittently: > > > > ERROR [TCP Selector Manager] 2010-09-23 08:42:18,138 > service.CassandraDa

NullPointerException in TCP Selector Manager [Cassandra 0.5.1]

2010-09-23 Thread Adam Holmberg
Hello, I've been working with Cassandra for some time and get this error intermittently: ERROR [TCP Selector Manager] 2010-09-23 08:42:18,138 service.CassandraDaemon Fatal exception in thread Thread[TCP Selector Manager,5,main] java.lang.NullPointerException at org.apache.cassandra.net.Tc