Re: 2d or multi dimension range query in cassandra CQL

Hi, You can download Stratio Cassandra binaries from https://s3.amazonaws.com/stratioorg/cassandra/stratio-cassandra-2.1.3.1-bin.tar.gz You can get info about how to build and getting started at its README file . More detailed in

Re: 2d or multi dimension range query in cassandra CQL

Hi, I checked Startio Cassandra but couldn't get any good documentation for the same. Can you give me some pointers on how to use it. Do I have to build it from the source or I can use it directly with jar files as in case of Stargate. Since I was looking for solution which I don't need a full bui

Re: 2d or multi dimension range query in cassandra CQL

i am using Startio Cassandra it way better than stargate as it works on the latest release of Cassandra and is better on my performance. we are using it for fulltext search use case Regards Asit On Sun, Mar 22, 2015 at 12:14 PM, Mehak Mehta wrote: > Hi, > > On the basis of some suggestions, I

Re: 2d or multi dimension range query in cassandra CQL

Hi, On the basis of some suggestions, I tried using tuplejump for multidimensional queries. Since other mostly needed root permissions (for building ) which I don't have on my cluster account. I found a major problem in tuplejump (stargate-core). When I am using it with a list type field in my ta

Re: 2d or multi dimension range query in cassandra CQL

Hi, With Stratio Cassandra you can create Lucene based indexes for multidimensional queries this way: ALTER TABLE images.results1 ADD lucene text ; CREATE CUSTOM INDEX lucene_idx ON images.results1 (lucene) USING 'com.stratio.cassandra.index.RowIndex' WITH OPTIONS = { 'refresh_seconds':'1', 's

Re: 2d or multi dimension range query in cassandra CQL

Sorry I gave you wrong table definition for query. Here a composite key of image_caseid, x and uuid which is unique. I have used x in clustering columns to query it. And used secondary index on y column. 1. Example *cqlsh:images> CREATE TABLE images.results1 (uuid uuid, analysis_execution_id varch

Re: 2d or multi dimension range query in cassandra CQL

Yeah, you may have to add a dummy column populated with a constant, or just pick some other additional column to index that you can apply = to. It's just a requirement to assure that a filtered select isn't too-too slow. Uh if you are applying = to your primary key then there is no need for an

Re: 2d or multi dimension range query in cassandra CQL

Hi, In my case I am just trying to do range queries on 2 dimensions i.e. x and y. *cqlsh:images> CREATE TABLE images.results1 (uuid uuid, analysis_execution_id varchar, analysis_execution_uuid uuid, x double, y double, submit_date timestamp, points list, PRIMARY KEY (image_caseid));* With seco

Re: 2d or multi dimension range query in cassandra CQL

Lucene or Solr is better. I’m using lucene > 在 2015年3月18日，上午2:11，Jack Krupansky 写道： > > 1. Create multiple secondary indexes, one for each non-key column you need to > index on. Not recommended. Considered an anti-pattern for Cassandra. > 2. Use DSE Search/Solr. > 3. Use Lucene-based indexing wi

Re: 2d or multi dimension range query in cassandra CQL

1. Create multiple secondary indexes, one for each non-key column you need to index on. Not recommended. Considered an anti-pattern for Cassandra. 2. Use DSE Search/Solr. 3. Use Lucene-based indexing with TumpleJump/Stargate or Stratio. -- Jack Krupansky On Tue, Mar 17, 2015 at 1:49 PM, Mehak Meh

2d or multi dimension range query in cassandra CQL

Hi, I want to perform range queries (as in x and y ranges) on a large data billions of rows. CQL allows me to put Non EQ restrictions on only one of the clustering columns. Its not allowing me to filter the data using any other column even with use of Allow Filtering option. cqlsh:images> *select