ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vasiliy Sisko (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (IGNITE-7255) SQL: Failed to execute explain via new "non-caches" API
Date Mon, 30 Jul 2018 11:20:00 GMT

     [ https://issues.apache.org/jira/browse/IGNITE-7255?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Vasiliy Sisko updated IGNITE-7255:
----------------------------------
    Description: 
I'm executing code via querySqlFieldsNoCache API:
{code:java}
 qryCursor = ignite.context().query().querySqlFieldsNoCache(qry, true);
{code}
And got exception:
{noformat}
[CacheException] class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed
to parse query: EXPLAIN select count(*) from Person
   [IgniteSQLException] Failed to parse query: EXPLAIN select count(*) from Person
   [JdbcSQLException] Table "PERSON" not found; SQL statement: EXPLAIN select count(*) from
Person [42102-195]
{noformat}
Second way to reproduce is execution of Explain in Web console when *{color:#393939}Use selected
cache as default schema name{color}* checkbox is disabled.

  was:
I'm executing code via querySqlFieldsNoCache API:
{code}
 qryCursor = ignite.context().query().querySqlFieldsNoCache(qry, true);
{code}

And got exception:
{noformat}
[CacheException] class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed
to parse query: EXPLAIN select count(*) from Person
   [IgniteSQLException] Failed to parse query: EXPLAIN select count(*) from Person
   [JdbcSQLException] Table "PERSON" not found; SQL statement: EXPLAIN select count(*) from
Person [42102-195]
{noformat}


> SQL: Failed to execute explain via new "non-caches" API
> -------------------------------------------------------
>
>                 Key: IGNITE-7255
>                 URL: https://issues.apache.org/jira/browse/IGNITE-7255
>             Project: Ignite
>          Issue Type: Bug
>            Reporter: Alexey Kuznetsov
>            Assignee: Vasiliy Sisko
>            Priority: Major
>
> I'm executing code via querySqlFieldsNoCache API:
> {code:java}
>  qryCursor = ignite.context().query().querySqlFieldsNoCache(qry, true);
> {code}
> And got exception:
> {noformat}
> [CacheException] class org.apache.ignite.internal.processors.query.IgniteSQLException:
Failed to parse query: EXPLAIN select count(*) from Person
>    [IgniteSQLException] Failed to parse query: EXPLAIN select count(*) from Person
>    [JdbcSQLException] Table "PERSON" not found; SQL statement: EXPLAIN select count(*)
from Person [42102-195]
> {noformat}
> Second way to reproduce is execution of Explain in Web console when *{color:#393939}Use
selected cache as default schema name{color}* checkbox is disabled.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message