Unanswered 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.
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
23
views
asked 6 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
39
views
asked 6 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
87
views
asked 7 days agolg...
In our ETL process we are building out a pipeline where someones job is to take input files (ex. csv) and map the columns to existing column names. After the mapping is complete a glue workflow will...
0
answers
0
votes
74
views
asked 7 days agolg...
Since 3 days I am trying to delete the backup in dynamo db its not getting deleted and at the end of mont I ll be charged.
0
answers
0
votes
89
views
asked 9 days agolg...
When using AWS DMS, all boolean columns in the CDC are consistently marked as `true` (in parquet files that DMS outputs to S3), regardless of their actual value in the source database.
We are using...
0
answers
0
votes
78
views
asked 10 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 11 days agolg...
SELECT *
FROM tvseso_h
WHERE DATE(tvseso_h.call_creation_date) BETWEEN ? AND ?;
the call_creation_date datatype in source table is in TIMESTAMP and when i created the view as tvseso_h for the same...
0
answers
0
votes
79
views
asked 12 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 12 days agolg...
I have three different microservices. A metadata service, a 3rd party platform service, and an events service. Each have their own DynamoDB table, and each of those has an index consisting of "pk"...
0
answers
0
votes
70
views
asked 14 days agolg...
Here is the item format on dynamodb table
```
{
"Products": {
"ProductGroupA": [
{
"Description": "2",
}
],
"ProductGroupC": [
{
"Description": "2",
}
...
0
answers
0
votes
100
views
asked 14 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 14 days agolg...