Questions tagged with Amazon Athena
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
i have the following script to be used in Athena query for AR product:
-- Look for drive units containing these motor assemblies.
SELECT pt_floor, du_id, subsystem, serial_num, part_num, rev_num,...
1
answers
0
votes
176
views
asked 4 months agolg...
Hi all,
I run some AWS Athena queries with the `ResultReuseByAgeConfiguration` option set. From a behaviour perspective, I would expect Athena to cache the results, but it seems Athena is caching it...
1
answers
0
votes
188
views
asked 4 months agolg...
Hi there,
We are having trouble with Athena Version 3 when some files have different types of data from the DDL table. In our case, some fields are timestamps in numeric format and some in date...
2
answers
0
votes
214
views
asked 4 months agolg...
Hi all,
I want to protect the connection between Power BI and Amazon Athena. I gave the end users IAM credentials, so they can setup their DSN in their local machines and start creating reports in...
0
answers
0
votes
85
views
asked 4 months agolg...
Is there a way to sync Athena notebooks with Git for version control? (Preferably with bitbucket, otherwise github or some other version control software to mange code.) If so, could you please send...
1
answers
0
votes
346
views
asked 4 months agolg...
When running queries on Athena v3 I get vague error messages. When the same query is run on v2, error are specific including the correct line number and what the error is. Is there a setting to...
1
answers
0
votes
221
views
asked 4 months agolg...
I used glue crawler to load s3 data into glue catalog database, but only the tables were created - the tables were empty
3
answers
0
votes
338
views
asked 4 months agolg...
I want to visualize data in DynamoDB using Quicksight. I have created a connector between Athena and DynamoDB, The data is now accessible from AThena. however, When I load this data to quicksight from...
2
answers
-1
votes
418
views
asked 4 months agolg...
I have crawled the schema of my DynamoDB table using AWS Glue crawler and the table is now shown under the tables section in AWS Glue. However, the table is not being shown under Athena database...
1
answers
0
votes
299
views
asked 4 months agolg...
Query Timing Outlg...
I have a rather complex query that is timing out more than 50% of the time in Quicksight. Is there a way that AWS can prevent the time out without changing the query? I'm adding rows through the use...
1
answers
0
votes
193
views
asked 4 months agolg...
I have a table in Athena which has multiple arrays of structs within it, i.e.
`column:bigint
column2:double
column3:array:struct<
$id:bigint
subcolumn1:string>>
column4:array:struct<
$id:bigint
...
1
answers
0
votes
224
views
asked 4 months agolg...
I have a **Databricks** pipeline set up to create **Delta tables**, using **Glue Catalog as the Metastore**. I was able to query the Delta table via Athena successfully. However, starting from...
1
answers
0
votes
186
views
asked 4 months agolg...