I am using cassandra db with billions of records, and I want to store data grouped by date. The problem is that I should query records with different timezones for users, but it stores data by GMT in partition keys. Is it correct to save different date fields for all timezones and create plenty of views? This would expand db to enormous size.
Cassandra partition problems
107 Views Asked by Rostyslav At
1
There are 1 best solutions below
Related Questions in CASSANDRA
- How to perform ordering in cassandra
- Kong: Running Mashape Kong fails on Mac OS X
- Cassandra spark connector data loss
- How to insert a custom type with map<text, boolean> field using cqlsh in Cassandra?
- How to setup cassandra and spark
- Error running spark app using spark-cassandra connector
- Where are the API docs for org.apache.spark.sql.cassandra for Spark 1.3.x?
- java.sql.SQLSyntaxErrorException: name provided was not in the list of valid column labels:
- Cassandra query on 2 dates
- Cassandra WordCount Hadoop
- Cassandra: range select with incorrect result
- How to export data from Cassandra to mongodb?
- Spark Cassandra SQL can't perform DataFrame methods on query results
- Why is my cassandra insert rate better with a client/node in the same host than with client and one node in separate hosts?
- Does Cassandra support aggregation function or any other capabilities like Map Reduce?
Related Questions in TIMEZONE
- Python datetime.now() with timezone
- How to set timezone to the local in Rails?
- keep timezone "CET" from convert into "CEST" in python
- Golang time zone parsing not returning the correct zone on ubuntu server
- How to check server timezone
- How can I get the ctime and/or mtime of a file in Python including timezone?
- DateTimeOffset parse and custom time zone
- How to use Standard Time Only in TimezoneInfo.ConvertTime C#
- Are TimeZoneInfo.Id indexes are always the same?
- Older dates are parsed as summer time, even if that is not true in Java
- Can't set timezone using abbreviation
- Converting an ISO 8601 string to Current TimeZone DateTime Object in Javascript
- Ruby: Time.parse() Incorrectly Returning Alaskan Timezone
- Pandas date time formatting with timezone shifting
- What is a good practice when we need to work with datetime
Related Questions in BIGDATA
- How to add a new event to Apache Spark Event Log
- DB candidate as CouchDB/Schema replacement
- Getting java.lang.IllegalArgumentException: requirement failed while calling Sparks MLLIB StreamingKMeans from java application
- More than expected jobs running in apache spark
- Does Cassandra support aggregation function or any other capabilities like Map Reduce?
- Accessing a large number of unsorted array elements in Python
- What are the approaches to the Big-Data problems?
- Talend Open Studio for Big Data
- How to store and retrieve time series using google appengine using python
- Connecting Spark code from web application
- Designing an API on top of BigQuery
- Apache Spark architecture
- Hive(Bigdata)- difference between bucketing and indexing
- When does an action not run on the driver in Apache Spark?
- Use of core-site.xml in mapreduce program
Related Questions in PARTITION
- cut vector according to NaN values
- Hive external table not showing partitions
- Calculate number of groups and group size with multiple criteria
- Add PARTITION after creating TABLE in hive
- Create an external table in HIVE with multiple sources
- How to sample/partition panel data by individuals( preferably with caret library)?
- r: how to partition a list or vector into pairs at an offset of 1
- Detect bitlocker partition state using delphi
- Recursion in Java - Partition theory
- Why Google BigQuery doesn't use partition date correctly when using views
- When does HIVE (not) use WHERE clause on partition as predicate filter
- How to store bool result of a CUDA kernel function
- Set the right partitions for Crate Database
- Get column of table for results having sum(a_int)=0 and order by date and group by another column
- How can I parallel execute sql for MySQL partition table each partition
Related Questions in WIDE-COLUMN-STORE
- Cassandra is Column oriented or key value store?
- How Nosql like bigtable stores Image data?
- Why many refer to Cassandra as a Column oriented database?
- is a column family placed one next to the other on disk in HBase? another words, is HBase Column-oriented?
- Which Database engine for large dataset
- R dataset from long to wide - under a specific condition
- Is Cassandra a column oriented or columnar database
- How to access Amazon Keyspaces via shell?
- Transforming Wide for Long Database, Grouping Variables in R
- Key-Value vs Wide-Column DB
- Cassandra partition problems
- Cassandra pagination inside partition
- What exactly is a wide column store?
- On Cassandra how to enable LDAP authentication
- Is it a correct pattern to build composite primary key using wide columns stores?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
I would suggest to make modification of your application layer to perform normalization of the user's date into GMT & perform search, and then convert dates back into user's timezone after retrieval.
But be careful with using dates as partition key - this could create so-called "hot" partitions when all write traffic will hit the same partitions & won't be evenly distributed between nodes.