Questions tagged with Amazon Redshift
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.
On `Redshift 1.0.60353`, I'm getting the following error for a query that previously worked:
```
SQL Error [XX000]: ERROR: failed to find conversion function from "unknown" to numeric
```
According to...
1
answers
0
votes
1563
views
asked 6 months agolg...
I have a Redshift cluster currently configured with two ra3.xlplus nodes. I am going to vertical upscale the cluster from two ra3.xlplus nodes to three ra3.xlplus nodes. A planning assumption is that...
1
answers
0
votes
267
views
asked 6 months agolg...
[updated]
Resolved with this...
1
answers
0
votes
389
views
asked 6 months agolg...
when we drop some table in a store procedure, redshift throw below error. After struggling searching on the internet, don't find any. please help. The strange is it only have this issue on dev env, ...
1
answers
0
votes
338
views
asked 6 months agolg...
To connect to Redshift from our app, we would like to replace existing JDBC driver (Java) with the python sql connector if possible. For that purpose, we measured the performance to fetch a few large...
1
answers
0
votes
337
views
asked 6 months agolg...
We're seeing queries running much slower (taking 2-3x the time), and cluster load jumped up to double what it was before this release. We had no changes on or around this date as all the staff who...
1
answers
0
votes
217
views
asked 6 months agolg...
I have pause and restart the cluster, now waiting for 6 hours the cluster still on status: modify
1
answers
0
votes
244
views
asked 6 months agolg...
I have a database where I create a schema per company, all the schemas have the same tables, how can I take all this to redshift using aws dms
1
answers
0
votes
292
views
asked 7 months agolg...
I've created an external table on top of the Kinesis Data Streams and created a materialized view on top of the external table. It is running properly when I added a new column key/value JSON pair to...
1
answers
0
votes
361
views
asked 7 months agolg...
In our architecture we have data from AWS MSK being ingested into AWS Redshift using the Amazon Redshift Streaming Ingestion feature. In this approach, we define an external schema where we have the...
0
answers
0
votes
118
views
asked 7 months agolg...
We had four nodes (640GB) and discovered that all of our disk space has been consumed.
There were, however, two reserve nodes (each 160GB). So we resized the cluster using "Classic resize" to take...
1
answers
0
votes
274
views
asked 7 months agolg...
We have a redshift serverless namespace -- workgroup.
Automated recovery points are taken every 30mins. Can we reduce the frequency?
Also the same question for Auto-snapshots? Can we reduce the...
1
answers
0
votes
297
views
asked 7 months agolg...