apache / apache/ignite

qryexe throws the error "Failed to find SQL table for type: String"

Open
#11,667 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
5.1k
Forks
1.9k
Avg merge
3d 2h
Merged PRs (30d)
46

Description

Hello.

I'm using Apache Ignite's REST API. While the qryfldexe command successfully executes SQL SELECT statements, the qryexe command does not perform as expected.

The POST body is:
`cmd=qryexe&keepBinary=true&type=String&pageSize=10&cacheName=MyCacheTable&arg1=1&qry=id%3D%3F`

It causes this error:
`Failed to find SQL table for type: String`

The saved data is like this:
```
{
"successStatus": 0,
"response": {
"items": [
[
1,
"XXXXXXXXXXXXXXXX",
1
]
],
"last": true,
"queryId": 209,
"fieldsMetadata": [
{
"schemaName": "PUBLIC",
"typeName": "MyCacheTable",
"fieldName": "ID",
"fieldTypeName": "java.lang.Integer"
},
{
"schemaName": "PUBLIC",
"typeName": "MyCacheTable",
"fieldName": "NAME",
"fieldTypeName": "java.lang.String"
},
{
"schemaName": "PUBLIC",
"typeName": "MyCacheTable",
"fieldName": "SCHEMA",
"fieldTypeName": "java.lang.Integer"
}
]
},
"sessionToken": null,
"securitySubjectId": null,
"error": null
}
```

I can't find any information in the documentation about how to address this issue.

It's an error? How can I make a qryexe request in the table MyCacheTable?

Thank you.

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the POST request for qryexe against MyCacheTable and compare its behavior with the working qryfldexe command. Review the qryexe and qryfldexe REST entry points and determine whether the request can query MyCacheTable without the reported "Failed to find SQL table for type: String" error.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
api, database
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.