How can i describe table in cassandra database?

Question

$describe = new Cassandra\SimpleStatement(<<<EOD
             describe keyspace.tablename
EOD
    );
    $session->execute($describe);

i used above code but it is not working. how can i fetch field name and it's data type from Cassandra table ?

Chris Lohfink · Accepted Answer · 2016-07-12T15:43:51.173

Refer to CQL documentation. Describe expects a table/schema/keyspace.

describe table keyspace.tablename

Its also a cqlsh command, not an actual cql command. To get this information query the system tables. try

select * from system.schema_columns;

- or for more recent versions -

select * from system_schema.columns ;

score 0 · Answer 2 · edited Jul 09 '17 at 18:36

0

Try desc table keyspace.tablename;

edited Jul 09 '17 at 18:36

xlm

answered Jul 07 '17 at 11:01

Vijay

@Vijay: Your query doesn't work with with DevCenter. Can you please share minimum requirements to run this query? – realPK Jan 14 '19 at 22:07
1

It is not really a good answer - because it explains nothing. But it works. Login (using cqlsh) and from the root you can do `desc table {keyspace}.[table}` Or, login to your keyspace: use {keyspace}, then `desc table {table}` will suffice – Danielson Oct 20 '20 at 13:01

2 Answers2