Questions in Analytics
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 failed with error:
```
Amazon Athena experienced an internal error while executing this query. Please try submitting the query again and if the issue reoccurs, contact AWS support for...
1
answers
0
votes
30
views
asked 6 hours agolg...
I have a RDS database that are running with t3.micro with gp2 storage, and I want to modify for magnetic, I will pay something for changing the type of the storage type? I try to do this some hours...
I have an RDS MySQL, which used my owner DB instance parameter group, where I have:
max_connections =6000
table_open_cache = 6000
thread_cache_size = 4000
require_secure_transport =...
0
answers
0
votes
42
views
asked 13 hours agolg...
ERROR: function convert_timezone("unknown", "unknown", timestamp with time zone) does not existlg...
I have a column with datatype "timestamp with time zone" in UTC. I want to convert it to EST while accounting for daylight savings time. If we call the column [col1], I have tried the query as...
0
answers
0
votes
11
views
asked 14 hours agolg...
Hi,
I have configuration:
- rds mysql 8.0.36 multi az deployment (active - standby)
- few instances of read-replica
I have configured job to scale in and scale out of my main database (to save $ after...
1
answers
0
votes
57
views
asked 18 hours agolg...
I have an int stored in my s3 file and the table has int as a type. However, randomly athena seems to be adding a .0 to the end of the int for some files and not others and returning the following...
Accepted AnswerAmazon Athena
1
answers
0
votes
27
views
asked 19 hours agolg...
Hi.. in case of using redshift multi AZ cluster, Is it possible to run a scheduled query on cluster maintanence time ?
1
answers
0
votes
16
views
asked 19 hours agolg...
I have the following scenario :
- I have an Opensearch domain A in AWS account A
- I have another Opensearch domain B in AWS account B
- I would like to take a snapshot in domain A and then restore it...
AWS Glue 4.0 support Apache Hudi 0.12.1 version. What steps can I follow to upgrade the version of Hudi to 0.14 in AWS Glue 4.0
2
answers
0
votes
32
views
asked a day agolg...
This was working before, as recently as a week or two ago but Athena now fails with "INVALID_PARAMETER_USAGE: Incorrect number of parameters: expected 207 but found 0." when the query has more than...
0
answers
0
votes
22
views
asked a day agolg...
I used mysqljump to back up the database, uploaded the sql file to S3 and used Restore from S3 to restore the database, and then failed and reported an error: "Incompatible-restore"
My database...
1
answers
0
votes
61
views
asked a day agolg...
We just migrated our on-prem application to Oracle on EC2 in production. We need to use Oracle RDS SE2 due to licensing but we need to have access to this Java class, BCryptPasswordEncoder. Can we do...
1
answers
0
votes
53
views
asked a day agolg...