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.
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
40
views
asked 6 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
10
views
asked 7 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 11 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
23
views
asked 12 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
15
views
asked 12 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
31
views
asked 15 hours 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
18
views
asked 16 hours 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
60
views
asked 19 hours 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
50
views
asked a day agolg...
I am experiencing an issue with metadata filtering in Amazon Bedrock. I set up a new collection and index within Amazon OpenSearch Serverless and created a knowledge base in Amazon Bedrock. The...
1
answers
0
votes
82
views
asked a day agolg...