Unanswered Questions tagged with 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.
I need to find the difference between two timestamp range. I tried using DATEDIFF but not getting the exact result. Below is the query I am using:
```
select
rtrim(datediff(hour,'2024-05-15...
0
answers
0
votes
44
views
asked 12 hours agolg...
I got the error when write glue dynamic data frame to redshift table .
The code I have used :-
my_conn_op={
"dbtable":"public.xxxx",
...
0
answers
0
votes
86
views
asked 3 days agolg...
I've successfully set up AWS Glue with an RDS database serving as the data source and a Snowflake database as the data target. In this setup, I've configured AWS Glue crawlers to catalog the metadata...
0
answers
0
votes
131
views
asked 3 days agolg...
IHAC running MSSQL 2016 SE in an AWS RDS instance, the customer application requires this permissions on the Master database: Create DB, create DB backup, “grant view”, any...
0
answers
0
votes
212
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
54
views
asked 9 days agolg...
Hello
I am running Document DB of engine version 5.00 in production account.
Around 4:57 a.m. (KST) on April 24 (DB cluster maintenance period)
We received a notification that the connection with the...
0
answers
0
votes
33
views
asked 14 days agolg...
I hope this is a suitable place to post this.
I believe there is a small bug in the feedback messages given by the QLDB PartiQL Query Editor.
See below for an example.
The values for latency, I/O...
0
answers
0
votes
61
views
asked 15 days agolg...
Here is the item format on dynamodb table
```
{
"Products": {
"ProductGroupA": [
{
"Description": "2",
}
],
"ProductGroupC": [
{
"Description": "2",
}
...
0
answers
0
votes
108
views
asked 18 days agolg...
Hi, I'm trying to build a quite complex query that runs on some views and if i get a couple of join it ends in this error
[HY000][100071] [Simba][AthenaJDBC](100071) An error has been thrown from the...
0
answers
0
votes
48
views
asked 18 days agolg...
Hello AWS Community,
I'm seeking advice regarding a persistent error we're facing with our Aurora PostgreSQL Serverless V2 setup running PostgreSQL 15.5. We are periodically receiving an error...
0
answers
1
votes
139
views
asked 21 days agolg...
I am checking my databases, I have 2 with Mysql Aurora and one with Mysql Community.
In one of the Aurora databases, the activity is measured in “Sessions”.
According to the definition in the...
0
answers
0
votes
223
views
asked 21 days agolg...
Some time ago I have posted...
0
answers
0
votes
115
views
asked a month agolg...