Querying Ignite caches in DBeaver

[begineer <re...@gmail.com>]

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/

Re: Querying Ignite caches in DBeaver

[Mikhail <mi...@gmail.com>]

Hi,

if you don't enable indexing for some cache, you can't read data from this
cache via DBeaver, you can use one of the following way to read unindexed
caches:
1) web console: 
https://apacheignite-tools.readme.io/docs/ignite-web-console ( scan query)
2)visor cmd:
https://apacheignite-tools.readme.io/docs/command-line-interface#section-commands
see cache command.
3) java API for this:
https://apacheignite.readme.io/docs/jcache#basic-operations
4) a thin client:
https://apacheignite.readme.io/docs/thin-clients

Thanks,
Mike.





--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/