Hey Guys...
I am trying to use DBeaver for querying cache data in ignite cluster. I can
run simple queries like 'select * from "persons".Person' and it shows all
the records of it.
I have below queries:
1. Is there a way to list of all caches of cluster in DBeaver SQL Editor
2. Does DBeaver only allows querying data of caches where SQL Queries are
enabled? If not, then how to see data for non SQL caches ?
I get below error when cache is not enabled for SQL queries
SQL Error: Failed to query Ignite.
Failed to query Ignite.
Failed to query Ignite.
class org.apache.ignite.IgniteCheckedException: Error server response:
[req=JdbcQueryExecuteRequest [schemaName=null, pageSize=1024, maxRows=200,
sqlQry=SELECT * FROM "persons".person, args=null], resp=JdbcResponse
[res=null, status=1, err=class
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to
parse query: SELECT * FROM "persons".person]]
Error server response: [req=JdbcQueryExecuteRequest [schemaName=null,
pageSize=1024, maxRows=200, sqlQry=SELECT * FROM "persons".person,
args=null], resp=JdbcResponse [res=null, status=1, err=class
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to
parse query: SELECT * FROM "persons".person]]
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
