unsubscribe
Can you please unsubscribe me from this group
unsubscribe
unsubscribe me please. Thank you
Re: cassandra on re-Start
Hi, I think you did not get what i stated above: I will restate the complete problem again. I had created a keyspace named 'XYZ' in linux. I was able to access it through the java app. The system was then restarted once. Now when we tried to access the keyspace 'XYZ' ,it says it cannot locate 'XYZ'. ( I am trying to access it through a java app ,also through cqlsh and cassandra-cli) And when i try to recreate the keyspace 'XYZ' ,it gives a Ttransport exception. The keyspace 'DA' folder still exists in the hard disk. *I am not able to access it.* On Fri, Jul 6, 2012 at 4:33 AM, aaron morton aa...@thelastpickle.comwrote: Sounds like this problem in 1.1.0 https://issues.apache.org/jira/browse/CASSANDRA-4219 upgrade if you are on 1.1.0 If not please paste the entire exception. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 6/07/2012, at 1:32 AM, puneet loya wrote: -- Forwarded message -- From: Rob Coli rc...@palominodb.com Date: Mon, Jul 2, 2012 at 11:19 PM Subject: Re: cassandra on re-Start To: user@cassandra.apache.org On Mon, Jul 2, 2012 at 5:43 AM, puneet loya puneetl...@gmail.com wrote: When I restarted the system , it is showing the keyspace does not exist. Not even letting me to create the keyspace with the same name again. Paste the error you get. =Rob -- =Robert Coli AIMGTALK - rc...@palominodb.com YAHOO - rcoli.palominob SKYPE - rcoli_palominodb The name of the keyspace is DA. On tryinh to create the keyspace it is giving an exception. I am getting a Ttransport exception for creating the keyspace. Previous keyspace 'DA that was created still exists. Because when i checked the folders,the folder with name 'DA' still exists but i cannot access it. Cheers, Puneet
Re: cassandra on re-Start
-- Forwarded message -- From: Rob Coli rc...@palominodb.com Date: Mon, Jul 2, 2012 at 11:19 PM Subject: Re: cassandra on re-Start To: user@cassandra.apache.org On Mon, Jul 2, 2012 at 5:43 AM, puneet loya puneetl...@gmail.com wrote: When I restarted the system , it is showing the keyspace does not exist. Not even letting me to create the keyspace with the same name again. Paste the error you get. =Rob -- =Robert Coli AIMGTALK - rc...@palominodb.com YAHOO - rcoli.palominob SKYPE - rcoli_palominodb The name of the keyspace is DA. On tryinh to create the keyspace it is giving an exception. I am getting a Ttransport exception for creating the keyspace. Previous keyspace 'DA that was created still exists. Because when i checked the folders,the folder with name 'DA' still exists but i cannot access it. Cheers, Puneet
cassandra on re-Start
Hi, I have set up cassandra on my linux system. When I restarted the system , it is showing the keyspace does not exist. Not even letting me to create the keyspace with the same name again. Did anybody find this issue? Any solutions on it? Cheers, Puneet
auto-generate data
Can we auto-generate random data in cassandra? Thanks and Regaads, Puneet
Re: insert data in cassandra from .net..
Thnx a lot :) :) On Sat, Apr 14, 2012 at 11:59 PM, aaron morton aa...@thelastpickle.comwrote: but using insert query of cql is not working because i have fields in my table which has null values for the columns and cassandra would not take null values. You do not need to insert the null values. How they are handled depends on the .net client you are using. If you really want to insert them try using an empty string. For background here is a good post about using cassandra on windows with links to a couple of .net client libraries… http://kellabyte.com/2012/02/13/getting-started-using-apache-cassandra/ Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/04/2012, at 6:31 PM, puneet loya wrote: I m able to connect cassandra and fetch rows from the cassandra database. Now i want to insert the data from .net on to cassandra but using insert query of cql is not working because i have fields in my table which has null values for the columns and cassandra would not take null values. So now i have to query it the other way.. i.e, i can use set [key] [column name] = column value; but can i send this command from .net to cassandra. I mean we have execute_cql_query() for interacting in a cql way, is there anything available for the other way? that is the commands we execute on cassandra-cli.bat ?
insert data in cassandra from .net..
I m able to connect cassandra and fetch rows from the cassandra database. Now i want to insert the data from .net on to cassandra but using insert query of cql is not working because i have fields in my table which has null values for the columns and cassandra would not take null values. So now i have to query it the other way.. i.e, i can use set [key] [column name] = column value; but can i send this command from .net to cassandra. I mean we have execute_cql_query() for interacting in a cql way, is there anything available for the other way? that is the commands we execute on cassandra-cli.bat ?
super column
Can a super column contain a super column? I mean is nesting of supercolumns possible? Regards, Puneet :)
Re: super column
what is composite columns? super column under it can contain just multiple columns.. will composite columns be useful? On Thu, Apr 12, 2012 at 3:50 PM, Paolo Bernardi berna...@gmail.com wrote: No. Maybe that a super column can contain composite columns but I'm not sure. Paolo On Apr 12, 2012 12:15 PM, puneet loya puneetl...@gmail.com wrote: Can a super column contain a super column? I mean is nesting of supercolumns possible? Regards, Puneet :)
insert in cql
insert into users (KEY) values (512313); users is my column family and key is its only attribute.. It is giving an error bad request : line 1:24 required (...)+ loop did not match anything at input ')' do you find any error here?
Re: insert in cql
thank you :) On Wed, Apr 11, 2012 at 8:55 PM, Eric Evans eev...@acunu.com wrote: On Wed, Apr 11, 2012 at 5:20 AM, puneet loya puneetl...@gmail.com wrote: insert into users (KEY) values (512313); users is my column family and key is its only attribute.. It is giving an error bad request : line 1:24 required (...)+ loop did not match anything at input ')' do you find any error here? Yes. KEY here is presumably the row key (aka PRIMARY KEY) and you cannot store an otherwise empty row, you need at least one actual column. -- Eric Evans Acunu | http://www.acunu.com | @acunu
Re: cassandra and .net
is using cassandra from datastax community center software an issue for not be able to connect with .net? On Tue, Apr 10, 2012 at 11:24 AM, Maki Watanabe watanabe.m...@gmail.comwrote: Check your cassandra log. If you can't find any interesting log, set cassandra log level to DEBUG and run your program again. maki 2012/4/10 puneet loya puneetl...@gmail.com: hi, sorry i posted the port as 7000. I m using 9160 but still has the same error. Cannot read, Remote side has closed. Can u guess whats happening?? On Tue, Apr 10, 2012 at 11:00 AM, Pierre Chalamet pie...@chalamet.net wrote: hello, 9160 is probably the port to use if you use the default config. - Pierre On Apr 10, 2012, at 7:26 AM, puneet loya puneetl...@gmail.com wrote: using System; using System.Collections.Generic; using System.Linq; using System.Text; using Thrift.Collections; using Thrift.Protocol; using Thrift.Transport; using Apache.Cassandra; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { TTransport transport=null; try { transport = new TBufferedTransport(new TSocket(127.0.0.1, 7000)); //if(buffered) //trans = new TBufferedTransport(trans as TStreamTransport); //if (framed) //trans = new TFramedTransport(trans); TProtocol protocol = new TBinaryProtocol(transport); Cassandra.Client client = new Cassandra.Client(protocol); Console.WriteLine(Opening connection); if (!transport.IsOpen) transport.Open(); client.describe_keyspace(abc); // Crashing at this point } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { if(transport!=null) transport.Close(); } Console.ReadLine(); } } } I m trying to interact with cassandra server(database) from .net. For that i have referred two libraries i.e, apacheCassandra08.dll and thrift.dll.. In the following piece of code the connection is getting opened but when i m using client object it is giving an error stating Cannot read, Remote side has closed. Can any1 help me out with this? Has any1 faced the same prob?
Re: cassandra and .net
I checked logs of cassandra.. in the debug state.. I got this response DEBUG [ScheduledTasks:1] 2012-04-10 14:49:29,654 LoadBroadcaster.java (line 86) Disseminating load info ... DEBUG [Thrift:7] 2012-04-10 14:50:00,820 CustomTThreadPoolServer.java (line 197) Thrift transport error occurred during processing of message. org.apache.thrift.transport.TTransportException at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132) at org.apache.thrift.transport.TTransport.readAll(TTransport.java:84) at org.apache.thrift.transport.TFramedTransport.readFrame(TFramedTransport.java:129) at org.apache.thrift.transport.TFramedTransport.read(TFramedTransport.java:101) at org.apache.thrift.transport.TTransport.readAll(TTransport.java:84) at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:378) at org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:297) at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:204) at org.apache.cassandra.thrift.Cassandra$Processor.process(Cassandra.java:2877) at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:187) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) DEBUG [Thrift:7] 2012-04-10 14:50:00,820 ClientState.java (line 104) logged out: #User allow_all groups=[] On Tue, Apr 10, 2012 at 12:03 PM, Pierre Chalamet pie...@chalamet.netwrote: ** Another tentative : try using TFramedTransport with an instance of TSocket directly. - Pierre -- *From: * puneet loya puneetl...@gmail.com *Date: *Tue, 10 Apr 2012 11:06:22 +0530 *To: *user@cassandra.apache.org *ReplyTo: * user@cassandra.apache.org *Subject: *Re: cassandra and .net hi, sorry i posted the port as 7000. I m using 9160 but still has the same error. Cannot read, Remote side has closed. Can u guess whats happening?? On Tue, Apr 10, 2012 at 11:00 AM, Pierre Chalamet pie...@chalamet.netwrote: hello, 9160 is probably the port to use if you use the default config. - Pierre On Apr 10, 2012, at 7:26 AM, puneet loya puneetl...@gmail.com wrote: using System; using System.Collections.Generic; using System.Linq; using System.Text; using Thrift.Collections; using Thrift.Protocol; using Thrift.Transport; using Apache.Cassandra; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { TTransport transport=null; try { transport = new TBufferedTransport(new TSocket(127.0.0.1, 7000)); //if(buffered) //trans = new TBufferedTransport(trans as TStreamTransport); //if (framed) //trans = new TFramedTransport(trans); TProtocol protocol = new TBinaryProtocol(transport); Cassandra.Client client = new Cassandra.Client(protocol); Console.WriteLine(Opening connection); if (!transport.IsOpen) transport.Open(); client.describe_keyspace(abc); // Crashing at this point } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { if(transport!=null) transport.Close(); } Console.ReadLine(); } } } I m trying to interact with cassandra server(database) from .net. For that i have referred two libraries i.e, apacheCassandra08.dll and thrift.dll.. In the following piece of code the connection is getting opened but when i m using client object it is giving an error stating Cannot read, Remote side has closed. Can any1 help me out with this? Has any1 faced the same prob?
Re: cassandra and .net
Log is showing the following exception DEBUG [ScheduledTasks:1] 2012-04-10 14:49:29,654 LoadBroadcaster.java (line 86) Disseminating load info ... DEBUG [Thrift:7] 2012-04-10 14:50:00,820 CustomTThreadPoolServer.java (line 197) Thrift transport error occurred during processing of message. org.apache.thrift.transport.TTransportException at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132) at org.apache.thrift.transport.TTransport.readAll(TTransport.java:84) at org.apache.thrift.transport.TFramedTransport.readFrame(TFramedTransport.java:129) at org.apache.thrift.transport.TFramedTransport.read(TFramedTransport.java:101) at org.apache.thrift.transport.TTransport.readAll(TTransport.java:84) at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:378) at org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:297) at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:204) at org.apache.cassandra.thrift.Cassandra$Processor.process(Cassandra.java:2877) at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:187) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) DEBUG [Thrift:7] 2012-04-10 14:50:00,820 ClientState.java (line 104) logged out: #User allow_all groups=[] On Tue, Apr 10, 2012 at 11:24 AM, Maki Watanabe watanabe.m...@gmail.comwrote: Check your cassandra log. If you can't find any interesting log, set cassandra log level to DEBUG and run your program again. maki 2012/4/10 puneet loya puneetl...@gmail.com: hi, sorry i posted the port as 7000. I m using 9160 but still has the same error. Cannot read, Remote side has closed. Can u guess whats happening?? On Tue, Apr 10, 2012 at 11:00 AM, Pierre Chalamet pie...@chalamet.net wrote: hello, 9160 is probably the port to use if you use the default config. - Pierre On Apr 10, 2012, at 7:26 AM, puneet loya puneetl...@gmail.com wrote: using System; using System.Collections.Generic; using System.Linq; using System.Text; using Thrift.Collections; using Thrift.Protocol; using Thrift.Transport; using Apache.Cassandra; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { TTransport transport=null; try { transport = new TBufferedTransport(new TSocket(127.0.0.1, 7000)); //if(buffered) //trans = new TBufferedTransport(trans as TStreamTransport); //if (framed) //trans = new TFramedTransport(trans); TProtocol protocol = new TBinaryProtocol(transport); Cassandra.Client client = new Cassandra.Client(protocol); Console.WriteLine(Opening connection); if (!transport.IsOpen) transport.Open(); client.describe_keyspace(abc); // Crashing at this point } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { if(transport!=null) transport.Close(); } Console.ReadLine(); } } } I m trying to interact with cassandra server(database) from .net. For that i have referred two libraries i.e, apacheCassandra08.dll and thrift.dll.. In the following piece of code the connection is getting opened but when i m using client object it is giving an error stating Cannot read, Remote side has closed. Can any1 help me out with this? Has any1 faced the same prob?
Re: cassandra and .net
thankk :) :) it works :) On Tue, Apr 10, 2012 at 3:07 PM, Henrik Schröder skro...@gmail.com wrote: In your code you are using BufferedTransport, but in the Cassandra logs you're getting errors when it tries to use FramedTransport. If I remember correctly, BufferedTransport is gone, so you should only use FramedTransport. Like this: TTransport transport = new TFramedTransport(new TSocket(host, port)); TProtocol protocol = new TBinaryProtocol(transport); var client = new Cassandra.Client(protocol); transport.Open(); client.describe_keyspace(abc); /Henrik On Tue, Apr 10, 2012 at 11:23, puneet loya puneetl...@gmail.com wrote: Log is showing the following exception DEBUG [ScheduledTasks:1] 2012-04-10 14:49:29,654 LoadBroadcaster.java (line 86) Disseminating load info ... DEBUG [Thrift:7] 2012-04-10 14:50:00,820 CustomTThreadPoolServer.java (line 197) Thrift transport error occurred during processing of message. org.apache.thrift.transport.TTransportException at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132) at org.apache.thrift.transport.TTransport.readAll(TTransport.java:84) at org.apache.thrift.transport.TFramedTransport.readFrame(TFramedTransport.java:129) at org.apache.thrift.transport.TFramedTransport.read(TFramedTransport.java:101) at org.apache.thrift.transport.TTransport.readAll(TTransport.java:84) at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:378) at org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:297) at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:204) at org.apache.cassandra.thrift.Cassandra$Processor.process(Cassandra.java:2877) at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:187) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) DEBUG [Thrift:7] 2012-04-10 14:50:00,820 ClientState.java (line 104) logged out: #User allow_all groups=[] On Tue, Apr 10, 2012 at 11:24 AM, Maki Watanabe watanabe.m...@gmail.comwrote: Check your cassandra log. If you can't find any interesting log, set cassandra log level to DEBUG and run your program again. maki 2012/4/10 puneet loya puneetl...@gmail.com: hi, sorry i posted the port as 7000. I m using 9160 but still has the same error. Cannot read, Remote side has closed. Can u guess whats happening?? On Tue, Apr 10, 2012 at 11:00 AM, Pierre Chalamet pie...@chalamet.net wrote: hello, 9160 is probably the port to use if you use the default config. - Pierre On Apr 10, 2012, at 7:26 AM, puneet loya puneetl...@gmail.com wrote: using System; using System.Collections.Generic; using System.Linq; using System.Text; using Thrift.Collections; using Thrift.Protocol; using Thrift.Transport; using Apache.Cassandra; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { TTransport transport=null; try { transport = new TBufferedTransport(new TSocket(127.0.0.1, 7000)); //if(buffered) //trans = new TBufferedTransport(trans as TStreamTransport); //if (framed) //trans = new TFramedTransport(trans); TProtocol protocol = new TBinaryProtocol(transport); Cassandra.Client client = new Cassandra.Client(protocol); Console.WriteLine(Opening connection); if (!transport.IsOpen) transport.Open(); client.describe_keyspace(abc); // Crashing at this point } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { if(transport!=null) transport.Close(); } Console.ReadLine(); } } } I m trying to interact with cassandra server(database) from .net. For that i have referred two libraries i.e, apacheCassandra08.dll and thrift.dll.. In the following piece of code the connection is getting opened but when i m using client object it is giving an error stating Cannot read, Remote side has closed. Can any1 help me out with this? Has any1 faced the same prob?
cassandra and .net
using System; using System.Collections.Generic; using System.Linq; using System.Text; using Thrift.Collections; using Thrift.Protocol; using Thrift.Transport; using Apache.Cassandra; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { TTransport transport=null; try { transport = new TBufferedTransport(new TSocket(127.0.0.1, 7000)); //if(buffered) //trans = new TBufferedTransport(trans as TStreamTransport); //if (framed) //trans = new TFramedTransport(trans); TProtocol protocol = new TBinaryProtocol(transport); Cassandra.Client client = new Cassandra.Client(protocol); Console.WriteLine(Opening connection); if (!transport.IsOpen) transport.Open(); client.describe_keyspace(abc); // Crashing at this point } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { if(transport!=null) transport.Close(); } Console.ReadLine(); } } } I m trying to interact with cassandra server(database) from .net. For that i have referred two libraries i.e, apacheCassandra08.dll and thrift.dll.. In the following piece of code the connection is getting opened but when i m using client object it is giving an error stating Cannot read, Remote side has closed. Can any1 help me out with this? Has any1 faced the same prob?
Re: cassandra and .net
hi, sorry i posted the port as 7000. I m using 9160 but still has the same error. Cannot read, Remote side has closed. Can u guess whats happening?? On Tue, Apr 10, 2012 at 11:00 AM, Pierre Chalamet pie...@chalamet.netwrote: hello, 9160 is probably the port to use if you use the default config. - Pierre On Apr 10, 2012, at 7:26 AM, puneet loya puneetl...@gmail.com wrote: using System; using System.Collections.Generic; using System.Linq; using System.Text; using Thrift.Collections; using Thrift.Protocol; using Thrift.Transport; using Apache.Cassandra; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { TTransport transport=null; try { transport = new TBufferedTransport(new TSocket(127.0.0.1, 7000)); //if(buffered) //trans = new TBufferedTransport(trans as TStreamTransport); //if (framed) //trans = new TFramedTransport(trans); TProtocol protocol = new TBinaryProtocol(transport); Cassandra.Client client = new Cassandra.Client(protocol); Console.WriteLine(Opening connection); if (!transport.IsOpen) transport.Open(); client.describe_keyspace(abc); // Crashing at this point } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { if(transport!=null) transport.Close(); } Console.ReadLine(); } } } I m trying to interact with cassandra server(database) from .net. For that i have referred two libraries i.e, apacheCassandra08.dll and thrift.dll.. In the following piece of code the connection is getting opened but when i m using client object it is giving an error stating Cannot read, Remote side has closed. Can any1 help me out with this? Has any1 faced the same prob?
Re: cassandra 1.08 on java7 and win7
thank u Gopala :) Der is no issue with it.. Might be i was typing something wrong.,. Minor mistake :) On Tue, Apr 3, 2012 at 11:51 PM, Gopala f2001...@gmail.com wrote: puneet loya puneetloya at gmail.com writes: create keyspace DEMO with placement_strategy = 'org.apache.cassandra.locator.NetworkTopologyStrategy' and strategy_options=[{datacenter1:1}]; try it n check if it executes Hi Puneet, I have same issue. Running the command you mentioned below works for me. What is the issue here? Gopala
C# + cassandra
hi every1, * * any good example of C# cassandra? I have downloaded the cassandra-sharp driver for the communication.. I need some examples. Any good references u can suggest? Regards, Puneet Loya
Re: problem in create column family
thank u *:))* On Sat, Mar 31, 2012 at 4:51 AM, aaron morton aa...@thelastpickle.comwrote: This works… create column family student with comparator = 'AsciiType' and column_metadata = [{ column_name : name, validation_class : 'AsciiType' }]; * use compatator instead of coluimn_type. * closing ' missing Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 28/03/2012, at 12:41 AM, puneet loya wrote: create column family student with column_type = 'AsciiType' and column_metadata = [{ column_name : name, validation_class : 'AsciiType }]; On Tue, Mar 27, 2012 at 1:48 PM, Guy Incognito dnd1...@gmail.com wrote: why don't you show us the command you're actually trying to run? On 27/03/2012 08:52, puneet loya wrote: I m using cassandra 1.0.8.. Please reply On Tue, Mar 27, 2012 at 12:28 PM, R. Verlangen ro...@us2.nl wrote: Not sure about that, what version of Cassandra are you using? Maybe someone else here knows how to solve this.. 2012/3/27 puneet loya puneetl...@gmail.com ya had created with UTF8Type before.. It gave the same error. On executing help assume command it is giving 'utf8' as a type. so can i use comparator='utf8' or not?? Please reply On Mon, Mar 26, 2012 at 9:17 PM, R. Verlangen ro...@us2.nl wrote: You should use the full type names, e.g. create column family MyColumnFamily with comparator=UTF8Type; 2012/3/26 puneet loya puneetl...@gmail.com It is giving errors like Unable to find abstract-type class 'org.apache.cassandra.db.marshal.utf8' and java.lang.RuntimeException: org.apache.cassandra.db.marshal.MarshalException: cannot parse 'catalogueId' as hex bytes where catalogueId is a column that has utf8 as its data type. they may be just synactical errors.. Please suggest if u can help me out on dis?? -- With kind regards, Robin Verlangen www.robinverlangen.nl -- With kind regards, Robin Verlangen www.robinverlangen.nl
opscenter
I m currently using the the datastax opscenter. How do we add column to the column families in opscenter??
Re: opscenter
thank you :) I m using cqlsh now.. Its workin.. Can we add an autoincrement field using cqlsh?? On Thu, Mar 29, 2012 at 2:23 PM, R. Verlangen ro...@us2.nl wrote: As far as I'm aware of that is not possible using the opscenter. I recommend you use the cassandra-cli and perform an update column family query. 2012/3/29 puneet loya puneetl...@gmail.com I m currently using the the datastax opscenter. How do we add column to the column families in opscenter?? -- With kind regards, Robin Verlangen www.robinverlangen.nl
Re: problem in create column family
ya had created with UTF8Type before.. It gave the same error. On executing help assume command it is giving 'utf8' as a type. so can i use comparator='utf8' or not?? Please reply On Mon, Mar 26, 2012 at 9:17 PM, R. Verlangen ro...@us2.nl wrote: You should use the full type names, e.g. create column family MyColumnFamily with comparator=UTF8Type; 2012/3/26 puneet loya puneetl...@gmail.com It is giving errors like Unable to find abstract-type class 'org.apache.cassandra.db.marshal.utf8' and java.lang.RuntimeException: org.apache.cassandra.db.marshal.MarshalException: cannot parse 'catalogueId' as hex bytes where catalogueId is a column that has utf8 as its data type. they may be just synactical errors.. Please suggest if u can help me out on dis?? -- With kind regards, Robin Verlangen www.robinverlangen.nl
Re: problem in create column family
I m using cassandra 1.0.8.. Please reply On Tue, Mar 27, 2012 at 12:28 PM, R. Verlangen ro...@us2.nl wrote: Not sure about that, what version of Cassandra are you using? Maybe someone else here knows how to solve this.. 2012/3/27 puneet loya puneetl...@gmail.com ya had created with UTF8Type before.. It gave the same error. On executing help assume command it is giving 'utf8' as a type. so can i use comparator='utf8' or not?? Please reply On Mon, Mar 26, 2012 at 9:17 PM, R. Verlangen ro...@us2.nl wrote: You should use the full type names, e.g. create column family MyColumnFamily with comparator=UTF8Type; 2012/3/26 puneet loya puneetl...@gmail.com It is giving errors like Unable to find abstract-type class 'org.apache.cassandra.db.marshal.utf8' and java.lang.RuntimeException: org.apache.cassandra.db.marshal.MarshalException: cannot parse 'catalogueId' as hex bytes where catalogueId is a column that has utf8 as its data type. they may be just synactical errors.. Please suggest if u can help me out on dis?? -- With kind regards, Robin Verlangen www.robinverlangen.nl -- With kind regards, Robin Verlangen www.robinverlangen.nl
Re: problem in create column family
create column family student with column_type = 'AsciiType' and column_metadata = [{ column_name : name, validation_class : 'AsciiType }]; On Tue, Mar 27, 2012 at 1:48 PM, Guy Incognito dnd1...@gmail.com wrote: why don't you show us the command you're actually trying to run? On 27/03/2012 08:52, puneet loya wrote: I m using cassandra 1.0.8.. Please reply On Tue, Mar 27, 2012 at 12:28 PM, R. Verlangen ro...@us2.nl wrote: Not sure about that, what version of Cassandra are you using? Maybe someone else here knows how to solve this.. 2012/3/27 puneet loya puneetl...@gmail.com ya had created with UTF8Type before.. It gave the same error. On executing help assume command it is giving 'utf8' as a type. so can i use comparator='utf8' or not?? Please reply On Mon, Mar 26, 2012 at 9:17 PM, R. Verlangen ro...@us2.nl wrote: You should use the full type names, e.g. create column family MyColumnFamily with comparator=UTF8Type; 2012/3/26 puneet loya puneetl...@gmail.com It is giving errors like Unable to find abstract-type class 'org.apache.cassandra.db.marshal.utf8' and java.lang.RuntimeException: org.apache.cassandra.db.marshal.MarshalException: cannot parse 'catalogueId' as hex bytes where catalogueId is a column that has utf8 as its data type. they may be just synactical errors.. Please suggest if u can help me out on dis?? -- With kind regards, Robin Verlangen www.robinverlangen.nl -- With kind regards, Robin Verlangen www.robinverlangen.nl
counter column family
Can u give an example of create column family with counter column in it. Please reply Regards, Puneet Loya
Re: cassandra 1.08 on java7 and win7
create keyspace DEMO with placement_strategy = 'org.apache.cassandra.locator.NetworkTopologyStrategy' and strategy_options=[{datacenter1:1}]; try it n check if it executes On Tue, Mar 27, 2012 at 3:35 AM, Frank Hsueh frank.hs...@gmail.com wrote: create keyspace via cassandra cli fails https://issues.apache.org/jira/browse/CASSANDRA-4085 On Mon, Mar 26, 2012 at 2:44 PM, Sasha Dolgy sdo...@gmail.com wrote: best to open an issue: https://issues.apache.org/jira/browse/CASSANDRA On Mon, Mar 26, 2012 at 11:35 PM, Frank Hsueh frank.hs...@gmail.comwrote: err ... same thing happens with Java 1.6 On Mon, Mar 26, 2012 at 2:35 PM, Frank Hsueh frank.hs...@gmail.comwrote: I'm using the latest of Java 1.6 from Oracle. On Mon, Mar 26, 2012 at 2:29 PM, R. Verlangen ro...@us2.nl wrote: Ben Coverston wrote earlier today: Use a version of the Java 6 runtime, Cassandra hasn't been tested at all with the Java 7 runtime So I think that might be a good way to start. 2012/3/26 Frank Hsueh frank.hs...@gmail.com I think I have cassandra the server started In another window: cassandra-cli.bat -h localhost -p 9160 Starting Cassandra Client Connected to: Test Cluster on localhost/9160 Welcome to Cassandra CLI version 1.0.8 Type 'help;' or '?' for help. Type 'quit;' or 'exit;' to quit. [default@unknown] create keyspace DEMO; log4j:WARN No appenders could be found for logger (org.apache.cassandra.config.DatabaseDescriptor). log4j:WARN Please initialize the log4j system properly. log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfigfor more info. Cannot locate cassandra.yaml Fatal configuration error; unable to start server. See log for stacktrace. C:\Workspace\cassandra\apache-cassandra-1.0.8\bin anybody seen this before ? -- Frank Hsueh | frank.hs...@gmail.com -- With kind regards, Robin Verlangen www.robinverlangen.nl -- Frank Hsueh | frank.hs...@gmail.com -- Frank Hsueh | frank.hs...@gmail.com -- Sasha Dolgy sasha.do...@gmail.com -- Frank Hsueh | frank.hs...@gmail.com
create column family
create column family users (uuid PRIMARY KEY firstname text, lastname text, email text, address text, zip int, state text); Is dis above statement correct? I m getting an error Syntax error at position 27: missing EOF at '(' Do reply Can u suggest the most stable version of cassandra??
Re: counter column family
thanxx a ton :) :) the counter column family works synonymous as 'auto increment' in other databases rite? I mean we have a column of type integer which increments with every insert. Am i goin the rite way?? please reply :) On Tue, Mar 27, 2012 at 5:50 PM, R. Verlangen ro...@us2.nl wrote: *create column family MyCounterColumnFamily with default_validation_class=CounterColumnType and key_validation_class=UTF8Type and comparator=UTF8Type;* There you go! Keys must be utf8, as well as the column names. Of course you can change those validators. Cheers! 2012/3/27 puneet loya puneetl...@gmail.com Can u give an example of create column family with counter column in it. Please reply Regards, Puneet Loya -- With kind regards, Robin Verlangen www.robinverlangen.nl
Re: create column family
how to use cql?? Rite now i m running dis file cassandra-cli.bat i connect localhost/9160; den i went into use pun; //its a keyspace using the create statement create COLUMNFAMILY users (KY uuid PRIMARY KEY*,* firstname text, lastname text, email text, address text, zip int, state text);** it is gining error?? how to write in cql?? do we have to shift to some other environment.. for using cql On Tue, Mar 27, 2012 at 5:58 PM, Rishabh Agrawal rishabh.agra...@impetus.co.in wrote: If you are using cql then following statement is more apt: create COLUMNFAMILY users (KY uuid PRIMARY KEY*,* firstname text, lastname text, email text, address text, zip int, state text);** *From:* puneet loya [mailto:puneetl...@gmail.com] *Sent:* Tuesday, March 27, 2012 5:54 PM *To:* user@cassandra.apache.org *Subject:* create column family create column family users (uuid PRIMARY KEY firstname text, lastname text, email text, address text, zip int, state text); Is dis above statement correct? I m getting an error Syntax error at position 27: missing EOF at '(' Do reply Can u suggest the most stable version of cassandra?? -- Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22. Know more about our Big Data quick-start program at the event. New Impetus webcast ‘Cloud-enabled Performance Testing vis-à-vis On-premise’ available at http://bit.ly/z6zT4L. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
import
I want to import files from excel to cassandra? Is it possible?? Any tool that can help?? Whats the best way?? Plz reply :)
Re: counter column family
wen i m using a counter column.. i m nt able to add columns of other type to the column family.. is it so or it is just synactical error?? [default@CMDCv99] create column family status ... with comparator = AsciiType ... and column_metadata = ... [{ ... column_name : Test, ... validation_class : IntegerType, ... index_type : 0, ... index_name : IdxName}, ... { ... column_name : 'other name', ... validation_class : CounterColumnType ... }]; Cannot add a counter column (other name) in a non counter column family On Tue, Mar 27, 2012 at 6:55 PM, R. Verlangen ro...@us2.nl wrote: You should use a connection pool without retries to prevent a single increment of +1 have a result of e.g. +3. 2012/3/27 Rishabh Agrawal rishabh.agra...@impetus.co.in You can even define how much increment you want. But let me just warn you, as far my knowledge, it has consistency issues. *From:* puneet loya [mailto:puneetl...@gmail.com] *Sent:* Tuesday, March 27, 2012 5:59 PM *To:* user@cassandra.apache.org *Subject:* Re: counter column family thanxx a ton :) :) the counter column family works synonymous as 'auto increment' in other databases rite? I mean we have a column of type integer which increments with every insert. Am i goin the rite way?? please reply :) On Tue, Mar 27, 2012 at 5:50 PM, R. Verlangen ro...@us2.nl wrote: *create column family MyCounterColumnFamily with default_validation_class=CounterColumnType and key_validation_class=UTF8Type and comparator=UTF8Type;* There you go! Keys must be utf8, as well as the column names. Of course you can change those validators. Cheers! 2012/3/27 puneet loya puneetl...@gmail.com Can u give an example of create column family with counter column in it. Please reply Regards, Puneet Loya -- With kind regards, Robin Verlangen www.robinverlangen.nl -- Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22. Know more about our Big Data quick-start program at the event. New Impetus webcast ‘Cloud-enabled Performance Testing vis-à-vis On-premise’ available at http://bit.ly/z6zT4L. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. -- With kind regards, Robin Verlangen www.robinverlangen.nl
Re: counter column family
now i want to have a field incrementing with every row insertion. how do i do it in cassandra?? On Tue, Mar 27, 2012 at 7:34 PM, Dave Brosius dbros...@mebigfatguy.comwrote: Counter columns are special, they must be in a column family to themselves. On 03/27/2012 09:32 AM, puneet loya wrote: wen i m using a counter column.. i m nt able to add columns of other type to the column family.. is it so or it is just synactical error?? [default@CMDCv99] create column family status ... with comparator = AsciiType ... and column_metadata = ... [{ ... column_name : Test, ... validation_class : IntegerType, ... index_type : 0, ... index_name : IdxName}, ... { ... column_name : 'other name', ... validation_class : CounterColumnType ... }]; Cannot add a counter column (other name) in a non counter column family On Tue, Mar 27, 2012 at 6:55 PM, R. Verlangen ro...@us2.nl wrote: You should use a connection pool without retries to prevent a single increment of +1 have a result of e.g. +3. 2012/3/27 Rishabh Agrawal rishabh.agra...@impetus.co.in You can even define how much increment you want. But let me just warn you, as far my knowledge, it has consistency issues. *From:* puneet loya [mailto:puneetl...@gmail.com] *Sent:* Tuesday, March 27, 2012 5:59 PM *To:* user@cassandra.apache.org *Subject:* Re: counter column family thanxx a ton :) :) the counter column family works synonymous as 'auto increment' in other databases rite? I mean we have a column of type integer which increments with every insert. Am i goin the rite way?? please reply :) On Tue, Mar 27, 2012 at 5:50 PM, R. Verlangen ro...@us2.nl wrote: *create column family MyCounterColumnFamily with default_validation_class=CounterColumnType and key_validation_class=UTF8Type and comparator=UTF8Type;* There you go! Keys must be utf8, as well as the column names. Of course you can change those validators. Cheers! 2012/3/27 puneet loya puneetl...@gmail.com Can u give an example of create column family with counter column in it. Please reply Regards, Puneet Loya -- With kind regards, Robin Verlangen www.robinverlangen.nl -- Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22. Know more about our Big Data quick-start program at the event. New Impetus webcast ‘Cloud-enabled Performance Testing vis-à-vis On-premise’ available at http://bit.ly/z6zT4L. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. -- With kind regards, Robin Verlangen www.robinverlangen.nl
cqlsh
How do i use the cqlsh comand line utility?? I m using cassandra 1.0.8.. Does cqlsh command line utility comes with the download of cassandra 1.0.8 or we have to do it separately. Suggest a way to go further plz reply :)
Re: cqlsh
i know cqlsh is in the bin directory .. how to run it on Windows? it is not a batch file that can be run directly? Should we use python to execute it?? plz show a way :) Reply On Wed, Mar 28, 2012 at 8:34 AM, Maki Watanabe watanabe.m...@gmail.comwrote: You can find it in the bin directory of the binary distribution. maki 2012/3/27 puneet loya puneetl...@gmail.com: How do i use the cqlsh comand line utility?? I m using cassandra 1.0.8.. Does cqlsh command line utility comes with the download of cassandra 1.0.8 or we have to do it separately. Suggest a way to go further plz reply :)
problem in create column family
It is giving errors like Unable to find abstract-type class 'org.apache.cassandra.db.marshal.utf8' and java.lang.RuntimeException: org.apache.cassandra.db.marshal.MarshalException: cannot parse 'catalogueId' as hex bytes where catalogueId is a column that has utf8 as its data type. they may be just synactical errors.. Please suggest if u can help me out on dis??
Fwd: information on cassandra
hi, I m puneet, an engineering student. I would like to know that, is cassandra useful considering we just have a single node(rather a single system) having all the information. I m looking for decent response time for the database. can you please respond? Thank you , Regards, Puneet Loya