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.
Is there any way to configure AWS Athena to add proper file extension?
Say `CTAS` query creates Parquet files but with no extension at all.
Accepted AnswerAmazon Athena
1
answers
0
votes
64
views
asked 20 days agolg...
Hi,
I am querying an external partitioned table in redshift spectrum and it throws an error. The data is stored in S3, parquet files and one of the column is 'BINARY'. If i remove the partition column...
0
answers
0
votes
70
views
asked 21 days agolg...
Hello,
I have parquets files in S3 that i parse using Glue Crawler and query in Athena. I found that some files have two columns "x" and "y" that have a type **int64** while other files have them as...
1
answers
0
votes
217
views
asked 21 days agolg...
I've imported a dataset of JSON objects that all have consistent schema. Glue crawler finished successfully and created a table. I can select * with a limit in Athena, but when I select all rows I get...
1
answers
1
votes
251
views
asked 21 days agolg...
I'm trying to update iceberg table with Athena Client in AWS lambda but getting COMMIT error.
My query runs about 100 queries at a time, and the time interval for generating a query is within 1 to 2...
1
answers
0
votes
148
views
asked 21 days agolg...
I've been getting a slew of INSUFFICIENT errors from CloudFront in the last week.
I'm attempting to use Athena to discover what is happening with these 5xx Error Rates. I have a database already...
3
answers
0
votes
109
views
asked 22 days agolg...
Hi
I'm stuck creating an athena connection in dataiku. In dataiku I use existing connection of s3 configured with role, this s3 connection is working. I've added required athena iam permissions...
1
answers
0
votes
223
views
asked 22 days agolg...
Hi!
I am trying to use DataZone to share an Iceberg table from the Glue Data Catalog with another AWS account.
I have created the table with Athena in the source account like this:
```sql
CREATE...
0
answers
0
votes
82
views
asked 22 days agolg...
I hope this message finds you well. I'm reaching out because I require assistance with enabling embedding and anonymous access for the Amazon Grafana dashboard. My goal is to integrate the live Amazon...
1
answers
0
votes
182
views
asked 25 days agolg...
SELECT *
FROM tvseso_h
WHERE DATE(tvseso_h.call_creation_date) BETWEEN ? AND ?;
the call_creation_date datatype in source table is in TIMESTAMP and when i created the view as tvseso_h for the same...
1
answers
0
votes
95
views
asked a month agolg...
Hello, so I have my script that runs an Athena query and sends an email,
When I was testing in my machine in the terminal, running 'python3 name-file.py'. The script works fine, the query is run and...
0
answers
0
votes
129
views
asked a month agolg...
Hi I have created an external table on AWS Glue catalog db .
The table points to a lz4 compressed file on an s3.
the table definition looks like this
```
CREATE EXTERNAL TABLE `myapplogs`(
...
1
answers
0
votes
284
views
asked a month agolg...