You can translate the question and the replies:

Denodo Throwing error from the source

Hello, I have connected JDBC connection in denodo. When i load the data and create the view automatically using lamda function in AWS. When i run the view throwing below error: **BC_YZ_RATAM_SELFSERVICE_EMEA_DE [BASE] [ERROR] ABC_YZ_RATAM_SELFSERVICE_EMEA_DE [JDBC WRAPPER] [ERROR] ABC_YZ_RATAM_SELFSERVICE_EMEA_DE#0 [JDBC ROUTE] [ERROR] Received exception with message '[Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. line 1:629: extraneous input '-' expecting {<EOF>, '.', ',', 'ADD', 'AS', 'ALL', 'SOME', 'ANY', 'WHERE', 'GROUP', 'ORDER', 'HAVING', 'LIMIT', 'AT', 'NO', 'SUBSTRING', 'POSITION', 'TINYINT', 'SMALLINT', 'INTEGER', 'DATE', 'TIME', 'TIMESTAMP', 'INTERVAL', 'YEAR', 'MONTH', 'DAY', 'HOUR', 'MINUTE', 'SECOND', 'ZONE', 'JOIN', 'CROSS', 'INNER', 'LEFT', 'RIGHT', 'FULL', 'NATURAL', 'FILTER', 'OVER', 'PARTITION', 'RANGE', 'ROWS', 'PRECEDING', 'FOLLOWING', 'CURRENT', 'ROW', 'SCHEMA', 'COMMENT', 'VIEW', 'REPLACE', 'GRANT', 'REVOKE', 'PRIVILEGES', 'PUBLIC', 'OPTION', 'EXPLAIN', 'ANALYZE', 'FORMAT', 'TYPE', 'TEXT', 'GRAPHVIZ', 'LOGICAL', 'DISTRIBUTED', 'VALIDATE', 'SHOW', 'TABLES', 'VIEWS', 'SCHEMAS', 'CATALOGS', 'COLUMNS', 'COLUMN', 'USE', 'PARTITIONS', 'FUNCTIONS', 'UNION', 'EXCEPT', 'INTERSECT', 'TO', 'SYSTEM', 'BERNOULLI', 'POISSONIZED', 'TABLESAMPLE', 'ARRAY', 'MAP', 'SET', 'RESET', 'SESSION', 'DATA', 'START', 'TRANSACTION', 'COMMIT', 'ROLLBACK', 'WORK', 'ISOLATION', 'LEVEL', 'SERIALIZABLE', 'REPEATABLE', 'COMMITTED', 'UNCOMMITTED', 'READ', 'WRITE', 'ONLY', 'CALL', 'INPUT', 'OUTPUT', 'CASCADE', 'RESTRICT', 'INCLUDING', 'EXCLUDING', 'PROPERTIES', 'FUNCTION', 'LAMBDA_INVOKE', 'RETURNS', 'SAGEMAKER_INVOKE_ENDPOINT', 'NFD', 'NFC', 'NFKD', 'NFKC', 'IF', 'NULLIF', 'COALESCE', IDENTIFIER, DIGIT_IDENTIFIER, QUOTED_IDENTIFIER, BACKQUOTED_IDENTIFIER} [Execution ID not available]'** Thanking you in Advance! Please let me know how to figure it out

2 Answers

Hi, Going through the question, I believe the error might be related to the hyphen ("-") character in your database/schema name. Further, I believe that Amazon Athena does not allow the table, view, database and column names to have special characters, other than underscore (_). However, in this scenario, I would recreate the elements (such as view, table etc ) having their name without hyphens. You can refer to the Knowledge Base article [Connecting Amazon Athena from Denodo](https://community.denodo.com/kb/view/document/How%20to%20connect%20to%20Amazon%20Athena%20from%20Denodo?category=Data+Sources) for more information. Hope this helps !
Denodo Team
16-03-2021 08:31:45 -0400
Hello, Thanks for the quick replay! The mentioned setups are in place. we have to note here is, view is created successfully from athena after pusing the lamda function excution in AWS Athena. When we try to excute the view then it is throwing an error that i mentioned at first. After the refresh the view , the view is running fine! Hope this Clear's the Assumption! Thanks You!
user
18-03-2021 03:25:22 -0400
You must sign in to add an answer. If you do not have an account, you can register here