Share via

Data catalog incompatible with Cassandra 3.x?

Rolland Cright 1 Reputation point
2021-04-22T22:46:45.657+00:00

I'm trying to register a data source, Cassandra database, but I'm getting the following error:

ERROR [HY000] [Microsoft][CassandraODBC] (10) Error while executing a query in Cassandra: [33563136] : unconfigured table schema_keyspaces

The Cassandra database is a release 3.11.1.2261 and the documentation suggests that there is a compatibility issue between azure and cassandra.
It appears to be querying system.schema_keyspaces (version 2.x) and should be querying system_schema.keyspaces (version 3).

Is there a fix/workaround?

Azure Data Catalog
Azure Data Catalog
An Azure service that serves as a system of registration and system of discovery for enterprise data assets.
98 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2021-04-23T22:42:56.28+00:00

    Hello @Rolland Cright ,
    Thanks for the ask and using the Microsoft Q&A platform .

    Looking at the document here , it appears that Cassandra is a support data source , but we need to publish it as a generic ODBC asset .

    90760-image.png

    Please do let me know how it goes .
    Thanks
    Himanshu
    Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

    0 comments
  2. Rolland Cright 21 Reputation points
    2021-05-26T13:05:02.817+00:00

    Thank you for the replies. This solved the connection to cassandra issue. However there are no tables visible in the "available objects" for the keyspace selected.

    99912-azurecassandrano-objects-available-in-keyspace-sel.png

    0 comments
  3. Rolland Cright 21 Reputation points
    2021-05-28T14:53:23.053+00:00

    I created a new thread to replace this latest issue.

    Cheers.

    0 comments