# \#cql **URL:** https://forum.scylladb.com/tag/cql/43.md [Latest](https://forum.scylladb.com/latest.md) · [Categories](https://forum.scylladb.com/categories.md) · [Tags](https://forum.scylladb.com/tags.md) --- ## [Error parsing query or unsupported statement?](https://forum.scylladb.com/t/error-parsing-query-or-unsupported-statement/5299)
**Author:** [@Douglas\_A\_Domingues](https://forum.scylladb.com/u/Douglas_A_Domingues)\ **Replies:** 3\ **Last updated:** [March 20, 2026, 11:31am UTC](https://forum.scylladb.com/t/error-parsing-query-or-unsupported-statement/5299 "2026-03-20T11:31:56Z")
Hi everyone, i’m in the community. I’ve been starting to use scylladb lately and i just noticed that i cant use “brackets” in where clause, at least not to encapsulate blocks, this prevents me from using ‘or’ properly, a… --- ## [How can I change a table's name in CQL?](https://forum.scylladb.com/t/how-can-i-change-a-tables-name-in-cql/4886)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [June 8, 2025, 3:30am UTC](https://forum.scylladb.com/t/how-can-i-change-a-tables-name-in-cql/4886 "2025-06-08T03:30:38Z")
--- ## [Select element from collection map/set like map\[key\]](https://forum.scylladb.com/t/select-element-from-collection-map-set-like-map-key/4206)
**Author:** [@rohit\_ranjan](https://forum.scylladb.com/u/rohit_ranjan)\ **Replies:** 1\ **Last updated:** [May 7, 2025, 1:21pm UTC](https://forum.scylladb.com/t/select-element-from-collection-map-set-like-map-key/4206 "2025-05-07T13:21:10Z")
I want to select specific keys from a map/set in scylla, it seems this has been an open issue since a long time. Is this functionality available in the latest version, if not when can we expect this? Query : select map\[… --- ## [How to perform schema changes in ScyllaDB?](https://forum.scylladb.com/t/how-to-perform-schema-changes-in-scylladb/4531)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [February 23, 2025, 6:27am UTC](https://forum.scylladb.com/t/how-to-perform-schema-changes-in-scylladb/4531 "2025-02-23T06:27:36Z")
--- ## [How to create a local snapshot of the data](https://forum.scylladb.com/t/how-to-create-a-local-snapshot-of-the-data/4435)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [February 1, 2025, 5:52pm UTC](https://forum.scylladb.com/t/how-to-create-a-local-snapshot-of-the-data/4435 "2025-02-01T17:52:01Z")
--- ## [IN clause, composite partition key and range quereis](https://forum.scylladb.com/t/in-clause-composite-partition-key-and-range-quereis/4356)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [January 9, 2025, 5:50am UTC](https://forum.scylladb.com/t/in-clause-composite-partition-key-and-range-quereis/4356 "2025-01-09T05:50:02Z")
--- ## [Is it possible to retrieve a value after an update without using Lightweight Transactions?](https://forum.scylladb.com/t/is-it-possible-to-retrieve-a-value-after-an-update-without-using-lightweight-transactions/4348)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [January 8, 2025, 4:53am UTC](https://forum.scylladb.com/t/is-it-possible-to-retrieve-a-value-after-an-update-without-using-lightweight-transactions/4348 "2025-01-08T04:53:04Z")
--- ## [Query timeouts - Using Timeout and read\_request\_timeout\_in\_ms behavior](https://forum.scylladb.com/t/query-timeouts-using-timeout-and-read-request-timeout-in-ms-behavior/4295)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [December 29, 2024, 4:26am UTC](https://forum.scylladb.com/t/query-timeouts-using-timeout-and-read-request-timeout-in-ms-behavior/4295 "2024-12-29T04:26:10Z")
--- ## [Enabling Tablets for keyspace after version upgrade, SSTable size limit when importing](https://forum.scylladb.com/t/enabling-tablets-for-keyspace-after-version-upgrade-sstable-size-limit-when-importing/4209)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [December 18, 2024, 9:13am UTC](https://forum.scylladb.com/t/enabling-tablets-for-keyspace-after-version-upgrade-sstable-size-limit-when-importing/4209 "2024-12-18T09:13:18Z")
--- ## [Is there a way to perform arithmetic operations in query](https://forum.scylladb.com/t/is-there-a-way-to-perform-arithmetic-operations-in-query/3229)
**Author:** [@Bloodpriest](https://forum.scylladb.com/u/Bloodpriest)\ **Replies:** 3\ **Last updated:** [December 12, 2024, 6:48am UTC](https://forum.scylladb.com/t/is-there-a-way-to-perform-arithmetic-operations-in-query/3229 "2024-12-12T06:48:29Z")
I need to perform queries which check fields based on some arithmetic ops. For example- select a, b from table\_name where a + b == 10 Is there a way for this to be done? --- ## [Per partition local ordering](https://forum.scylladb.com/t/per-partition-local-ordering/3412)
**Author:** [@Artem\_Golovko](https://forum.scylladb.com/u/Artem_Golovko)\ **Replies:** 5\ **Last updated:** [December 10, 2024, 3:06pm UTC](https://forum.scylladb.com/t/per-partition-local-ordering/3412 "2024-12-10T15:06:34Z")
Installation details ScyllaDB version: 6.2.1 Data model: CREATE TABLE data( p TEXT, c TIMESTAMP, v BLOB, PRIMARY KEY(p, c) ) Queries: Give me the first and the last value for each partition. SELECT \* FROM … --- ## [Regarding the create table query](https://forum.scylladb.com/t/regarding-the-create-table-query/3025)
**Author:** [@Neeraj\_Chatterjee](https://forum.scylladb.com/u/Neeraj_Chatterjee)\ **Replies:** 2\ **Last updated:** [October 23, 2024, 7:02pm UTC](https://forum.scylladb.com/t/regarding-the-create-table-query/3025 "2024-10-23T19:02:21Z")
When I tried creating a table, I wasn’t able to keep certain variable names like token, from etc… I am adding the CQL for create table. Could you please look into it and suggest some alternatives that we can use if we wa… --- ## [How to find all of the database's partitions efficiently, full table scan](https://forum.scylladb.com/t/how-to-find-all-of-the-databases-partitions-efficiently-full-table-scan/2834)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [September 1, 2024, 5:34am UTC](https://forum.scylladb.com/t/how-to-find-all-of-the-databases-partitions-efficiently-full-table-scan/2834 "2024-09-01T05:34:36Z")
--- ## [Data Modeling question, choosing the Partition Key, Clustering Key, Indexing and performance impact](https://forum.scylladb.com/t/data-modeling-question-choosing-the-partition-key-clustering-key-indexing-and-performance-impact/2060)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [May 22, 2024, 5:06am UTC](https://forum.scylladb.com/t/data-modeling-question-choosing-the-partition-key-clustering-key-indexing-and-performance-impact/2060 "2024-05-22T05:06:13Z")
--- ## [Change CL at CQLSH login time](https://forum.scylladb.com/t/change-cl-at-cqlsh-login-time/1819)
**Author:** [@sdnaffi](https://forum.scylladb.com/u/sdnaffi)\ **Replies:** 4\ **Last updated:** [May 8, 2024, 3:57pm UTC](https://forum.scylladb.com/t/change-cl-at-cqlsh-login-time/1819 "2024-05-08T15:57:59Z")
How can I change CL when login to CQLSH, getting following error message="Operation timed out for system\_auth.roles - received only xx responses from xx CL=QUORUM." . I want to change CL=ONE at login time. --- ## [Does a CQL query become token-aware depending on its size?](https://forum.scylladb.com/t/does-a-cql-query-become-token-aware-depending-on-its-size/1483)
**Author:** [@Anna](https://forum.scylladb.com/u/Anna)\ **Replies:** 1\ **Last updated:** [April 15, 2024, 8:48am UTC](https://forum.scylladb.com/t/does-a-cql-query-become-token-aware-depending-on-its-size/1483 "2024-04-15T08:48:28Z")
Please provide some background information on how it works. --- ## [Using IN in CQL Queries, Performance](https://forum.scylladb.com/t/using-in-in-cql-queries-performance/893)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [October 5, 2023, 10:46am UTC](https://forum.scylladb.com/t/using-in-in-cql-queries-performance/893 "2023-10-05T10:46:05Z")
--- ## [How do I list all the keyspaces in a cluster?](https://forum.scylladb.com/t/how-do-i-list-all-the-keyspaces-in-a-cluster/325)
**Author:** [@Michael.Hollander](https://forum.scylladb.com/u/Michael.Hollander)\ **Replies:** 1\ **Last updated:** [February 15, 2023, 5:41am UTC](https://forum.scylladb.com/t/how-do-i-list-all-the-keyspaces-in-a-cluster/325 "2023-02-15T05:41:41Z")
I previously created a keyspace and some tables in a cluster, but forgot what the keyspace name is. How can I see a list of all existing keyspaces in my cluster?