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.
Hi,
I have a Glue which reads data from Database and database connection details like host, user name and password are stored in AWS secret manager. We have environment specific AWS secret manager...
1
answers
0
votes
55
views
asked 15 days agolg...
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
82
views
asked 15 days 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...
Accepted AnswerAmazon Relational Database Service
1
answers
0
votes
68
views
asked 16 days agolg...
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 =...
1
answers
0
votes
105
views
asked 16 days 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...
1
answers
0
votes
50
views
asked 16 days 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
108
views
asked 16 days 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
65
views
asked 16 days 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
54
views
asked 16 days 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
75
views
asked 16 days 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
73
views
asked 16 days 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
130
views
asked 16 days agolg...