How to check if table exists in ScyllaDB?

237 views
Skip to first unread message

Kiswono Prayogo

<kiswono@gmail.com>
unread,
May 22, 2017, 4:51:33 AM5/22/17
to ScyllaDB users
I tried Cassandra solution, it didn't work:

SELECT columnfamily_name
FROM schema_columnfamilies WHERE keyspace_name='myKeyspaceName';

or

SELECT table_name 
FROM system_schema.tables WHERE keyspace_name='myKeyspaceName';

but it shows error:
InvalidRequest: Error from server: code=2200 [Invalid query] message="unconfigured table schema_columnfamilies"
InvalidRequest: Error from server: code=2200 [Invalid query] message="Keyspace system_schema does not exist"

i need to know if table exists before I create it using gocql.

Kiswono Prayogo

<kiswono@gmail.com>
unread,
May 22, 2017, 5:10:15 AM5/22/17
to ScyllaDB users
Nevermind, there's KeyspaceMetadata on gocql session struct.
Reply all
Reply to author
Forward
0 new messages