Unanswered 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.
Running any query in Athena on a particular table "sometable" fails after ~15 seconds eg:
```
SELECT * FROM "somedatabase"."sometable" limit 10;
```
And returns this error message...
0
answers
0
votes
83
views
asked a year agolg...
I don't understand why this error. I didn't declare customer id column as string. Does not make sense;
ERROR: HIVE_BAD_DATA: Error reading field value: Cannot convert value FAILED: Execution Error...
0
answers
0
votes
120
views
asked a year agolg...
When I execute the following:
alter table <db_name>.<table_name> drop column <column_name>
The column name remains in the Glue catalog. We're using Athena v3 engine. I also used the following to...
0
answers
1
votes
195
views
asked a year agolg...
We are trying to query a hudi table stored in s3 and cataloged in glue using Athena. The table has around 400 partitions (based on date) and is of size 120 MB (5.5M records). We have used the configs:...
0
answers
0
votes
81
views
asked a year agolg...
We are interested in using the Athena CloudWatch connector to query log statements that can potentially contain personal data. For this we wonder if there is any cross-region data transfer going on...
0
answers
0
votes
97
views
asked a year agolg...
[ErrorCategory:USER_ERROR, ErrorCode:DDL_FAILED], Detail:FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
This query ran against the "license_usage" database, unless...
0
answers
0
votes
157
views
asked a year agolg...
Hey all! I want to use AWS Quicksight to show the values over time of a data set I have in S3 data lake. It looks like this:
![Data...
0
answers
0
votes
104
views
asked a year agolg...
I'm using Athena to Query load balancer logs (https://docs.aws.amazon.com/athena/latest/ug/application-load-balancer-logs.html)
In my `request_url` field I have additional parameters that I would...
0
answers
0
votes
167
views
asked a year agolg...
Following is an example query that I'm trying to execute using Athena JDBC driver. It works fine using Athena query editor.
CREATE OR REPLACE VIEW default.simple_table_transformed AS SELECT...
0
answers
0
votes
108
views
asked a year agolg...
Whenever i am trying to query data from my hudi data lake hosted in athena i am getting the following error
```
HIVE_UNKNOWN_ERROR: Cannot invoke "org.apache.hadoop.fs.Path.toString()" because...
0
answers
0
votes
83
views
asked a year agolg...
HI,
I'm working with databrew to import some excel file to be then used by Athena. For some columns if I try to add an action I get the following error
`<ACTION>has not allowed characters in...
0
answers
0
votes
83
views
asked a year agolg...
First of all, I have already asked about this problem here in re:Post and on Database Administrators Stack Exchange...
0
answers
0
votes
117
views
asked a year agolg...