Hello,
I am trying to add a new dataset through Athena. I can see the database and table but when I choose “Edit/Preview” data, I receive “[Simba]JDBC Null pointer exception.”. When I check Athena, I see only this for the executed query: “select 1”.
I can query the table just fine with Athena console. Any ideas?
Below are the images:
Hi @OnderSecen,
Welcome to the Quicksight Community!
To debug this, after selecting your database, instead of selecting the table could you please select custom SQL and just try to execute a sample query that worked in Athena - something like “”“SELECT * FROM mytable LIMIT 10"”". It might still fail but can give you a meaningful error. Based on that we can see if there is a need to attach couple of permissions to the Quicksight role that you are using.
Let me know if that helped!
Thanks,
Shravya
When I do above and use
SELECT * FROM "databaseName"."tableName" limit 10,
I see this Query in Athena and it fails :
SELECT ds.* FROM ( SELECT * FROM "databaseName"."tableName" limit 10 ) ds LIMIT 0
The issue looks like is with LIMIT 0 at the end.
Corresponding error is :
HIVE_UNSUPPORTED_FORMAT: Table StorageDescriptor is null for table...
Hi @OnderSecen
If still the issue exists, please try to raise a support ticket. So that they can help you with this.
Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf.
Thank you,
Shravya
