Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
jfuentesa opened this issue Nov 19, 2024 · 0 comments
Open

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

jfuentesa opened this issue Nov 19, 2024 · 0 comments

Comments

@jfuentesa
Copy link

jfuentesa commented Nov 19, 2024

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant