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.
These timestamps look valid.
[{'Name': 'DeviceId', 'Value': '68b6b34eec56'}]}, {'Time': '2024-05-06 22:29:09.977', 'MeasureValue': '0', 'MeasureName': 'FlowRate', 'Dimensions': [{'Name': 'DeviceId',...
0
answers
0
votes
118
views
asked 5 days agolg...
We have Aurora Globale Cluster with Postgresql. The configurationn is as follows:
* A writer in us-east-1
* A read replica in eu-central-1
Now assume that the writer in us-east-1 crashes and I can...
1
answers
0
votes
227
views
asked 5 days agolg...
My cost in RDS Services (specifically ExtendedSupport: Yr1-Yr2: MySQL5.7) went up from $0 in february to $178.19 in March and $254.34 in April. And I have no idea why.
I have 4 Databases with MySQL5.7...
2
answers
0
votes
247
views
asked 6 days agolg...
Hello, I am relatively new to Glue and encountering some challenges with Glue ETL.
Our setup involves a datalake that retrieves data from a backend database as its source. This datalake is...
1
answers
0
votes
96
views
asked 6 days agolg...
2) MySQL 8.0 syntax check for routine-like objects
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
More Information:
https://dev.mysql.com/doc/refman/en/keywords.html
mysql.flush_rewrite_rules -...
0
answers
0
votes
38
views
asked 6 days agolg...
I'm trying to update RDS mysql version
checking the compatibility report then showing below error
2) MySQL 8.0 syntax check for routine-like...
1
answers
0
votes
255
views
asked 6 days agolg...
2) MySQL 8.0 syntax check for routine-like objects
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
More Information:
https://dev.mysql.com/doc/refman/en/keywords.html
mysql.flush_rewrite_rules -...
1
answers
0
votes
120
views
asked 6 days agolg...
I am trying to do something simple. I need to make sure at the time of registration in my app, that the Username they request is not used in my AWS backend.
To complete this, I have a small table in...
2
answers
0
votes
175
views
asked 6 days agolg...
a company's SQL developer has left and I've been asked to build a series of queries for their postgres DB on an Aurora Postgres server in the interim. I can log into the RDS interface, but the query...
Accepted AnswerAurora PostgreSQL
2
answers
0
votes
37
views
asked 7 days agolg...
I'm using an Amazon Aurora PostgreSql DB cluster and I am receiving the following error after a failover:
"PG::ReadOnlySqlTransaction: ERROR: cannot execute UPDATE in a read-only transaction"
I'm...
1
answers
1
votes
61
views
asked 7 days agolg...
Now that AWS offers MRR for Keyspaces, is a CQL Alter Table supported? From what I can tell it is not supported since I get this error:
```
InvalidRequest: Error from server: code=2200 [Invalid...
0
answers
0
votes
24
views
asked 7 days agolg...
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
43
views
asked 7 days agolg...