Cassandra Python Driver

[Greg Gale <gr...@yahoo.com>]

Team,

                Scenario
                                I have a table with ~72 million records of which I am trying to query 30 days worth of data.
                                When I export the table into a csv the result is a 36GB file.

                                When I run my query this query – 

              rows = get_rows("SELECT id, position, age, team, win, prob, created FROM dataframe WHERE created >= '2020-01-01' AND created < '2020-02-01' ALLOW FILTERING");
              
              I get this error 

         ReadTimeout: Error from server: code=1200 [Coordinator node timed out waiting for replica nodes' responses] message="Operation timed out - received only 0 responses." info={'consistency': 'ONE', 'required_responses': 1, 'received_responses': 0}


                The Cassandra instance is up and running with errors and when I run that query in cqlsh, no issues.

               

Sent from Mail for Windows