Apache Cassandra Problem when perfoming introspect.

Completed

With cassandra 3 an datagrip 2019.3 when connected to a cluster and getting the schema im getting the following error.

 

Error encountered when performing Introspect schema system: Undefined name cdc in selection clause.

 

Which in turn doesnt return any the schema.

Any ideas?

5 comments
Comment actions Permalink
Official comment

Hello Yurii,

Sorry for slow response

The problem is that we assumed that `system_schema.tables.cdc` column was added in 3.1 version but actually it was added in 3.8.
It will be fixed in next DataGrip version.

You can also fix it locally without waiting for new version:
1. Navigate to directory where DataGrip is installed
2. go to plugins/DatabaseTools/lib dir
3. copy database-impl.jar to some other dir and go to this dir
4. jar -xf database-impl.jar (this will extract jar contents)
5. modify file com/intellij/database/dialects/cassandra/introspector/CassIntroQueries.sql
    5.1. remove line `#V31: cdc, #.`
6. pack all files back to database-impl.jar and move new jar to original location

Comment actions Permalink

Cmeles,

Could you email me vasily.chernov@jetbrains.com full IDE & SQL logs for further investigation?

0
Comment actions Permalink

I do have the same issue with 2019.3 IntelliJ. Not sure if this was working properly with older version.

0
Comment actions Permalink

Yurii Pitomets,

Could you email me vasily.chernov@jetbrains.com full IDE & SQL logs for further investigation?

0
Comment actions Permalink

Thanks, Vasily, just sent.

0

Please sign in to leave a comment.