Lattest driver and netty issues...

2016-05-25 Thread Tony Anecito
Hi All, I downloaded the latest cassandra driver but when used I get an error about class io.netty.util.timer (netty-3.9.0.Final) not being found during runtime. If I get the latest netty-alll-4.0.46.Final.jar during runtime I get an exception about not having a java.security.cert.x509Certificat

Re: Lattest driver and netty issues...

2016-05-25 Thread Tony Anecito
-4.0.33.jar. So what is the right combination to not get this timer class missing exception? Thanks. On Wednesday, May 25, 2016 8:26 PM, Tony Anecito wrote: Hi All, I downloaded the latest cassandra driver but when used I get an error about class io.netty.util.timer (netty-3.9.0.Final) not

Re: Lattest driver and netty issues...

2016-05-26 Thread Tony Anecito
? I am using cassandra driver with the Wildfly J2EE container so I am using the driver in that configuration not a standalone client. That by the way worked fine when I was testing some CQL through the driver. Regards,-Tony On Wednesday, May 25, 2016 8:56 PM, Tony Anecito wrote: Ok

Re: Lattest driver and netty issues...

2016-05-26 Thread Tony Anecito
mailing list:  https://groups.google.com/a/lists.datastax.com/forum/m/#!forum/java-driver-user On Thursday, May 26, 2016, Tony Anecito wrote: Okay,  think I understand the issue. Seems netty/casandra driver expect the javax.security.cert.X509Certificate to be readily available which it is for

Upgrade from 2.1.0 to 2.1.9

2015-08-28 Thread Tony Anecito
Hi All,Been awhile since I upgaded and wanted to know what the steps are to upgrade from 2.1.0 to 2.1.9. Also want to know if I need to upgrade my java database driver. Thanks,-Tony

Cassandra and GPU's...

2015-12-01 Thread Tony Anecito
Hi All, Can Cassandra use GPU's? If not can someone recommend a open source database that runs on GPU's? I am interested in seeing the performance difference of a database that is under 2GB run on a GPU card such as as NVIDA gtx 980. Thanks,-Tony

Re: Upgrade cassandra from 2.1.9 to 3.x?

2016-03-31 Thread Tony Anecito
I would also like to know. Thanks! On Thursday, March 31, 2016 6:14 AM, Steven Choo wrote: Hi, Is it possible to update Cassandra from 2.1.9 to 3.x (e.g. 3.4) in one step? The info about the tick-tock release schedule does not say anything specific about it and the documentation on htt

Re: Meltdown/Spectre Linux patch - Performance impact on Cassandra?

2018-01-09 Thread Tony Anecito
Hi All,Has anyone seen any test results for SQL Server? Although I am a Cassandra user I do use SQL Server for other companies. Thanks,-Tony From: Dor Laor To: user@cassandra.apache.org Sent: Tuesday, January 9, 2018 10:31 AM Subject: Re: Meltdown/Spectre Linux patch - Performance impa

Re: [RELEASE CANDIDATE] Apache Cassandra 2.1.0-rc6 released

2014-08-19 Thread Tony Anecito
That is great news keep up the great work! Best Regards, Tony Anecito Founder/PresidentMyUniPortal LLC http://www.myuniportal.com On Tuesday, August 19, 2014 2:38 AM, Sylvain Lebresne wrote: The Cassandra team is pleased to announce the sixth release candidate for the future Apache

Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Tony Anecito
Hi All, I have a couple of simple questions. When will Cassandra 2.1 be released as GA? Will there be a datastax CQL driver available then? Will Cassandra 2.1 and Datastax CQL driver support nested selects? If not for a combination key table and detailed table (Star Schema) what is the fastest

Re: Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Tony Anecito
20.08.2014 um 22:44 schrieb Tony Anecito : When will Cassandra 2.1 be released as GA? When it's finished :) RC6 has been released yesterday - cross your fingers - this might be 2.1.0 Will there be a datastax CQL driver available then? Both the Java and Python drivers will get a 2.1.0 release

Re: Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Tony Anecito
connections thus lowering OS resource usage. Am 20.08.2014 um 23:09 schrieb Tony Anecito : One last question. I read on someones blog that 2.1 will be up to 50% faster than 2.0.9 and that CQL will be the fastest to use rather than thrift. Any comments/thoughts on that? >

Re: Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Tony Anecito
install do something with an older version I should be aware of? I will look at your link. -Tony On Wednesday, August 20, 2014 4:10 PM, Robert Coli wrote: On Wed, Aug 20, 2014 at 1:44 PM, Tony Anecito wrote: When will Cassandra 2.1 be released as GA? > > > >Will there be a

Re: Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Tony Anecito
after 2.0.x has been out awhile and 2.1 when it was 2.1.2 but sounds like should wait til 2.1.6. So thanks for the help. -Tony On , Tony Anecito wrote: Thanks for the suggestions. I am planning to wait till 2.1 is released and for one or two minor releases that is why I have been on 1.2.5

Re: Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Tony Anecito
. Something like innovation, courage, determination, faith and wanting to be in the front and not behind drive me and good to see it here. Best Regards, Tony Anecito On Wednesday, August 20, 2014 8:19 PM, Benedict Elliott Smith wrote: The "run versions >= x.x.6" is IMO an out

Re: Latest 2.1 and Datastax driver questions...

2014-08-21 Thread Tony Anecito
Thanks Tyler that is good to know. -Tony On Thursday, August 21, 2014 10:20 AM, Tyler Hobbs wrote: On Wed, Aug 20, 2014 at 3:44 PM, Tony Anecito wrote: > >Will there be a datastax CQL driver available then? The Python and C# drivers already have 2.1.0 versions available.  Th

Re: [RELEASE] Apache Cassandra 2.1.0

2014-09-11 Thread Tony Anecito
Congrads team I know you worked hard on it!! One question. Where can users get a java Datastax driver to support this version? If so is it released? Best Regards, -Tony Anecito Founder/President MyUniPortal LLC http://www.myuniportal.com On Thursday, September 11, 2014 9:05 AM, Sylvain

Re: [RELEASE] Apache Cassandra 2.1.0

2014-09-11 Thread Tony Anecito
Ok is it part of the release or needs to be downloaded from Datastax somewhere. I am wondering about the java driver. Thanks! -Tony On Thursday, September 11, 2014 9:47 AM, abhinav chowdary wrote: Yes its was released java driver 2.1 On Sep 11, 2014 8:33 AM, "Tony Anecito&qu

Re: no change observed in read latency after switching from EBS to SSD storage

2014-09-16 Thread Tony Anecito
If you cached your tables or the database you may not see any difference at all. Regards, -Tony On Tuesday, September 16, 2014 6:36 PM, Mohammed Guller wrote: Hi - We are running Cassandra 2.0.5 on AWS on m3.large instances. These instances were using EBS for storage (I know it is no

Re: [RELEASE] Apache Cassandra 2.1.0

2014-09-17 Thread Tony Anecito
a: >>> >>> Latest version: 2.1.1 >>> Maven: http://maven-repository.com/artifact/com.datastax.cassandra >>> Binary distro: http://www.datastax.com/download#dl-datastax-drivers >>> >>> Python: >>> >>> Latest version: 2

Re: no change observed in read latency after switching from EBS to SSD storage

2014-09-18 Thread Tony Anecito
Thanks for the detail. 1. So how do we know from the trace if the read was from memory or I/O? You might want to use a java profiler like VisualVM and a plugin for it to show I/O. But you will have to be a Cassandra developer to understand the output and tune your filters for the tool. 2. Also

Cassaandra & Java 8

2014-10-01 Thread Tony Anecito
Hi All, Has anyone done any performance testing of say Cassandra 2.1 using Java 8? Thanks,-Tony

OPSCENTER has table row maintenence?

2014-04-15 Thread Tony Anecito
Hi All, I asked this over a year ago and it seemed as if OPSCENTER did not have the capability to maintain data like SQL Server Enterprise tool did. I need a visual tool that displays rows and allows me to hand edit column info. Does this tool now do that? Before it was to create schemas and ma

Re: OPSCENTER has table row maintenence?

2014-04-15 Thread Tony Anecito
and execute commands against Cassandra, but it doesn’t have a spreadsheet-like tool for hand editing columns. That sounds like a great suggestion to make.   See: http://www.datastax.com/what-we-offer/products-services/devcenter   -- Jack Krupansky   From: Tony Anecito Sent: Tuesday, April 15

Cassandra driver performance question...

2013-06-21 Thread Tony Anecito
Hi All, I am using jdbc driver and noticed that if I run the same query twice the second time it is much faster. I setup the row cache and column family cache and it not seem to make a difference. I am wondering how to setup cassandra such that the first query is always as fast as the second on

Re: Cassandra driver performance question...

2013-06-21 Thread Tony Anecito
Tony From: Jabbar Azam To: user@cassandra.apache.org; Tony Anecito Sent: Friday, June 21, 2013 3:32 PM Subject: Re: Cassandra driver performance question... Hello Tony, I would guess that the first queries data  is put into the row cache and the filesystem cache. The second query gets the

Re: Cassandra driver performance question...

2013-06-21 Thread Tony Anecito
the second preparedStatement object is because of the Metadata is cached then.   So my question is how to test this theory? Is there a way to stop the metadata from coming accross from Cassandra? A 20x performance improvement would be nice to have.   Thanks, -Tony From: Tony Anecito To: "

Re: Cassandra driver performance question...

2013-06-23 Thread Tony Anecito
.   Regards, -Tony From: Tony Anecito To: "user@cassandra.apache.org" ; Tony Anecito Sent: Friday, June 21, 2013 9:33 PM Subject: Re: Cassandra driver performance question... Hi Jabbar,   I think I know what is going on. I happened accross a change mentioned by the jdbc driver

Re: Cassandra driver performance question...

2013-06-24 Thread Tony Anecito
now I am trying to get inserts to work via JDBC. Running into issues there also but I will work at it till I get them to work.   Regards, -Tony From: Jabbar Azam To: user@cassandra.apache.org Cc: Tony Anecito Sent: Monday, June 24, 2013 3:26 AM Subject: Re: Cassandra driver performance question

Is nexted selects supported by Cassandra JDBC??

2013-06-25 Thread Tony Anecito
Hi All, Is nested select supported by Cassandra JDBC driver? So for a simple example to get a list of user details from a users column family: Select * from user_details where user_id in (Select user_id from users) Thanks! -Tony

Re: Is nexted selects supported by Cassandra JDBC??

2013-06-25 Thread Tony Anecito
ot; ; Tony Anecito Sent: Tuesday, June 25, 2013 9:06 AM Subject: Re: Is nexted selects supported by Cassandra JDBC?? No. CQL3 doesn't support nested selects. -- Sylvain On Tue, Jun 25, 2013 at 5:02 PM, Tony Anecito wrote: Hi All, > > >Is nested select supported by Cassandra

Re: [RELEASE] Apache Cassandra 1.2.6 released

2013-06-26 Thread Tony Anecito
I get http status 404 when I try to download. Where can I find the release notes for this version? Thanks, -Tony From: Sylvain Lebresne To: "user@cassandra.apache.org" Sent: Wednesday, June 26, 2013 8:53 AM Subject: [RELEASE] Apache Cassandra 1.2.6 release

Creating an "Index" column...

2013-06-26 Thread Tony Anecito
Hi All, I have a column family with multiple columns and when I try a where clause with one of the columns that is not the "key" column Cassandra gives me an error about it not being an index column. So where can I find an example of creating a column family with one or more columns being "Inde

Re: Creating an "Index" column...

2013-06-26 Thread Tony Anecito
Never mind I figured it out. I found it via a search for Secondary indexes. Regards, -Tony From: Tony Anecito To: Users-Cassandra Sent: Wednesday, June 26, 2013 10:39 AM Subject: Creating an "Index" column... Hi All, I have a column f

Support for Batching when?

2013-06-26 Thread Tony Anecito
Hi All, I noticed the JDBC driver supports batching of preparedStatements but when I checked into it via google there were comments that it was not supported on the server side and that was early this Month it was mentioned. So I assume that is still the status but is there some idea when batch

Re: Creating an "Index" column...

2013-06-26 Thread Tony Anecito
learning fast and there are some challenges when moving to a new data model driven by these factors. Regards, -Tony From: Robert Coli To: user@cassandra.apache.org; Tony Anecito Sent: Wednesday, June 26, 2013 11:32 AM Subject: Re: Creating an "Index&qu

Re: Creating an "Index" column...

2013-06-26 Thread Tony Anecito
_____ From: Arthur Zubarev To: Tony Anecito ; Robert Coli ; Users-Cassandra Sent: Wednesday, June 26, 2013 3:08 PM Subject: Re: Creating an "Index" column... Tony hi,   Yes, in some scenarios (e.g. a DW), e.g. absence of proper PKs or indexes (just too hard to envision, you need

Re: Creating an "Index" column...

2013-06-27 Thread Tony Anecito
starting to understand it and I agree with you comments it just depends upon your requirements.   Regards, -Tony From: Arthur Zubarev To: Tony Anecito Cc: Robert Coli ; Users-Cassandra Sent: Wednesday, June 26, 2013 9:40 PM Subject: Re: Creating an "Index" column... Appre

Strange preparedStatment response...

2013-07-02 Thread Tony Anecito
Hi All, Using JDBC prepareStatement when I use secondary index and use that in preparedStatement I get no rows back. If I replace the ? with a integer I get the rows back I expect. If I use setObject() instead of setInt() I get the following exception:  encountered object of class: class java.la

What is best Cassandra client?

2013-07-04 Thread Tony Anecito
Hi All, What is the best client to use? I want to use CQL 3.0.3 and have support for preparedStatmements. I tried JDBC and the thrift client so far.   Thanks!

Re: What is best Cassandra client?

2013-07-04 Thread Tony Anecito
Where can I get a compiled jar? I found out about this yesterday but do not have environment setup to compile it.   Thanks! From: Theo Hultberg To: user@cassandra.apache.org; Tony Anecito Sent: Thursday, July 4, 2013 2:34 AM Subject: Re: What is best Cassandra client? Datastax Java driver

Re: What is best Cassandra client?

2013-07-04 Thread Tony Anecito
Thanks I found the jar in the maven repository.   -Tony From: Theo Hultberg To: user@cassandra.apache.org; Tony Anecito Sent: Thursday, July 4, 2013 2:34 AM Subject: Re: What is best Cassandra client? Datastax Java driver: https://github.com/datastax/java-driver T# On Thu, Jul 4, 2013

CQL and IN

2013-07-04 Thread Tony Anecito
Hi All,   I am using the DataStax driver and got prepared to work. When I tried to use the "IN" keyword with a SQL it did not work. According to DataStax IN should work.   So if I tried:   Select * from items Where item_id IN (Select item_id FROM users where user_id = ?)     Thanks for the feedb

How to build indexes?

2013-07-04 Thread Tony Anecito
Hi All, I updated a table with a secondary index. I discovered using CLI describe that the index was not built. How do I build an index after I have altered an existing table with data? I looked at nodetool and cli and saw no command that had the word build index associated with it. And most o

Re: How to build indexes?

2013-07-05 Thread Tony Anecito
Thanks, Apparently for 1.2.5 it did not build automatically. Diescribe shows index[] which indicates it was not built.   I will try the nodetool command. I dd not see it in the hep list though.   Best Regards, -Tony From: Sylvain Lebresne To: "user@cassandra.apache.org" ; Tony Aneci

Re: How to build indexes?

2013-07-05 Thread Tony Anecito
ava org.apache.cassandra.tools.NodeCmd --host What am I doing wrong? Is there good documentation somewhere with command line example? Thanks, -Tony From: Sylvain Lebresne To: "user@cassandra.apache.org" ; Tony Anecito Sent: Friday, July 5, 2013 3:

Query problem resolved...

2013-07-06 Thread Tony Anecito
Hi All,   Had problems with prepared statements not working with Datastax driver and JDBC driver. I discovered that when changing indexes yoy need to change column family caching from All to None then back again. Problem is sometimes CLI crashes when you do that and you need to run it again. I t

Cassandra intermittant with query in 1.2.5...

2013-07-06 Thread Tony Anecito
back to the starting state.   I hope someone can tell me why Cassandra is doing this. Is there someing I need to do so that when I set caching to ALL for my column table and I stop-start Cassandra the query still works?   Thanks, -Tony   From: Tony Anecito To: Users-Cassandra Sent: Saturday

Re: CQL and IN

2013-07-08 Thread Tony Anecito
uly 2013 23:16, Rui Vieira wrote: > >CQL does not support sub-queries. >> >> >> >>On 4 July 2013 22:53, Tony Anecito wrote: >> >>Hi All, >>> >>>I am using the DataStax driver and got prepared to work. When I tried to use >>>the

Re: Cassandra intermittant with query in 1.2.5...

2013-07-08 Thread Tony Anecito
and repeated it. I can see how this got past all the automated testing.   Regards, Tony Anecito JavaOne 2010 Dukes Award Winner Outstanding Developer and Future of Java Award Winner Founder/President MyUniPortal http://www.myuniportal.com From: Robert Coli To: user@cassandra.apache.org; Tony

Re: Cassandra intermittant with query in 1.2.5...

2013-07-08 Thread Tony Anecito
I will try the pre-prod environment to see what happens.   I filed the issue in JIRA.   Thanks! From: Tony Anecito To: Robert Coli ; "user@cassandra.apache.org" Sent: Monday, July 8, 2013 3:18 PM Subject: Re: Cassandra intermittant with query in 1.2.5... Thanks Robert I will

Re: Cassandra intermittant with query in 1.2.5...

2013-07-09 Thread Tony Anecito
, -Tony From: Robert Coli To: Tony Anecito Cc: "user@cassandra.apache.org" Sent: Monday, July 8, 2013 4:27 PM Subject: Re: Cassandra intermittant with query in 1.2.5... On Mon, Jul 8, 2013 at 2:39 PM, Tony Anecito wrote: I filed the issue in JIRA. For those playing along at hom

Cassandra performance tuning...

2013-07-10 Thread Tony Anecito
Hi All, I am trying to compare Cassandra to another relational database. I am getting around 2-3msec response time using Datastax driver, Java 1.7.0_05 64-bit jre and the other database is under 500 microseconds for the jdbc SQL preparedStatement execute.. One of the major differences is Cassan

Recordset capabilities...

2013-07-15 Thread Tony Anecito
Hi All, I am using the Datastax native client for Cassandra and have a question. Does the resultset contain all the Rows? On a JDBC driver there is this concept of fetch record size. I do not seem to think Datastax did that in their implementation but that probably is not a requirement. But I b

Re: Recordset capabilities...

2013-07-16 Thread Tony Anecito
: "user@cassandra.apache.org" ; Tony Anecito Sent: Tuesday, July 16, 2013 12:10 AM Subject: Re: Recordset capabilities... Yes, currently the resultSet will contain all the rows, there is no "fetch size" supported. This will change soon however since Cassandra 2.0 has some

Intresting issue with getting Order By to work...

2013-07-16 Thread Tony Anecito
Hi All, Well I got most everything working I wanted using Cassandra then discovered I needed to use an Order By. I am using Cassandra 1.2.5. The use of Order By requires Primary Key which appears to be only supported by by using CQL and not Cassandra-cli. So I dropped my table created uisng CLI

Re: Intresting issue with getting Order By to work...

2013-07-17 Thread Tony Anecito
will post to Datastax the same question Please ask questions to one group at a time so people do not waste their time providing answers you already have. Cheers - Aaron Morton Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com/ On 17/07/2013, at 3:44

Re: Intresting issue with getting Order By to work...

2013-07-18 Thread Tony Anecito
, at 11:38 PM, Tony Anecito wrote: Thanks for the answers. >  >The reason why I ask is it is stated the composite keys are not the same as >Primary Key. I found no examples for thrift where it specifcally said the >composite key is a primary key required by order by. All the ex

Re: Intresting issue with getting Order By to work...

2013-07-18 Thread Tony Anecito
ct me if I'm wrong.  On 17/07/2013, at 3:44 PM, Tony Anecito wrote: >> >>> Hi All, >>> >>> Well I got most everything working I wanted using Cassandra then discovered >>> I needed to use an Order By. I am using Cassandra 1.2.5. >>> The

Re: Intresting issue with getting Order By to work...

2013-07-18 Thread Tony Anecito
To: "user@cassandra.apache.org" ; Tony Anecito Sent: Thursday, July 18, 2013 10:16 AM Subject: Re: Intresting issue with getting Order By to work... On Thu, Jul 18, 2013 at 8:12 AM, Tony Anecito wrote:  As I work more with CQL and CLI as some other posting I have seen regarding usage I am t

Intresting issue with getting Order By to work...

2013-07-30 Thread Tony Anecito
Hi All, I am trying to have a table that I can have a key for one CQL to get a row based on a key and another CQL to where I have a list of keys using the "IN" keyword and have an ORDER BY clause. The data I am getting is from the Column value not the Column Name. The issue I am having is tryin

Any good GUI based tool to manage data in Casandra?

2013-08-02 Thread Tony Anecito
Hi All, Is there a GUI tool for managing data in Cassandra database? I have google and seen tools but they seem to be schema management or explorer to just view data. IT would be great to delete/inset rows or update values for a column via GUI. Thanks, -Tony

Re: Choosing Java Driver for using Cassandra with Java EE7

2013-08-03 Thread Tony Anecito
I use the DataStax driver anm happy with it so far. Also, think about if driver is being worked on as Cassandra gets updated since CQL version always getting improved so driver needs to improve wth it. So if driver developers not work on it often then you should not use it. Also, I think DataSta

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

2013-08-06 Thread Tony Anecito
in Casandra? There is a list here.  http://wiki.apache.org/cassandra/Administration%20Tools Cheers - Aaron Morton Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com/ On 3/08/2013, at 6:19 AM, Tony Anecito wrote: Hi All, > > >Is there a GUI

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

2013-08-07 Thread Tony Anecito
>http://www.thelastpickle.com > >On 7/08/2013, at 1:28 AM, Tony Anecito wrote: > >Thanks Aaron. I found that before I asked the question and Helenos seems the >closest but it does not allow you to easily use CRUD like say SQL Server >Management tools where you can get a

Re: [RELEASE] Apache Cassandra 2.0.0 RC 1

2013-08-08 Thread Tony Anecito
Congradulations on all your hard work!   Can 1.2.5 run alongside of 2.0.0 RC 1?   Thanks, -Tony From: Eric Evans To: user@cassandra.apache.org Sent: Thursday, August 8, 2013 1:44 PM Subject: [RELEASE] Apache Cassandra 2.0.0 RC 1 The Cassandra team is pleased to announce the first release cand

Re: Why don't you start off with a "single & small" Cassandra server as you usually do it with MySQL ?

2013-08-27 Thread Tony Anecito
I agree. I ran into a issue where I ran a single instance and the server was shut down (without stopping cassandra) and for some reason I lost the database schema. I was back up quickly only because I had scripts to create the schema and a backup of the data to load once the schema was created.