I am trying to read rows from dev center and client apis but if i "select *" for all 2k rows it shows no host available exception in query trace though it has all the nodes up in cluster. but if i keep partition key in where condition it doesn't show any error. Can anyone help in finding the issue? Many thanks.
Select query shows nohostavailableexception without partition key in where condition
152 Views Asked by john cena 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 CASSANDRA-2.1
- NoHostAvailableException while reading in cassandra
- Cassandra Table needs a lot of Storage space
- Select query shows nohostavailableexception without partition key in where condition
- Cassandra CQL where clause with multiple collection values?
- Cassandra 2.1: how to model for the N most recently active users?
- Cassandra query logging through spring configuration
- Cassandra data reappearing
- Cassandra hinted handoff message error
- is it possible to get data distribution using cqlsh?
- Cassandra eats memory
- Get full qualifying column name in Cassandra
- How to do full replication of data to new cassandra clustered node?
- How to recover a Cassandra node by streaming from a seed node?
- looking for examples/samples using Spark aggregate and group by in Cassandra
- Is it mandatory for all nodes of cassandra cluster to have same cluster name?
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?
You're probably hitting timeouts. Doing
select * fromwith no where clause is not a good idea as you'll potentially be hitting every node in your cluster. If this is just for testing, you can bump up your read timeouts (read_request_timeout_in_ms) in the yaml but you don't want to use a query like that in production.For further insight use the query tracing feature in Dev Center which is pretty nice in the latest releases.