Re: UDF and DevCenter

.@datastax.com>. And the good news is that in the next release there will be an integrated feedback form directly in DevCenter. On Thu, Jan 22, 2015 at 8:15 AM, Andrew Cobley (Staff) mailto:a.e.cob...@dundee.ac.uk>> wrote: I’m not sure where to send “faults” for the DataStax Devcenter

UDF and DevCenter

I’m not sure where to send “faults” for the DataStax Devcenter so I’ll send them here. If I define a UDT such as: CREATE TYPE if not exists sensorsync.SensorReading ( fValue float, sValue text, iValue int ); and a table Create table if not exists sensorsync.Sensors( name uuid, insertion_tim

Re: DSE install interfering with apache Cassandra 2.1.0

2014 01:25, Andrew Cobley mailto:a.e.cob...@dundee.ac.uk>> wrote: Without the apache cassandra running I ran jps -l on this machine ,the only result was 338 sun.tool.jps.Jps The Mac didn’t like the netstat command so I ran netstat -atp tcp | grep 9160 no result Also for the native port:

Re: Saving file content to ByteBuffer and to column does not retrieve the same size of data

I too have saved images in blobs (in development environment admittedly) . Sample code can be seen here: https://github.com/acobley/instagrim/blob/master/src/main/java/uk/ac/dundee/computing/aec/instagrim/models/PicModel.java Note this code uses the org.imgscalr.Scalr to resize and process ima

Re: using dynamic cell names in CQL 3

Isn’t the correct way to do this in CQL3 to use sets and user defined types (in C* 2.1) ?: create type sensorreading( date timestamp, name text, value int); CREATE TABLE sensordata ( name text, data set>, PRIMARY KEY (name) ); insert into keyspace2.sensordata (name, data) values ('1234', {{date:

Re: DSE install interfering with apache Cassandra 2.1.0

...@gmail.com>> wrote: Please run jps to check which Java services are still running and to make sure if c* is running. Then please check if 9160 port is in use. netstat -nltp | grep 9160 This will confirm what is happening in your case. Sent from my iPhone On 29-Sep-2014, at 7:15 pm, Andrew

DSE install interfering with apache Cassandra 2.1.0

Hi All, Just come across this one, I’m at a bit of a loss on how to fix it. A user here did the following steps On a MAC Install Datastax Enterprise (DSE) using the dmg file test he can connect using the DSE cqlsh window Unistall DSE (full uninstall which stops the services) download apache cas

DevCenter and Cassandra 2.1

Hi all, I notice that descanter 1.1.1doesn’t support User defined types (as far as I can see). Is it just a matter of importing a template or will we need to wait for full 2.1 support in descanter ? Andy The University of Dundee is a registered Scottish Charity, No: SC015096

Re: Issue retrieving blobs with CQL

Apologies, this seems to be addressed in the thread : https://groups.google.com/a/lists.datastax.com/forum/#!searchin/java-driver-user/blob$20ByteBuffer/java-driver-user/4_KegVX0teo/2OOZ8YOwtBcJ Andy On 19 Mar 2014, at 11:55, Andrew Cobley mailto:a.e.cob...@dundee.ac.uk>> wrote: Cas

Issue retrieving blobs with CQL

Cassandra 2.0.4 I’m using blobs to save and retrieve images in cassanda. However the blob I get back is not the blob I saved ! I’m saving to CQL like this: byte[] b= {(byte)10,(byte)20,(byte)30}; int length=b.length; ByteBuffer buffer =ByteBuffer.wrap(b); Session session = cluster.connect("k

CQLException ?

I’m just converting some code from SQL to CQL. The code can throw a SQLException. however I note that there is no equivalent in CQL, I’m just wondering whys this is the case ? Regards Andy The University of Dundee is a registered Scottish Charity, No: SC015096

RE: CQL get unique row keys ?

: SELECT DISTINCT pk FROM More info on the feature here: https://issues.apache.org/jira/browse/CASSANDRA-4536 This query is quite efficient because the key cache is used most of the time. Regards Duy Hai DOAN On Sat, Feb 15, 2014 at 6:05 PM, Andrew Cobley mailto:a.e.cob...@dundee.ac.uk

CQL get unique row keys ?

I may be missing something here, but is there a way in cql to get all unique row keys in a column family(table) ? I’ve created a table like this: CREATE TABLE totp ( artist varchar, track varchar, appearance_type varchar, PRIMARY KEY ((artist),track) ) WITH CLUSTERING ORDER BY (track asc); an

CQL list command

TL;DR Is there a CQL equivalent of the CLI List command ? yes or No? Long version I often use the CLI command LIST for debugging or when teaching students showing them what’s going on under the hood of CQL. I see that CLI swill be removed in Cassandra 3 and we will lose this ability. It wou

NetworkTopologyStrategy and nodes ?

Reading this explanation of NetworkTopologyStrategy in 1.1: http://www.datastax.com/docs/1.1/cluster_architecture/replication Is there a suitable explanation of how it will work with Vnodes ? I notice this line in the explanation: "In the following graphic, notice the tokens are assigned to a

C* 2.0 reduce_cache_sizes_at ?

I'm following John Berryman's blog "Building the Perfect Cassandra Test Environment" concerning running C* in a very small amount of memory. he recommends theses settings in cassandra.yaml reduce_cache_sizes_at: 0 reduce_cache_capacity_to: 0 (Blog is at http://www.opensourceconnections.com/20

Re: Setting up a multi-node cluster

Have you tried setting rpc_address to the same as listen_address ? Andy On 29 Aug 2013, at 07:47, Dinesh mailto:dinesh.gad...@gmail.com>> wrote: My first node is running and second node is not running in this case I tried telnet from second node to first node. Following is the stdout # telnet

RE: Vnodes, adding a node ?

re-adding it after cleaning /var/lib/cassandra. Andy From: Richard Low [rich...@wentnet.com] Sent: 14 August 2013 20:11 To: user@cassandra.apache.org Subject: Re: Vnodes, adding a node ? On 14 August 2013 20:02, Andrew Cobley mailto:a.e.cob...@dundee.ac.uk&

Vnodes, adding a node ?

I have small test cluster of 2 nodes. I ran a stress test on it and with nodetool status received the following: /usr/local/bin/apache-cassandra-2.0.0-rc1/log $ ../bin/nodetool status Datacenter: datacenter1 === Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Addre

Re: Cassandra HANGS after some writes

Agreed with Alain, There are a number of reasons that he may be running on windows, a development environment comes to mind,or simply to learn about C* BTW Has anyone ever done any performance comparisons of linux vs a headless windows server ? Andy On 13 Aug 2013, at 17:07, Alain RODRIGUEZ

Re: Any good GUI based tool to manage data in Casandra?

Actually, is that true ? Certainly I guess most versions of C* run on Linux, but do most C* db admins use linux on the desktop ? Or ar they connecting form Mac/PC for management purposes ? Andy On 9 Aug 2013, at 21:11, Keith Freeman <8fo...@gmail.com> wrote: Sounds like a

Re: Choosing Java Driver for using Cassandra with Java EE7

I"m referring to the core driver from datastax: https://github.com/datastax/java-driver You should be able to build it with maven. Andy On 3 Aug 2013, at 16:35, Jan Algermissen wrote: > Hi Andrew, > > On 03.08.2013, at 14:30, Andrew Cobley wrote: > >> I've u

Re: Choosing Java Driver for using Cassandra with Java EE7

I've used most of the java drivers under Glashfish without a problem. IMHO it's really down to the functionality you require in your application. The Java Driver form datastax has the lowest learning curve for any java programmer familiar with JDBC and I believe deals with pool management. J

Re: Strange cassandra-stress results with 2.0.0 beta1

So is that in Cassandra somewhere ? Any idea on how I can go about pinpointing the problem to raise a JIRA issue ? Andy On 25 Jul 2013, at 17:50, Radim Kolar wrote: > >> I'm wondering if it's a GC issue ? > yes it is: > > 1039280992 used; max is 1052770304 > > most likely memory leak. > >

Re: Strange cassandra-stress results with 2.0.0 beta1

8,398,2.7,12.7,6647.0,192 ^Cmacaroon:bin administrator$ Andy C On 25 Jul 2013, at 15:28, Sávio Teles mailto:savio.te...@lupa.inf.ufg.br>> wrote: Some bug was fixed in 2.0.0-beta2 by C* developers. Try it! 2013/7/22 Andrew Cobley mailto:a.e.cob...@dundee.ac.uk>> I've been notici

Re: Cassandra and RAIDs

From: http://www.datastax.com/docs/1.2/cluster_architecture/cluster_planning * RAID on data disks: It is generally not necessary to use RAID for the following reasons: * Data is replicated across the cluster based on the replication factor you've chosen. * Starting in version 1.2,

RE: Cassandra 2.0 : Ant build issue

Home. Setting JAVA_HOME to this path unblocked the build. If I may ask, isn't the Java setup supposed to update the environment variable? On Mon, Jul 22, 2013 at 1:25 PM, Andrew Cobley mailto:a.e.cob...@dundee.ac.uk>> wrote: Hmm, I'm not sure then, I built 2.0 beta 1 earlier

RE: Cassandra 2.0 : Ant build issue

21 To: user Subject: Re: Cassandra 2.0 : Ant build issue There you go: soumava$ javac -version javac 1.7.0_25 Thanks, Soumava On Mon, Jul 22, 2013 at 1:19 PM, Andrew Cobley mailto:a.e.cob...@dundee.ac.uk>> wrote: What version do you get with javac -vers

RE: Cassandra 2.0 : Ant build issue

using 1.7.0_21 (not 25 though).. soumava$ java -version java version "1.7.0_21" Java(TM) SE Runtime Environment (build 1.7.0_21-b12) Java HotSpot(TM) 64-Bit Server VM (build 23.21-b01, mixed mode) Thanks, Soumava On Mon, Jul 22, 2013 at 1:06 PM, Andrew Cobley mailto:a.e.cob...@dundee.ac.

Re: Cassandra 2.0 : Ant build issue

Are you using JDK 1.6. If so you'll need to get the 1.7 jdk (Java SE 7u25) from oracle to do the compile. See my message thread earlier today subject "Cassandra 2 vs Java 1.6 for a few more details. Andy On 22 Jul 2013, at 20:16, Soumava Ghosh mailto:soum...@cs.utexas.edu>> wrote: Hi, I'm

Strange cassandra-stress results with 2.0.0 beta1

I've been noticing some strange casandra-stress results with 2.0.0 beta 1. I've set up a single node on a Mac (4 gig ram, 2.8Ghz core 2 duo) and installed 2.0.0 beta1. When I run ./cassandra-stress -d 134.36.36.218 I'm seeing the interval-op-rate drop from a peek of 11562 at the start to 0 -2

RE: Cassandra 2 vs Java 1.6

Cassandra 2 vs Java 1.6 I believe it won't run on 1.6. Java 1.7 is required to compile C* 2.0+ and once it's done, you cannot run it using Java 1.6 (this is what "Unsupported major.minor version" error tells you about; java version 50 is 1.6 and 51 is 1.7). M. W dniu 22.07.2

Cassandra 2 vs Java 1.6

I know it was decided to drop the requirement for Java 1.6 for cassandra some time ago, but my question is should 2.0.0-beta1 run under java 1.6 at all ? I tried and got the following error: ma

Re: V2 Beta 1 bootstrap behaviour ?

Righto ! Will do a JIRA report.. Many thanks Andy On 16 Jul 2013, at 18:50, Robert Coli mailto:rc...@eventbrite.com>> wrote: On Tue, Jul 16, 2013 at 1:16 AM, Andrew Cobley mailto:a.e.cob...@dundee.ac.uk>> wrote: I'm setting up a new test cluster using 2.0.0-beta1

Re: How to do a CAS UPDATE on single column CF?

According to Jonathan Ellis talk at Cassandra 13 it does use Paxos: http://www.youtube.com/watch?v=PcUpPR4nSr4&list=PLqcm6qE9lgKJzVvwHprow9h7KMpb5hcUU http://www.slideshare.net/jbellis/cassandra-summit-2013-keynote Andy On 1 Jul 2013, at 19:40, Francisco Andrades Grassi mailto:bigjoc...@gmail.

Re: How to configure linux service for Cassandra

Does this help you ? https://github.com/acobley/CassandraStartup it was built for Raspbian, but might help you. Andy On 19 Mar 2013, at 11:10, Roshan mailto:codeva...@gmail.com>> wrote: Hi I want to start the cassandra as a service. At the moment it is starting as a background task. Cassand

Cassandra as a service on Windows

Hi all,\ According to http://www.datastax.com/dev/blog/whats-new-in-cassandra-1-0-windows-service-new-cql-clients-and-more running cassandra.bat install should make cassandra run on a service on a windows box. However I'm getting the following when I try: C:\apache-cassandra-1.2.1\bin>cassandr