Re: how to grant permissions to OpsCenter keyspace?

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: Error Connecting to Cassandra

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: Getting code=2200 [Invalid query] message=Invalid column name ... while executing ALTER statement

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: AttributeError python exception when using Models

. 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: How to make the result of select dateof(now) from system.local be equal to date command ?

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: nulls in prepared statement & tombstones?

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:

Composite Column Query Modeling

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

Re: Composite Column Query Modeling

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

Re: cqlsh 2.1 to cassandra 2.0.7

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: cqlsh 2.1 to cassandra 2.0.7

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: cassandra 2.1.0 unable to use cqlsh

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: Empty cqlsh cells vs. null

'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: [Consitency on cqlsh command prompt]

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: getting column names

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: FW: How to use cqlsh to access Cassandra DB if the client_encryption_options is enabled

: 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: Unable to create a keyspace

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

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: Finding nodes that own a given token/partition key

/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: select * from table in CQLSH

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

NullPointerException in TCP Selector Manager [Cassandra 0.5.1]

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

Re: NullPointerException in TCP Selector Manager [Cassandra 0.5.1]

> 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

StoragePort Socket Leak 0.6.5

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: Performance drop of current Java drivers

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