Questions in Database
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 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
64
views
asked 16 days agolg...
Hello Team
I want to upgrade my MySQL database from version 5.7 major to version 8.0 RDS.
I made a two-way attempt.
1. In place upgrade: Modify Cluster not worked
2. Created new Database form Snap...
1
answers
0
votes
96
views
asked 16 days agolg...
Hi everyone,
I continue to have problems with zero-ETL, which ends on its own in three days.
even though both sides of those services are currently active. Can someone please assist us with a...
2
answers
0
votes
75
views
asked 16 days agolg...
how to determine the size of a dynamo DB attribute or to know the record that is the largest in the table. Are there any JS AWS SDK libraries that are helpful for these...
Accepted AnswerAmazon DynamoDB
1
answers
0
votes
504
views
asked 16 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
207
views
asked 16 days agolg...
I have a 5.7.mysql_aurora.2.12.2 cluster and both cluster and instance are using default parameter group `default.aurora-mysql5.7`. After created and selected AuroraDB for MySQL8.0 compatible cluster...
1
answers
0
votes
458
views
asked 17 days agolg...
Trying to connect to redshift database in python shell jobs. Tried with packages like psycopg2, redshift connector and pg. All of them gave similar error, hence I'm assuming problem is to establish...
1
answers
0
votes
156
views
asked 17 days agolg...
Hi all,
Following this tutorial https://docs.aws.amazon.com/opensearch-service/latest/developerguide/configure-client-ddb.html.
I have shared opensearch pipeline configuration for sinking all dynamoDB...
0
answers
0
votes
532
views
asked 17 days agolg...
If I have a cluster with two instances, one called 'reader' and the other 'primary.' If the reader experiences a 99% spike, the primary should step in to share the load?
3
answers
0
votes
60
views
asked 17 days agolg...
Background:
I have a cluster of "Aurora MySQL", with "Credentials management" set to "Managed in AWS Secrets Manager".
My service is a spring boot service, that takes the DB password via ENV vars on...
1
answers
0
votes
632
views
asked 17 days agolg...
We have a snapshot of RDS version 8.0.33 and we want to migrate to any potential version of Aurora MySQL.
The problem is that on the migration screen there are Aurora MySQL 3.05.2 and 3.06.00 which...
2
answers
0
votes
344
views
asked 17 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
104
views
asked 17 days agolg...