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

[BUG] REPL Job should return meaning full error message. #83

Closed
penghuo opened this issue Oct 19, 2023 · 1 comment
Closed

[BUG] REPL Job should return meaning full error message. #83

penghuo opened this issue Oct 19, 2023 · 1 comment
Labels
0.1.1 bug Something isn't working untriaged

Comments

@penghuo
Copy link
Collaborator

penghuo commented Oct 19, 2023

What is the bug?

  • submit query with syntax error.
select * from mys3.default.http_logs limit1 1"
  • query response
{
  "status": "FAILED",
  "error": "command fail: org.opensearch.flint.app.FlintCommand@1f13eabb"
}
  • expected
Syntax error at or near '1': extra input '1'(line 1, pos 44)

== SQL ==
select * from mys3.default.http_logs limit1 1
--------------------------------------------^^^
@penghuo penghuo added bug Something isn't working untriaged 0.2 labels Oct 19, 2023
@kaituo
Copy link
Collaborator

kaituo commented Oct 20, 2023

Fixed the issue.

Result index:

{
"_index": "query_results2",
"_id": "YbDlTosBXV3LmSNnpu0b",
"_score": 6.3868794,
"_source": {
"jobRunId": "00fe4afa2ogur80q",
"applicationId": "00fd775baqpu4g0p",
"dataSourceName": "myS3Glue",
"status": "FAILED",
"error": """Syntax error:
Syntax error at or near '1': extra input '1'(line 1, pos 39)

== SQL ==
select * from default.http_logs limit1 1
---------------------------------------^^^
""",
"queryId": "100",
"queryText": "select * from default.http_logs limit1 1",
"sessionId": "10",
"updateTime": 1697835751264
}
}

Session index:
{
"_index": "query_results2",
"_id": "_L8DT4sBIPWmei_EaWXt",
"_score": 6.2766433,
"_source": {
"jobRunId": "00fe4b1tf3s1580q",
"applicationId": "00fd775baqpu4g0p",
"dataSourceName": "myS3Glue",
"status": "FAILED",
"error": """Syntax error:
Syntax error at or near '1': extra input '1'(line 1, pos 39)

== SQL ==
select * from default.http_logs limit1 1
---------------------------------------^^^
""",
"queryId": "100",
"queryText": "select * from default.http_logs limit1 1",
"sessionId": "10",
"updateTime": 1697837701785
}
}

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0.1.1 bug Something isn't working untriaged
Projects
None yet
Development

No branches or pull requests

2 participants