All Questions
38
questions
0
votes
1
answer
106
views
Common table expression (CTE) in Apache Cassandra
I had a SingleStore database and I decided to switch to Apache Cassandra, transferred all the tables with data, and decided to test the queries. Cassandra doesn't understand "WITH" Clause.
...
1
vote
1
answer
44
views
Cassandra table data modeling
I just started to learn about Cassandra and I have a pretty specific question.
After looking at some videos and tutorials in my understanding there is 1 primary that includes partition keys and ...
0
votes
1
answer
125
views
How do these database management systems practically behave during a network partition?
I am looking into deploying a database management system, replicated across regions (various data centers across a country). I am currently looking into the following candidates:
MongoDB (NoSQL, CP ...
0
votes
1
answer
176
views
Any place I can find the percentage of NoSQL vs SQL databases in around (-4, +2 years) 2008? If not, what are your estimates, why?
I failed to find anything on Google. This would be very useful info for the school paper I'm writing on Cassandra. Any help would be hugely appreciated.
1
vote
0
answers
73
views
Database decision and schema design
I'm trying to find a good database for my use-case, I'm not experienced in databases.
Here is my use-case: I need to acquire a lot of time series (ts) data with variable number of fields, one time ...
0
votes
1
answer
46
views
Cassandra data modeling blob
I am thinking of using cassandra for storing my data. I have a server_id, start_time, end_time, messages_blob.
CREATE TABLE messages (
server_id uuid,
start bigint,
end bigint,
...
-2
votes
2
answers
602
views
Are NOSQL database usefull for million rows [closed]
I have a table with more than 500 million rows and around 30 columns.
I need to do select by different columns.
I am just using SQL Server but the performance is not so good, can any NOSQL database ...
1
vote
1
answer
600
views
How to avoid slow query if data is too big for one partition in NoSQL?
I am learning cassandra. Now, I am thinking about SQL's problems that NoSQL addresses, and I have a question about cases of very big data.
About SQL handling very big data, I thought that many pages ...
0
votes
1
answer
54
views
How to model a Tree based database using MongoDB?
I have an application that will store data in a an entity called Department.For this department i will have SubDepartment1,SubDepartment2 and SubDepartment3
Now,i want to store massive data in ...
3
votes
1
answer
2k
views
Use cases of Event Sourcing, when we don't care about past states
I have been reading about Event Sourcing pattern, I have seen it used in the projects I have worked on, but I am still yet to see any benefit of it, while it makes the design much more complicated.
...
1
vote
1
answer
2k
views
Cassandra: Update multiple rows with different values
Hi I have similar table in Cassandra:
CREATE TABLE TestTable( id text,
group text,
date text,
user text,
dept text,
orderby int,
files list<text>...
2
votes
1
answer
472
views
Cassandra with SSTable Attached Secondary Index vs relational database
I am new to nosql database such as Cassandra, and currently I saw this secondary index and sstable attached secondary index. Some how I am confused about the purpose to use secondary index in ...
2
votes
1
answer
3k
views
Query JSON Attributes from JSON-formatted Column in Database
here is the problem I am facing
I have a table called GAMELOG (well, could be SQL Table or NoSQL column family), that looks like this :
ID INT,
REQUESTDATE DATE,
REQUESTMESSAGE VARCHAR,
RESPONSEDATE ...
1
vote
1
answer
5k
views
insert list into table: cassandra
How can i insert something like this in cassandra:
{
"custID" : '12736467',
"date" : '2013-06-10',
"orderID" : 19482065,
"amount" : 216.28,
"items" : [
{ "id" : 1
...
1
vote
1
answer
69
views
In a nosql structure using Cassandra what solution would be faster ?
In a setup with 2 nodes, using Cassandra, and given a new keyspace, which setup would be faster in performance, reading and writting, (A) a structure with all the attributes in the class or (B) ...