Re: Can't select count(*)

2016-02-01 Thread Stefania Alborghetti
Regarding select count(*), the timeout is probably client side. Try changing the default connect timeout in cqlsh via --request-timeout. By default it is 10 seconds. Refer to "cqlsh --help" for more details but basically "cqlsh --request-timeout=30" should work. Regarding COPY TO/FROM, these

Can't select count(*)

2016-01-31 Thread Ivan Zelensky
Hi all! I have a table with simple primary key (one field on primary key only), and ~1 million records. Table stored on single-node C* 2.2.4. Problem: when I'm trying to execute "SELECT count(*) FROM my_table;", operation is timed out. As I understand, 1 mln rows is not so big dataset to use