I want to get Failure parsing the query detail information

Dremio University
1

As we known, when user exec syntax SQL ，dremio can prompt to Failure parsing the query , but I want to get syntax detail information.

like:

image
image1170×161 22.6 KB

where I can get get syntax detail information?

2

@guozhihua Based on the SQL the error message should say that. Send us the profile and we can help

Thanks
Bali

3

We’d also like this information It’s not provided in the job object. Is there another API to fetch it?

image
image738×584 48.5 KB

1 Like
4

@lukekim Is your request to print what was the exact syntax error?

5

@balaji.ramaswamy all levels, ideally.

  • First just print the exact syntax error.
  • Second get the Calcite exception.
  • Third provide input to a Monaco editor so we can do syntax highlighting.
6

@balaji.ramaswamy following up. Is any deeper level of parsing error detail available than what the jobs API produces today?

7

@lukekim Not today, this is useful feedback, let me forward to product management

Thanks a lot

8

@balaji.ramaswamy this would be our top feature request. To basically get the “PARSE_ERROR” by API.