Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X
I am able to connect to athena with jdbc extension. I created a service including sql query which I want to run on athena.
Whenever I try to invoke the service, I am able to see the service hit in athena history with a failed log as follows,
/////
2018-04-23 14:06:15.052+0530 [L: ERROR] [O: c.t.w.BaseService] [I: ] [U: user] [S: ] [T: https-jsse-nio-8443-exec-3] [context: com.thingworx.webservices.context.HttpExecutionContext@4e2d91c9][message: Unable to Invoke Service hitAthena on athenaNew : Execute Update failed: java.sql.SQLException: [Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. Only one sql statement is allowed. Got: SELECT * FROM (select * from "data"."table";) T LIMIT 0]
/////
sHi @supandey,
My Sql statement is "select * from "databaseName"."tableName";
Please find attached configuration screenshot for thing created with imported jdbc extension
@chaitanya are you attempting to execute that statement with quotation marks? I don't think you'll need that. BTW what kind of query handler are you using for select statement?
@chaitanya are you attempting to execute that statement with quotation marks? I don't think you'll need that. BTW what kind of query handler are you using for select statement?