0
vote
1answers
7 views
Drop keyspace hangs
Problem: drop keyspace MyKeyspace; hangs.
Environment:
This is an Ubuntu 12.04 64bit in virtualbox, running a single Cassandra instance (on a development machine).
Cassandra is 1.1.6:
myuser@myhost:~$...
0
vote
0answers
11 views
"impossible to get artifacts when data has not been loaded."
In a Java play 2.1.1 app I get the following error:
[myproject] $ update
[info] Updating {file:/C:/path/myproject/}myproject...
[info] Resolving ...
[error] impossible to get artifacts when data...
0
vote
0answers
9 views
Cassandra Enable compression during SSTable generation from huge CSV data files
I am facing some issues regarding disk space consumption while generating SSTables from CSV data files with billion+ rows and 8 columns. I am using the bulk loading techniques provided at http://www.datastax.com/dev/blog/bulk-loading...
1
vote
0answers
10 views
Another Cassandra Data Modelling Approach
I have read various sources on this subject and understand the idea of modelling around the queries needed but wondered how far this can be stretched for Cassandra.
I need to store processing...
0
vote
1answers
10 views
Is there a clear equivalent of 'show keysapces' in cqlsh 2?
I want to quickly see the keyspaces in a cluster while using cqlsh. Is there some command?
Datastax' Using CQL documentation states that cqlsh specifically does not provide show keyspaces
Is...
1
vote
2answers
26 views
Apache Cassandra gridView issues
Need some help! I Can´t get rowkey value displayed on gridview from Apache-Cassandra.
some of the code...
public class PacienteEntity
{
public int key { get; set; }
public string name { get; set;...
0
vote
0answers
8 views
Get predefined list of keys from cassandra (using hector)
I used to have the following method to fetch data from my columnFamily:
public <K, C> ColumnFamilyResult<K, C> getCfRows(String p_columnFamily, K[] p_Keys, Serializer<C> p_columnNameSerializer,...
0
vote
0answers
10 views
OpenTSDB/HBase fails while uploading large amounts of data
I am new in Big Data and HBase, in participle.
Now I am trying to use OpenTSDB to store data from sensors.
Configuration is: Cloudera vmware image with the last stable OpenTSDB installed on it.
After...
0
vote
0answers
13 views
Hector query to retrieve a set of columns from a Column Family
What query should I use to retrieve a set of columns from a Column Family?
Column Name is a composite key and I know I want to get list of Columns and I do not have any row keys. One part of the...
0
vote
0answers
12 views
Using Hector with CQL3 in java
I'm running Cassandra 1.2.0 (CQL3) and I'm using Hector 1.0.5. Here's my table definition:
CREATE TABLE group_profiles (
profile_id text,
time timeuuid,
document text,
PRMARY KEY...
3
vote
0answers
20 views
Python cql library not able to update a boolean column using query substitution
Intro
I'm using the python cql library library to access a Cassandra 1.2 database (CQL 3.0). My table contains a boolean column as follows:
CREATE TABLE test (
id text,
value...
0
vote
1answers
30 views
Cassandra schema design optimization
My problem statement is :-
I have a college , every college have some students ,
every student has some data(for eg student id , student name , class etc) related to him.
The kind of questions...
0
vote
0answers
21 views
Cassandra Read taking longer than expected
I am using cassandra 1.2 with CQL3. I have three column families in my keyspace. When I query one of the column family(phones), it takes a long time to retrive. Here is my query
**select * from...
0
vote
0answers
17 views
Log-structured file-systems vs. in-memory databases
Log-structured file-systems never really entered mainstream. However, it occurred to me that in-memory databases (e.g., Cassandra) borrow many concepts from them. It seems to me like Cassandra...
0
vote
1answers
20 views
Collection of embedded objects using Cassandra CQL
I am trying to put my domain model into Cassandra using CQL. Let's say I have USER_FAVOURITES table. Each favourites has ID as a PRIMARY KEY. I want to store the list of up to 10 records of multiple...
0
vote
0answers
30 views
how to give real time input to Storm
I am trying to execute storm ,Actualy data is emited from some port,using storm spout program i am listening, (ie)implementing SerialPortEventListenter code hereener
i am getting error
no rxtxSerial...
0
vote
1answers
18 views
How to delete a row in cassandra if a column is null
Is there a way to delete multiple rows from Cassandra CF using CQL query without using key in the filter condition?
Something like DELETE FROM [ColumnFamily] WHERE [NonKeyColumnName] = [Value]?
OR
Something...
1
vote
1answers
18 views
Cassandra cqlsh report Bad request for Using Consistency
Datastax manual say that I can change consistency level with "USING CONSISTENCY" syntax.
http://www.datastax.com/docs/1.1/references/cql/cql_data_types#specifying-consistency-level
But, Cassandra...
4
vote
1answers
41 views
Cassandra - search by primary key using an arbitrary subset of the primary key columns
Is it possible to find records in Cassandra who's primary key matches an arbitrary subset of all of the primary key fields?
Example:
Using the table described below, it is possible to find the...
0
vote
1answers
43 views
slice query using hector on cassandra composite column
need some help on filtering based on Composite column.
I am unable to get filtering on 2nd part of composite column for some reason -
create column family xxx with comparator= 'CompositeType(TimeUUIDType,...
0
vote
1answers
23 views
Cassandra SSTables generation memory consumption / available compression?
I am generating Cassandra SSTables using the bulk loading sample provided at DataStax website. http://www.datastax.com/dev/blog/bulk-loading
My question is how much disk space is ideally consumed...
0
vote
0answers
28 views
Mapper goes infinity with DataStax Cassandra 1.2.1
My cassandra scehma has only one row in a column family. When running a mapreduce, the mapper keeps on reading the same single row again and again. Thus mapper goes into infinity and reducer stucks....
These...
0
vote
1answers
20 views
Cassandra Error: Column timestamp is required
I am learning Cassandra with Java, and I've tried to run the Hotel sample in this book http://shop.oreilly.com/product/0636920010852.do (Cassandra: The Definitive Guide). But because this sample...
-1
vote
0answers
18 views
Cassandra CQL Error : Bad Request
Every time I type in anything like create table/key space/etc.
Cassandra CQL throws same error of bad request or mismatched input..
I have installed datastax setup. Is it the cassandra configuration...
1
vote
1answers
37 views
Murmur3 Hash Algorithm Used in Cassandra
I'm trying to reproduce the Murmur3 hashing in Cassandra. Does anyone know how to get at the actual hash values used in the row keys? I just need some key - hash value pairs from my data to check...
1
vote
1answers
21 views
How to create super column using Hector API?
My code:
public class InsertSuperColumn {
private static StringSerializer stringSerializer = StringSerializer.get();
public static void main(String[] args) throws Exception {
...
-2
vote
0answers
22 views
How to retrive data from cassandra?
I am working on cassandra 1.2.3 and using hector 1.1-3
When I fetch columns using SliceQuery, it returns me all the columns with the same datatype. Is there any way that QueryResult have object...
1
vote
2answers
29 views
Cassandra Commit and Recovery on a Single Node
I am a newbie to Cassandra - I have been searching for information related to commits and crash recovery in Cassandra on a single node. And, hoping someone can clarify the details.
I am testing...
1
vote
0answers
22 views
Embedded Cassandra: how to apply a script?
I want to write tests against the data access layer powered by Cassandra.
So I use Embedded Cassandra with Astyanax and cassandra-unit, but I can't find the way to load a script which contains...
1
vote
1answers
23 views
PlayORM Cassandra Date Conversion Error
I have PlayORM set up through maven.
My main class is basically copied from the example here.
Every thing is set up properly and seems fine however I get some sort of date conversion error.
Stacktrace...
0
vote
1answers
36 views
Cassandra Token Aware
I have a Cassandra 1.2 cluster that is using vNodes (default of 256 per node). I'd like to predict the placement of these vNodes physically within the ring from within the client so I can more...
0
vote
1answers
37 views
Cassandra ttl on a row
I know that there are TTLs on columns in Cassandra. But is it also possible to set a TTL on a row? Setting a TTL on each column doesn't solve my problem as can be seen in the following usecase:
At...
1
vote
2answers
35 views
Load data in bulk into cassandra
Lets say I have significant amount of data in excel.
I want to load in cassandra column family?
How could I do this?
1
vote
0answers
31 views
Cassandra 1.1 or 1.2 for production usage?
We are encountering random SSTable corruptions with 1.2.3/1.2.4 (Datastax Community Edition) on single node development machines with a mixed read/write load using a data model with wide rows from...
0
vote
0answers
24 views
Getting different result each time I read from cassandra cluster
I am using hector to read from cassandra cluster of 5 machines.
The code is
String cqlString = "some query";
CqlQuery<String, String, String> cqlQuery = new CqlQuery<String, String,...
0
vote
0answers
17 views
NoAvailableHostsException while starting Titan with Cassandra
I have configured Cassandra-1.2.2 in cluster mode. But while starting Titan with my cassandra configuration, it Showing the following exception
Exception in thread "main" java.lang.IllegalArgumentException:...
4
vote
2answers
56 views
How to insert a datetime into a Cassandra 1.2 timestamp column
Intro
I'm using the python library cql to access a Cassandra 1.2 database. In the database I have a table with a timestamp column and in my Python code I have a datetime to be inserted in the column....
6
vote
1answers
47 views
Difference between UPDATE and INSERT in Cassandra?
What is the difference between UPDATE and INSERT when executing CQL against Cassandra?
It looks like there used to be no difference, but now the documentation says that INSERT does not support...
0
vote
0answers
17 views
create the html table for dynamic data from cassandra
I have a list of maps and each map contain different key:value count.
e.g. map1=(k1:v, k2:v, k3:v), map2=(k1:v, k3,v) map3=(k1:v, K4:v, k5:v). Getting this value from SOLR and from back to Cassandra....
-6
vote
0answers
22 views
Installing pip using python 3.2 and pycassa for python 3.2
I have tried installing pip to python 3.2, but I can't figure out how. Also, I I want to install pycassa to be able to have python and cassandra interact with each other, but I can't figure out...
