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?
Please sign in to leave a 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
Cmeles,
Could you email me vasily.chernov@jetbrains.com full IDE & SQL logs for further investigation?
I do have the same issue with 2019.3 IntelliJ. Not sure if this was working properly with older version.
Yurii Pitomets,
Could you email me vasily.chernov@jetbrains.com full IDE & SQL logs for further investigation?
Thanks, Vasily, just sent.
This is not working for me either. And this feature was working fine in the older version and is not yet fixed in the latest version update that I took. Is there any ETA on this fix?
Version
DataGrip 2021.3.3
Build #DB-213.6461.82, built on December 29, 2021
Runtime version: 11.0.13+7-b1751.21 x86_64
VM: OpenJDK 64-Bit Server VM by JetBrains s.r.o.
macOS 11.6.2
Hello Pawandeep Thind,
What exact Cassandra version do you have?
I have the same issue as well when connecting to Datastax Enterprise 6.8 installation on the latest install of DataGrip
Daniel Arrick,
Could you file an issue in DataGrip bug tracker and attach IDE, SQL and logs produced by Prepare Introspector Diagnostics action?