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.
Athena Query Id: 48b0a8cc-13ce-4c90-8295-c69c682e7f11
When doing a SELECT statement for a table it returns an INTERNAL_ERROR_QUERY_ENGINE error when we have a lot of `AND ((attr1 = 'value' AND attr2...
0
answers
0
votes
172
views
asked 7 months agolg...
In Athena I've a column with an array(json), is there a way to calculate the length of that array for every row?
Accepted AnswerAmazon Athena
2
answers
0
votes
1204
views
asked 7 months agolg...
how to fix issue with AWS crawler that split comma listed values which is supposed to be one column. The data in the column is not enclosed by double quotes that is why we cannot create a custom...
1
answers
0
votes
399
views
asked 7 months agolg...
If I want to extract specific properties from a JSON array using SQL, for example, if the requestparameters structure is as follows:
```
{
'gree': [
{
'Grantee': {
'xsi:type':...
0
answers
0
votes
90
views
asked 7 months agolg...
I have a set of Apache Iceberg tables that are logged in Glue Catalog. I was running some basic tests on Iceberg table partitions via Athena in us-east-1 without issue. We re-deployed the exact same...
1
answers
0
votes
789
views
asked 7 months agolg...
I was trying to update the CID Dashboards to display account names as per this doc(https://catalog.workshops.aws/awscid/en-US/dashboards/foundational/cudos-cid-kpi/add-accounts) . When I run the query...
1
answers
0
votes
381
views
asked 7 months agolg...
I have ran this query for more than a year, and the query always succeed until now.
This is the Athena Query: "select * from <table_name> where organization = '<org_name>' AND start >= <epoch_time>...
1
answers
0
votes
909
views
asked 7 months agolg...
'DeleteObjects''s requestparameters is like '{"bucketName":"demo-bucket","Host":"s3.us-east-2.amazonaws.com","delete":""}' , how can i get deleted ObjectKey
3
answers
0
votes
304
views
asked 7 months agolg...
this is my sql, but 'json_extract_scalar(requestparameters, '$.x-amz-copy-source') as source' is error,
SELECT
userIdentity.username as...
Accepted AnswerAmazon Athena
4
answers
0
votes
235
views
asked 7 months agolg...
In AWS I'm generating Cost and Usage Report [CUR] from the billing console with hourly granularity into S3 bucket and from there using cloud formation stack created a database in Athena but this data...
3
answers
0
votes
1110
views
asked 7 months agolg...
I'm trying to setup PowerBI for our DynamoDB table. Using Athena with the DynamoDB Lambda connector. Smaller queries work fine, however the main import into PowerBI fails. When I play with the query...
2
answers
0
votes
276
views
asked 8 months agolg...
I have two accounts the source account A and the target account B.
I have granted account B access to the database and all its tables in account A with Super access including grant. and accepted this...
1
answers
0
votes
365
views
asked 8 months agolg...