Source error code 100071

Question & Answer
, , ,
1

I am trying to wrie a Custom SQL Query in QuickSight for three different tables from a schema in Athena and got the above source error code. Details of my error:
sourceErrorCode:
100071

sourceErrorMessage:
[Simba]AthenaJDBC An error has been thrown from the AWS Athena client. line 3:14: mismatched input ‘-’. Expecting: ‘)’, ‘,’, ‘.’, ‘AS’, ‘CROSS’, ‘EXCEPT’, ‘FETCH’, ‘FOR’, ‘FULL’, ‘GROUP’, ‘HAVING’, ‘INNER’, ‘INTERSECT’, ‘JOIN’, ‘LEFT’, ‘LIMIT’, ‘MATCH_RECOGNIZE’, ‘NATURAL’, ‘OFFSET’, ‘ORDER’, ‘RIGHT’, ‘TABLESAMPLE’, ‘UNION’, ‘WHERE’, ‘WINDOW’, , [Execution ID not available]

sourceErrorState:
HY000

sourceException:
java.sql.SQLException

sourceType:
ATHENA

Really appreciate it if there could be insights into what went wrong with my query, it’s just a very simple query to test running custom SQL query in QuickSight. Many thanks!

2

Hi @KFNG - Welcome to AWS QuickSight community and thanks for posting the question. Can you please test the sql in Athena console before using it in QuickSight. This way you can fix any sql syntax issue.

Regards - Sanjeeb

1 Like
3

@Sanjeeb2022 Thanks, Sanjeeb. Yes, the SQL scripts worked in Athena.

4

Hi @KFNG - Thanks for the confirmation, Is it possible to share the exact sql which is throwing error.

Regards - Sanjeeb

1 Like
5

Hello @KFNG, since we have not received a response from you on this question, we are going to archive the question. If you still need this question answered, please create a new question topic.