search

OElesin / querypal

Web UI for Amazon Athena
Apache License 2.0
55 stars 26 forks source link

No results returned from query #5

Closed kody-actzero closed 2 years ago

kody-actzero commented 3 years ago

I have forked this project (left everything intact, just fixed some bugs in the cloudformation, etc). I have the app successfully deployed, and can see my athena tables. I can run a query, and the network call shows that it is successful (as well as the query result in S3), but the results are not showing in the UI. It returns the message: "No Data Available". Any idea what might be happening here?

OElesin commented 3 years ago

@kody-actzero , thanks for using this. Firstly, do you mind contributing the fixes so everyone can benefit from it?

This is quite strange as well. Is your glue data catalog managed by AWS Lake Formation? If so, you may need to add lake formation permissions. However, can you log into your AWS console, goto the Athena console and check query history? This way you can confirm that the queries executed were successful.

kody-actzero commented 3 years ago

Hi,

Sure, once I deploy this to a more suitable environment, I will note the specific changes needed. As a workaround, I granted more permissions than necessary, so will scope them back down when/if I deploy this to a live environment.

I checked in Athena, and the query is successful. We are not using LakeFormation, so we don't need those permissions.

It seems the issue is just displaying the results of the query in the UI. Hoping it is a simple fix.

OElesin commented 2 years ago

Unable to reproduce the issue, even with multiple deployments.

ajkulkarni commented 2 years ago

The issue is the Athena client region is set to eu-west-1 manually when the query results are fetched. This should be changed to what is in the aws config.