qryexe throws the error "Failed to find SQL table for type: String"
- 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
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