Re: Can not connect with cqlsh to something different than localhost

2014-12-08 Thread Vivek Mishra
Two things: 1. Try telnet 192.168.111.136 9042 and see if it connects? 2. check for hostname in /etc/hosts, if it is mapped correctly. -Vivek On Mon, Dec 8, 2014 at 4:19 PM, Richard Snowden richard.t.snow...@gmail.com wrote: This did not work either. I changed /etc/cassandra.yaml and

Re: node keeps dying

2014-09-25 Thread Vivek Mishra
Increase heap size with Cassandra and try On 25/09/2014 3:02 am, Prem Yadav ipremya...@gmail.com wrote: BTW, thanks Michael. I am surprised why I didn't search for Cassandra oom before. I got some good links that discuss that. Will try to optimize and see how it goes. On Wed, Sep 24, 2014

Re: CQL performance inserting multiple cluster keys under same partition key

2014-08-26 Thread Vivek Mishra
AFAIK, it is not. With CAS it should br On 26/08/2014 10:21 pm, Jaydeep Chovatia chovatia.jayd...@gmail.com wrote: Hi, I have question on inserting multiple cluster keys under same partition key. Ex: CREATE TABLE Employee ( deptId int, empId int, name varchar, address

Re: Thrift vs CQL3 performance

2014-07-29 Thread Vivek Mishra
Checkout differentiators between thrift n cql3. Storage engine is same but they differs in metadata. Prior to 2.0 it was mix of both. I would still suggest the same. Checkout earlier threads around map collection support, bulk loading, dynamic column support comparison b/w thrift and cql3. Ease of

Re: Caffinitas Mapper - Java object mapper for Apache Cassandra

2014-07-25 Thread Vivek Mishra
How is it different than kundera? On 20/07/2014 9:03 pm, Robert Stupp sn...@snazy.de wrote: Hi all, I've just released the first beta version of Caffinitas Mapper. Caffinitas Mapper is an advanced Java object mapper for Apache Cassandra NoSQL database. It offers an annotation based

Re: How to prevent writing to a Keyspace?

2014-07-21 Thread Vivek Mishra
keyspace in Cassandra ? e.g. set some specific strategy? Boying *From:* Vivek Mishra [mailto:mishra.v...@gmail.com] *Sent:* 2014年7月17日 18:35 *To:* user@cassandra.apache.org *Subject:* Re: How to prevent writing to a Keyspace? Think about managing it via authorization and authentication

Re: How to prevent writing to a Keyspace?

2014-07-17 Thread Vivek Mishra
Think about managing it via authorization and authentication support On Thu, Jul 17, 2014 at 4:00 PM, Lu, Boying boying...@emc.com wrote: Hi, All, I need to make a Cassandra keyspace to be read-only. Does anyone know how to do that? Thanks Boying

Fwd: Fw: Webinar - NoSQL Landscape and a Solution to Polyglot Persistence

2014-05-11 Thread Vivek Mishra
Check out this webinar for 1) Nosql Landscape 2) Building Kundera powered app 3) Polyglot persistence! -Vivek -Vivek On Thursday, May 8, 2014 5:52 PM, Vivek Mishra vivek.mis...@impetus.co.in wrote: *From:* Pankaj Bagzai *Sent:* Wednesday, April 30, 2014 8:50 PM *To:* df-all; Account

Fwd: {kundera-discuss} Kundera-2.11.1-Patch Released

2014-05-01 Thread Vivek Mishra
-- Forwarded message -- From: Chhavi Gangwal chhavigang...@gmail.com Date: Thu, May 1, 2014 at 1:32 PM Subject: {kundera-discuss} Kundera-2.11.1-Patch Released To: kundera-disc...@googlegroups.com Hi All, We are happy to announce the Kundera-2.11.1 patch release. Kundera is a

: Read a negative frame size (-2113929216)!

2014-04-25 Thread Vivek Mishra
This is what i am getting with Cassandra 2.0.7 with Thrift. Caused by: org.apache.thrift.transport.TTransportException: Read a negative frame size (-2113929216)! at org.apache.thrift.transport.TFramedTransport.readFrame(TFramedTransport.java:133) at

Re: : Read a negative frame size (-2113929216)!

2014-04-25 Thread Vivek Mishra
It's a simple cql3 query to create keyspace. -Vivek On Sat, Apr 26, 2014 at 1:28 AM, Chris Lohfink clohf...@blackbirdit.comwrote: Did you send an enormous write or batch write and it wrapped? Or is your client trying to use non-framed transport? Chris On Apr 25, 2014, at 2:50 PM, Vivek

Re: : Read a negative frame size (-2113929216)!

2014-04-25 Thread Vivek Mishra
datastax java driver 2.0.1 On Sat, Apr 26, 2014 at 1:35 AM, Chris Lohfink clohf...@blackbirdit.comwrote: what client are you using? On Apr 25, 2014, at 3:01 PM, Vivek Mishra mishra.v...@gmail.com wrote: It's a simple cql3 query to create keyspace. -Vivek On Sat, Apr 26, 2014 at 1:28

Re: : Read a negative frame size (-2113929216)!

2014-04-25 Thread Vivek Mishra
to this exception? On Fri, Apr 25, 2014 at 4:47 PM, Vivek Mishra mishra.v...@gmail.comwrote: datastax java driver 2.0.1 On Sat, Apr 26, 2014 at 1:35 AM, Chris Lohfink clohf...@blackbirdit.comwrote: what client are you using? On Apr 25, 2014, at 3:01 PM, Vivek Mishra mishra.v...@gmail.com

Re: : Read a negative frame size (-2113929216)!

2014-04-25 Thread Vivek Mishra
port? The two protocols are not compatible, you must connect to the native_transport_port (by default 9042) On 26 April 2014 00:47, Vivek Mishra mishra.v...@gmail.com wrote: datastax java driver 2.0.1 On Sat, Apr 26, 2014 at 1:35 AM, Chris Lohfink clohf...@blackbirdit.comwrote: what

Re: : Read a negative frame size (-2113929216)!

2014-04-25 Thread Vivek Mishra
Just to add, it works fine with Cassandra 1.x and Datastax 1.x -Vivek On Sat, Apr 26, 2014 at 10:02 AM, Vivek Mishra mishra.v...@gmail.comwrote: Yes i know. But i am not sure why is it failing, simply having Thrift jar and cassandra-thrift in classpath doesn't fails. But as soon as i get

Re: Unable to complete request: one or more nodes were unavailable.

2014-04-16 Thread Vivek Mishra
, and the output of nodetool ring -Tupshin On Apr 15, 2014 3:52 PM, Vivek Mishra mishra.v...@gmail.com wrote: Hi, I am trying Cassandra light weight transaction support with Cassandra 2.0.4 cqlsh:twitter create table user(user_id text primary key, namef text); cqlsh:twitter insert into user

Re: Unable to complete request: one or more nodes were unavailable.

2014-04-16 Thread Vivek Mishra
at 1:44 PM, Vivek Mishra mishra.v...@gmail.comwrote: Hi, Mine is a simple case. Running on single node only. Keyspace is: create keyspace twitter with replication = {'class':'SimpleStrategy', 'replication_factor' : 3} -Vivek On Wed, Apr 16, 2014 at 1:27 AM, Tupshin Harper tups

Re: Unable to complete request: one or more nodes were unavailable.

2014-04-16 Thread Vivek Mishra
/cassandra/2.0/cassandra/dml/dml_tunable_consistency_c.html#concept_ds_f4h_hwx_zjfor lightweight transactions by preventing unconditional updates. On Apr 16, 2014 5:56 AM, Vivek Mishra mishra.v...@gmail.com wrote: Thanks Mark. does this mean with RF=3, all 3 nodes must be up and running

Re: Unable to complete request: one or more nodes were unavailable.

2014-04-16 Thread Vivek Mishra
Thanks, i think got the point.CAS doesn't make much sense on single node. -Vivek On Wed, Apr 16, 2014 at 6:37 PM, Tupshin Harper tups...@tupshin.com wrote: It will work for correctness, but give you a very inaccurate view of performance,. -Tupshin On Apr 16, 2014 6:05 AM, Vivek Mishra

Unable to complete request: one or more nodes were unavailable.

2014-04-15 Thread Vivek Mishra
Hi, I am trying Cassandra light weight transaction support with Cassandra 2.0.4 cqlsh:twitter create table user(user_id text primary key, namef text); cqlsh:twitter insert into user(user_id,namef) values('v','ff') if not exists; *Unable to complete request: one or more nodes were unavailable.*

Re: Timeuuid inserted with now(), how to get the value back in Java client?

2014-04-01 Thread Vivek Mishra
You would get UUID object from cassandra API. Then you may use uuid.timestamp() to get time stamp for the same -Vivek On Tue, Apr 1, 2014 at 9:55 PM, Theo Hultberg t...@iconara.net wrote: no, there's no way. you should generate the TIMEUUID on the client side so that you have it. T# On

Re: {kundera-discuss} Kundera 2.11 released

2014-03-24 Thread Vivek Mishra
fyi. On Mon, Mar 24, 2014 at 11:56 PM, Vivek Mishra vivek.mis...@impetus.co.inwrote: Hi All, We are happy to announce the Kundera 2.11 release. Kundera is a JPA 2.0 compliant, object-datastore mapping library for NoSQL datastores. The idea behind Kundera is to make working with NoSQL

Re: Cassandra blob storage

2014-03-18 Thread Vivek Mishra
@Mohit Bit confused with your reply. For what use cases you find Cassandra useful then? -Vivek On Tue, Mar 18, 2014 at 11:41 PM, Mohit Anchlia mohitanch...@gmail.comwrote: For large volume big data scenarios we don't recommend using Cassandra as a blob storage simply because of intensive IO

Re: Cassandra Java Client

2014-02-26 Thread Vivek Mishra
Kundera does support CQL3. Work for supporting datastax java driver is under development. https://github.com/impetus-opensource/Kundera/issues/385 -Vivek On Wed, Feb 26, 2014 at 6:34 PM, DuyHai Doan doanduy...@gmail.com wrote: Short answer : yes Long anwser: depending on whether you want

Re: Exception in cassandra logs while processing the message

2014-02-17 Thread Vivek Mishra
looks like thrift inter operability issue. Seems column family or data created via CQL3 and using Thrift based API to read it. Else, recreate your schema and try. -Vivek On Mon, Feb 17, 2014 at 1:50 PM, ankit tyagi ankittyagi.mn...@gmail.comwrote: Hello, anyone has the idea regarding this

Re: TimedOutException in Java but not in cqlsh

2014-02-14 Thread Vivek Mishra
Check for consisteny level and socket timeout setting on client side. -Vivek On Fri, Feb 14, 2014 at 2:36 PM, Cyril Scetbon cyril.scet...@free.frwrote: After a few tests, it does not depend on the query. Whatever cql3 query I do, I always get the same exception. If someone sees something ...

Fwd: {kundera-discuss} Kundera 2.10 released

2014-01-31 Thread Vivek Mishra
fyi -- Forwarded message -- From: Vivek Mishra vivek.mis...@impetus.co.in Date: Sat, Feb 1, 2014 at 1:18 AM Subject: {kundera-discuss} Kundera 2.10 released To: kundera-disc...@googlegroups.com kundera-disc...@googlegroups.com Hi All, We are happy to announce the Kundera 2.10

one or more nodes were unavailable.

2014-01-20 Thread Vivek Mishra
Hi, Trying CAS feature of cassandra 2.x and somehow getting given below error: cqlsh:sample insert into User(user_id,first_name) values( fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1') if not exists; Unable to complete request: one or more nodes were unavailable. cqlsh:training cqlsh:sample

Re: one or more nodes were unavailable.

2014-01-20 Thread Vivek Mishra
PM, sankalp kohli kohlisank...@gmail.comwrote: What consistency level are you using? On Mon, Jan 20, 2014 at 7:16 AM, Vivek Mishra mishra.v...@gmail.comwrote: Hi, Trying CAS feature of cassandra 2.x and somehow getting given below error: cqlsh:sample insert into User(user_id,first_name

Re: one or more nodes were unavailable.

2014-01-20 Thread Vivek Mishra
On Tue, Jan 21, 2014 at 11:33 AM, Drew Kutcharian d...@venarc.com wrote: If you are trying this out on a single node, make sure you set the replication_factor of the keyspace to one. On Jan 20, 2014, at 7:41 PM, Vivek Mishra mishra.v...@gmail.com wrote: Single node and default consistency

Re: Help on Designing Cassandra table for my usecase

2014-01-10 Thread Vivek Mishra
@Naresh Too many indices or indices with high cardinality should be discouraged and are always performance issues. A set will not contain duplicate values. -Vivek On Fri, Jan 10, 2014 at 5:48 PM, Naresh Yadav nyadav@gmail.com wrote: @Thunder I just came to know about

Nodetool ring

2014-01-02 Thread Vivek Mishra
Hi, I am trying to understand Owns here. AFAIK, it is range(part of keyspace). Not able to understand why is it shown as 100%? Is it because of effective ownership? Address RackStatus State LoadOwnsToken -3074457345618258503 x.x.x.x 3 Up

Re: Nodetool ring

2014-01-02 Thread Vivek Mishra
Thanks for your quick reply. Even with 2 data center with 3 data nodes each i am seeing 100% on both data center nodes. -Vivek On Fri, Jan 3, 2014 at 12:07 AM, Robert Coli rc...@eventbrite.com wrote: On Thu, Jan 2, 2014 at 10:20 AM, Vivek Mishra mishra.v...@gmail.comwrote: I am trying

Re: Nodetool ring

2014-01-02 Thread Vivek Mishra
Yes. On Fri, Jan 3, 2014 at 12:57 AM, Robert Coli rc...@eventbrite.com wrote: On Thu, Jan 2, 2014 at 10:48 AM, Vivek Mishra mishra.v...@gmail.comwrote: Thanks for your quick reply. Even with 2 data center with 3 data nodes each i am seeing 100% on both data center nodes. Do you have RF

Broken pipe with Thrift

2013-12-23 Thread Vivek Mishra
Hi, I have a 6 node, 2DC cluster setup. I have configured consistency level to QUORUM. But very often i am getting Broken pipe com.impetus.client.cassandra.CassandraClientBase (CassandraClientBase.java:1926) - Error while executing native CQL query Caused by: .

Re: Broken pipe with Thrift

2013-12-23 Thread Vivek Mishra
Also to add. It works absolutely fine on single node. -Vivek On Tue, Dec 24, 2013 at 12:15 PM, Vivek Mishra mishra.v...@gmail.comwrote: Hi, I have a 6 node, 2DC cluster setup. I have configured consistency level to QUORUM. But very often i am getting Broken pipe

Re: Broken pipe with Thrift

2013-12-23 Thread Vivek Mishra
, Vivek Mishra mishra.v...@gmail.comwrote: Also to add. It works absolutely fine on single node. -Vivek On Tue, Dec 24, 2013 at 12:15 PM, Vivek Mishra mishra.v...@gmail.comwrote: Hi, I have a 6 node, 2DC cluster setup. I have configured consistency level to QUORUM. But very often i am getting

Re: Broken pipe with Thrift

2013-12-23 Thread Vivek Mishra
Hi Steven, One question, which is confusing , it's a server side issue or client side? -Vivek On Tue, Dec 24, 2013 at 12:30 PM, Vivek Mishra mishra.v...@gmail.comwrote: Hi Steven, Thanks for your reply. We are using version 1.2.9. -Vivek On Tue, Dec 24, 2013 at 12:27 PM, Steven

Fwd: {kundera-discuss} RE: Kundera 2.9 released

2013-12-13 Thread Vivek Mishra
fyi. -- Forwarded message -- From: Vivek Mishra vivek.mis...@impetus.co.in Date: Fri, Dec 13, 2013 at 8:54 PM Subject: {kundera-discuss} RE: Kundera 2.9 released To: kundera-disc...@googlegroups.com kundera-disc...@googlegroups.com, u...@hbase.apache.org u...@hbase.apache.org

Re: Exactly one wide row per node for a given CF?

2013-12-03 Thread Vivek Mishra
So Basically you want to create a cluster of multiple unique keys, but data which belongs to one unique should be colocated. correct? -Vivek On Tue, Dec 3, 2013 at 10:39 AM, onlinespending onlinespend...@gmail.comwrote: Subject says it all. I want to be able to randomly distribute a large set

Re: Wide rows (time series data) and ORM

2013-10-23 Thread Vivek Mishra
Can Kundera work with wide rows in an ORM manner? What specifically you looking for? Composite column based implementation can be built using Kundera. With Recent CQL3 developments, Kundera supports most of these. I think POJO needs to be aware of number of fields needs to be persisted(Same as

Re: Wide rows (time series data) and ORM

2013-10-23 Thread Vivek Mishra
and basically process each 'row' returned by CQL as another SensorData object? Thanks. Les On Wed, Oct 23, 2013 at 1:22 AM, Vivek Mishra mishra.v...@gmail.comwrote: Can Kundera work with wide rows in an ORM manner? What specifically you looking for? Composite column based implementation can

Fwd: {kundera-discuss} Kundera 2.8 released

2013-10-21 Thread Vivek Mishra
fyi. -- Forwarded message -- From: Vivek Mishra vivek.mis...@impetus.co.in Date: Tue, Oct 22, 2013 at 1:33 AM Subject: {kundera-discuss} Kundera 2.8 released To: kundera-disc...@googlegroups.com kundera-disc...@googlegroups.com Hi All, We are happy to announce the release

Re: COPY command times out

2013-10-11 Thread Vivek Mishra
If not getting any exception. Reason for Request did not complete within rpc_timeout. = socket time out As per http://www.datastax.com/docs/1.1/references/cql/COPY( COPY from CSV section) COPY FROM is intended for importing small datasets (a few million rows or less) into Cassandra. For

Re: Bulk Loader in cassandra : String as row keys in cassandra

2013-10-11 Thread Vivek Mishra
but i have changed my **key_validation_class=AsciiType** in order to make **string as row keys** why not key_validation_class=UTF8Type ? -Vivek On Fri, Oct 11, 2013 at 3:55 PM, ashish sanadhya sanadhyaa...@gmail.comwrote: I have done with bulk loader with key_validation_class=LexicalUUIDType

Re: Bulk Loader in cassandra : String as row keys in cassandra

2013-10-11 Thread Vivek Mishra
Also, please use ByteBufferUtils for byte conversions. On Fri, Oct 11, 2013 at 4:17 PM, Vivek Mishra mishra.v...@gmail.com wrote: but i have changed my **key_validation_class=AsciiType** in order to make **string as row keys** why not key_validation_class=UTF8Type ? -Vivek On Fri, Oct

Re: Bulk Loader in cassandra : String as row keys in cassandra

2013-10-11 Thread Vivek Mishra
, *so will it work ?? * * On Fri, Oct 11, 2013 at 4:17 PM, Vivek Mishra mishra.v...@gmail.comwrote: Also, please use ByteBufferUtils for byte conversions. On Fri, Oct 11, 2013 at 4:17 PM, Vivek Mishra mishra.v...@gmail.comwrote: but i have changed my **key_validation_class=AsciiType

Re: Bulk Loader in cassandra : String as row keys in cassandra

2013-10-11 Thread Vivek Mishra
} {column_name: Bid_Price, validation_class:AsciiType} {column_name: Ask_Price, validation_class:AsciiType} ]; how do i get from this usersWriter.newRow(String. valueOf(lineNumber)); ? thanks. On Fri, Oct 11, 2013 at 4:30 PM, Vivek Mishra mishra.v...@gmail.comwrote: I

Using cassandra-cli with Client-server encryption

2013-10-08 Thread Vivek Mishra
Hi, I am trying to use cassandra-cli with client-server encryption enabled. But somehow getting handshake failure error(given below): org.apache.thrift.transport.TTransportException: javax.net.ssl.SSLHandshakeException: Received fatal alert: handshake_failure at

Re: Segmentation fault when trying to store into cassandra...

2013-09-30 Thread Vivek Mishra
Java version issue? Using sun jdk or open jdk? -Vivek On Tue, Oct 1, 2013 at 6:16 AM, Krishna Chaitanya bnsk1990r...@gmail.comwrote: Hello, I modified a network probe which collects network packets to store them into cassandra. So there are many packets that are coming in, I

Collection type column

2013-09-27 Thread Vivek Mishra
Hi, I understand that collection type column are supported via cql3 only. Can anybody please share how actually such mutations happen? I can see that actual column value is clubbed with column name in form of a ColumnGroupMap(type Collection). But not able to identify how it works internally

AssertionError: sstableloader

2013-09-19 Thread Vivek Mishra
Hi, I am trying to use sstableloader to load some external data and getting given below error: Established connection to initial hosts Opening sstables and calculating sections to stream Streaming relevant part of /home/impadmin/source/Examples/data/Demo/Users/Demo-Users-ja-1-Data.db to [/

Re: AssertionError: sstableloader

2013-09-19 Thread Vivek Mishra
/jira/browse/CASSANDRA? Thanks, On Thu, Sep 19, 2013 at 2:12 PM, Vivek Mishra mishra.v...@gmail.com wrote: Hi, I am trying to use sstableloader to load some external data and getting given below error: Established connection to initial hosts Opening sstables and calculating sections

Re: Versioning in cassandra

2013-09-03 Thread Vivek Mishra
create secondary index over parentid. OR make it part of clustering key -Vivek On Tue, Sep 3, 2013 at 10:42 PM, dawood abdullah muhammed.daw...@gmail.comwrote: Jan, The solution you gave works spot on, but there is one more requirement I forgot to mention. Following is my table structure

Re: Versioning in cassandra

2013-09-03 Thread Vivek Mishra
and parentid. I am confused If at all this is achievable, please suggest. Dawood On Tue, Sep 3, 2013 at 10:58 PM, Vivek Mishra mishra.v...@gmail.comwrote: create secondary index over parentid. OR make it part of clustering key -Vivek On Tue, Sep 3, 2013 at 10:42 PM, dawood abdullah

Re: Versioning in cassandra

2013-09-03 Thread Vivek Mishra
, Vivek Mishra mishra.v...@gmail.com wrote: My bad. I did miss out to read latest version part. -Vivek On Tue, Sep 3, 2013 at 11:20 PM, dawood abdullah muhammed.daw...@gmail.com wrote: I have tried with both the options creating secondary index and also tried adding parentid to primary key

Fwd: {kundera-discuss} Kundera 2.7 released

2013-09-03 Thread Vivek Mishra
fyip. -- Forwarded message -- From: Vivek Mishra vivek.mis...@impetus.co.in Date: Wed, Sep 4, 2013 at 6:15 AM Subject: {kundera-discuss} Kundera 2.7 released To: kundera-disc...@googlegroups.com kundera-disc...@googlegroups.com Hi All, We are happy to announce the release

Re: CQL Thrift

2013-08-30 Thread Vivek Mishra
On Fri, Aug 30, 2013 at 11:08 PM, Vivek Mishra mishra.v...@gmail.comwrote: Hi, If i a create a table with CQL3 as create table user(user_id text PRIMARY KEY, first_name text, last_name text, emailid text); and create index as: create index on user(first_name); then inserted some data

Re: CQL Thrift

2013-08-30 Thread Vivek Mishra
with CQL. If you're going to work with Thrift, work with Thrift. Don't mix. On Aug 30, 2013, at 10:38 AM, Vivek Mishra mishra.v...@gmail.com wrote: Hi, If i a create a table with CQL3 as create table user(user_id text PRIMARY KEY, first_name text, last_name text, emailid text

Re: CQL Thrift

2013-08-30 Thread Vivek Mishra
:45 PM, Jon Haddad j...@jonhaddad.com wrote: If you're going to work with CQL, work with CQL. If you're going to work with Thrift, work with Thrift. Don't mix. On Aug 30, 2013, at 10:38 AM, Vivek Mishra mishra.v...@gmail.com wrote: Hi, If i a create a table with CQL3 as create table user

Re: CQL Thrift

2013-08-30 Thread Vivek Mishra
going to work with Thrift, work with Thrift. Don't mix. On Aug 30, 2013, at 10:38 AM, Vivek Mishra mishra.v...@gmail.com wrote: Hi, If i a create a table with CQL3 as create table user(user_id text PRIMARY KEY, first_name text, last_name text, emailid text); and create index as: create

Re: CQL Thrift

2013-08-30 Thread Vivek Mishra
with Thrift, work with Thrift. Don't mix. On Aug 30, 2013, at 10:38 AM, Vivek Mishra mishra.v...@gmail.com wrote: Hi, If i a create a table with CQL3 as create table user(user_id text PRIMARY KEY, first_name text, last_name text, emailid text); and create index as: create index on user(first_name

Re: CQL Thrift

2013-08-30 Thread Vivek Mishra
as using EVA tables in relational databases. Having used that approach in the past to build temporal databases, it doesn't scale well. On Fri, Aug 30, 2013 at 2:40 PM, Vivek Mishra mishra.v...@gmail.comwrote: create a column family as: create table dynamicTable(key text, nameAsDouble

Re: CQL Thrift

2013-08-30 Thread Vivek Mishra
@lhazlewood https://issues.apache.org/jira/browse/CASSANDRA-5959 Begin batch multiple insert statements. apply batch It doesn't work for you? -Vivek On Sat, Aug 31, 2013 at 12:21 AM, Les Hazlewood lhazlew...@apache.orgwrote: On Fri, Aug 30, 2013 at 10:58 AM, Jon Haddad

CQL Thrift

2013-08-30 Thread Vivek Mishra
Hi, If i a create a table with CQL3 as create table user(user_id text PRIMARY KEY, first_name text, last_name text, emailid text); and create index as: create index on user(first_name); then inserted some data as: insert into user(user_id,first_name,last_name,emailId) values('@mevivs','vivek

Re: CQL Thrift

2013-08-30 Thread Vivek Mishra
. On Fri, Aug 30, 2013 at 1:45 PM, Jon Haddad j...@jonhaddad.com wrote: If you're going to work with CQL, work with CQL. If you're going to work with Thrift, work with Thrift. Don't mix. On Aug 30, 2013, at 10:38 AM, Vivek Mishra mishra.v...@gmail.com wrote: Hi, If i a create a table

Re: How to perform range queries efficiently?

2013-08-28 Thread Vivek Mishra
...@lupa.inf.ufg.brwrote: I can populate again. We are modelling the data yet! Tks. 2013/8/28 Vivek Mishra mishra.v...@gmail.com Just saw that you already have data populated, so i guess modifying for composite key may not work for you. -Vivek On Tue, Aug 27, 2013 at 11:55 PM, Sávio Teles savio.te

Re: How to perform range queries efficiently?

2013-08-27 Thread Vivek Mishra
For such queries, looks like you may create a composite key as (user_id,age, salary). Too much indexing always kills(irrespective of RDBMS or NoSQL). Remember every search request on secondary indexes will be passed on each node in ring. -Vivek On Tue, Aug 27, 2013 at 11:11 PM, Sávio Teles

Re: How to perform range queries efficiently?

2013-08-27 Thread Vivek Mishra
Just saw that you already have data populated, so i guess modifying for composite key may not work for you. -Vivek On Tue, Aug 27, 2013 at 11:55 PM, Sávio Teles savio.te...@lupa.inf.ufg.brwrote: Vivek, using a composite key, how would be the query? 2013/8/27 Vivek Mishra mishra.v

Issue with CQLsh

2013-08-25 Thread Vivek Mishra
Hi, I have created a column family using Cassandra-cli as: create column family default; and then inserted some record as: set default[1]['type']='bytes'; Then i tried to alter table it via cqlsh as: alter table default alter key type text; // it works alter table default alter column1 type

Re: Issue with CQLsh

2013-08-25 Thread Vivek Mishra
cassandra 1.2.4 On Mon, Aug 26, 2013 at 2:51 AM, Nate McCall n...@thelastpickle.com wrote: What version of cassandra are you using? On Sun, Aug 25, 2013 at 8:34 AM, Vivek Mishra mishra.v...@gmail.comwrote: Hi, I have created a column family using Cassandra-cli as: create column family

Re: Issue with CQLsh

2013-08-25 Thread Vivek Mishra
...@jonhaddad.com wrote: My understanding is that if you want to use CQL, you should create your tables via CQL. Mixing thrift calls w/ CQL seems like it's just asking for problems like this. On Sun, Aug 25, 2013 at 6:53 PM, Vivek Mishra mishra.v...@gmail.comwrote: cassandra 1.2.4 On Mon, Aug 26

CQLsh assume command

2013-08-24 Thread Vivek Mishra
Hi, i am trying to get CQL3 ASSUME command, as it works with Cassandra-cli. In my example, i have create a table as : create table default(id blob PRIMARY KEY); Then after connecting with CQLsh(version 3), i did execute: assume default(id) values are text; and then tried to insert a simple

Re: InvalidRequestException(why:Not enough bytes to read value of component 0)

2013-07-18 Thread Vivek Mishra
+1 for Sylvain's answer. This normally happens, if validation class for column value(s) differs. -Vivek On Thu, Jul 18, 2013 at 12:08 PM, Sylvain Lebresne sylv...@datastax.comwrote: I don't know Hector very much really, but I highly suspect that ts.toString() is wrong, since composite

Re: Exception while writing compsite column names

2013-07-18 Thread Vivek Mishra
Looks like validation class for composite column value is different than UTF8Type? Though code suggests it is: composite.addComponent(TEXT1, StringSerializer.get()); Please validate. -Vivek On Thu, Jul 18, 2013 at 7:41 PM, anand_balara...@homedepot.com wrote: Hi I have an issue

Re: Exception while writing compsite column names

2013-07-18 Thread Vivek Mishra
not think I need to check the code. Do you suspect the column family definition? -Anand *From:* Vivek Mishra [mailto:mishra.v...@gmail.com] *Sent:* Thursday, July 18, 2013 11:29 AM *To:* user@cassandra.apache.org *Subject:* Re: Exception while writing compsite column names Looks like

Main method not found in class org.apache.cassandra.service.CassandraDaemon

2013-07-17 Thread Vivek Mishra
Error: Main method not found in class org.apache.cassandra.service.CassandraDaemon, please define the main method as: public static void main(String[] args) Hi, I am getting this error. Earlier it was working fine for me, when i

Re: Main method not found in class org.apache.cassandra.service.CassandraDaemon

2013-07-17 Thread Vivek Mishra
Any suggestions? I am kind of stuck with this, else i need to delete rpm installation to get it working. -Vivek On Wed, Jul 17, 2013 at 12:17 PM, Vivek Mishra mishra.v...@gmail.comwrote: Error: Main method not found in class org.apache.cassandra.service.CassandraDaemon, please define

Re: Main method not found in class org.apache.cassandra.service.CassandraDaemon

2013-07-17 Thread Vivek Mishra
scrubbing the install and restarting ? Cheers - Aaron Morton Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 17/07/2013, at 6:47 PM, Vivek Mishra mishra.v...@gmail.com wrote: Error: Main method not found in class

Re: Main method not found in class org.apache.cassandra.service.CassandraDaemon

2013-07-17 Thread Vivek Mishra
not even Help! -Vivek On Wed, Jul 17, 2013 at 3:49 PM, Vivek Mishra mishra.v...@gmail.com wrote: @aaron Thanks for your reply. I did have a look rpm installed files 1. /etc/alternatives/cassandra, it contains configuration files only. and .sh files are installed within /usr/bin folder

Re: Main method not found in class org.apache.cassandra.service.CassandraDaemon

2013-07-17 Thread Vivek Mishra
version? -brian On Wed, Jul 17, 2013 at 8:31 AM, Vivek Mishra mishra.v...@gmail.comwrote: Finally, i have to delete all rpm installed files to get this working, folders are: /usr/share/cassandra /etc/alternatives/cassandra /usr/bin/cassandra /usr/bin/cassandra.in.sh /usr/bin/cassandra

Error: Main method not found in class org.apache.cassandra.service.CassandraDaemon

2013-07-12 Thread Vivek Mishra
Earlier, everything was working fine but now i am getting this strange error. Initially i was working via tarball installation and did install a Cassandra rpm package. Since then, i am getting Error: Main method not found in class org.apache.cassandra.service.CassandraDaemon, please define the

Fwd: {kundera-discuss} Kundera 2.6 Released

2013-07-06 Thread Vivek Mishra
fyi -Vivek -- Forwarded message -- From: Amresh amresh.si...@impetus.co.in Date: Sun, Jul 7, 2013 at 2:51 AM Subject: {kundera-discuss} Kundera 2.6 Released To: kundera-disc...@googlegroups.com Hi All, We are happy to announce the release of Kundera 2.6. Kundera is a JPA 2.0

Partitioner type

2013-07-04 Thread Vivek Mishra
Hi, Is it possible to know, type of partitioner programmitcally at runtime? -Vivek

Re: Partitioner type

2013-07-04 Thread Vivek Mishra
, Vivek Mishra mishra.v...@gmail.com wrote: Hi, Is it possible to know, type of partitioner programmitcally at runtime? -Vivek

Kundera 2.5 released

2013-04-29 Thread Vivek Mishra
Hi All, We are happy to announce the release of Kundera 2.5. Kundera is a JPA 2.0 compliant, object-datastore mapping library for NoSQL datastores. The idea behind Kundera is to make working with NoSQL databases drop-dead simple and fun. It currently supports Cassandra, HBase, MongoDB,

Re: describe keyspace or column family query not working

2013-04-10 Thread Vivek Mishra
Ok. A column family and keyspace created via cqlsh using cql3 is visible via cassandra-cli or thrift API? -Vivek On Wed, Apr 10, 2013 at 9:23 PM, Tyler Hobbs ty...@datastax.com wrote: DESCRIBE is a cqlsh feature, not a part of the CQL language. On Wed, Apr 10, 2013 at 2:37 AM, Kuldeep

Apache Cassandra for Developers-Starter

2013-04-03 Thread Vivek Mishra
Hi, Just wanted to share that recently i worked with Packt publishing to author a quick Cassandra reference in form of a book. Here it is: http://www.packtpub.com/apache-cassandra-for-developers/book Sincerely, -Vivek

Re: cql query not giving any result.

2013-03-18 Thread Vivek Mishra
. This will end up being the name of the Row key for CQL. You may also try issue a RENAME from CQL to rename the row key, which should work. Typically something like ALTER KunderaExamples RENAME key TO rowKey. -- Sylvain On Sat, Mar 16, 2013 at 4:39 AM, Vivek Mishra mishra.v...@gmail.comwrote

Re: cql query not giving any result.

2013-03-15 Thread Vivek Mishra
Ok. So it's a case when, CQL returns rowkey value as key and there is also column present with name as key. Sounds like a bug? -Vivek On Fri, Mar 15, 2013 at 5:17 PM, Kuldeep Mishra kuld.cs.mis...@gmail.comwrote: Hi Sylvain, I created it using thrift client, here is column family

Re: cql query not giving any result.

2013-03-15 Thread Vivek Mishra
Any suggestions? -Vivek On Fri, Mar 15, 2013 at 5:20 PM, Vivek Mishra mishra.v...@gmail.com wrote: Ok. So it's a case when, CQL returns rowkey value as key and there is also column present with name as key. Sounds like a bug? -Vivek On Fri, Mar 15, 2013 at 5:17 PM, Kuldeep Mishra

Re: CQL query issue

2013-03-05 Thread Vivek Mishra
.*table_name *WHERE clause AND clause ...* *ALLOW FILTERING**LIMIT n* *ORDER BY compound_key_2 ASC | DESC* * * *is this an issue?* * * *-Vivek* On Tue, Mar 5, 2013 at 5:21 PM, Vivek Mishra mishra.v...@gmail.com wrote: Hi, I am trying to execute a cql3 query as : SELECT * FROM

Re: CQL query issue

2013-03-05 Thread Vivek Mishra
Somebody in group, please confirm if it is an issue or that needs rectified for select syntax. -Vivek On Tue, Mar 5, 2013 at 5:31 PM, Vivek Mishra mishra.v...@gmail.com wrote: Thank you i am able to solve this one. If i am trying as : SELECT * FROM CompositeUser WHERE userId='mevivs' LIMIT

Re: Querying composite keys

2013-02-10 Thread Vivek Mishra
You can query over composite columns as: 1) Partition key 2) First part of clustered key(using EQ ops). Secondary indexes over non composite columns are not possible. -Vivek On Mon, Feb 11, 2013 at 12:06 PM, Rishabh Agrawal rishabh.agra...@impetus.co.in wrote: Hello I have key and

Re: Netflix/Astynax Client for Cassandra

2013-02-06 Thread Vivek Mishra
Kundera 2.3 is also upgraded for Cassandra 1.2(except CQL binary protocol). -Vivek On Thu, Feb 7, 2013 at 11:50 AM, Gabriel Ciuloaica gciuloa...@gmail.comwrote: Astyanax is not working with Cassandra 1.2.1. Only java-driver is working very well with both Cassandra 1.2 and 1.2.1. Cheers,

Re: DataModel Question

2013-02-05 Thread Vivek Mishra
Avoid super columns. If you need Sorted, wide rows then go for Composite columns. -Vivek On Wed, Feb 6, 2013 at 7:09 AM, Kanwar Sangha kan...@mavenir.com wrote: Hi – We are designing a Cassandra based storage for the following use cases- ** ** **·**Store SMS messages

Re: Multiple Data Center Clusters on Cassandra

2013-01-30 Thread Vivek Mishra
1. I want to replicate whole data on another DC and after that both DC's nodes should have complete Data. In which topology is it possible ? I think NetworkTopology is best suited for such configuration, You may want to use nodetool to generate token accordingly. 2. If I need backup, what's the

Re: Suggestion: Move some threads to the client-dev mailing list

2013-01-30 Thread Vivek Mishra
I totally agree. -Vivek On Wed, Jan 30, 2013 at 8:51 PM, Edward Capriolo edlinuxg...@gmail.comwrote: A good portion of people and traffic on this list is questions about: 1) asytnax 2) cassandra-jdbc 3) cassandra native client 3) pyhtondra / whatever With the exception of the native

Re: CQL binary protocol

2013-01-25 Thread Vivek Mishra
, 2013 at 10:15 AM, Vivek Mishra mishra.v...@gmail.comwrote: Hi, I am looking for some sort documentation around usage for CQL binary protocol. Basically i need some documentation about usage of cassandra native transport and it's usage. -Vivek

Re: CQL binary protocol

2013-01-25 Thread Vivek Mishra
Any documentation for this? -Vivek On Fri, Jan 25, 2013 at 3:39 PM, Sylvain Lebresne sylv...@datastax.comwrote: On Fri, Jan 25, 2013 at 10:29 AM, Vivek Mishra mishra.v...@gmail.comwrote: I need to refer org.apache.cassandra.transport package for code walkthrough? Yes, that's where

  1   2   >