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 a table with size ~30 TB, vacuum delete with ~ 70 millions rows deletion took 6 hours.
Is it normal? What can be done to decrease vacuum delete time ?
Thank you.
1
answers
0
votes
357
views
asked 8 months agolg...
In the cluster patch notes for path 178 https://docs.aws.amazon.com/redshift/latest/mgmt/cluster-versions.html:
> The DECODE function replaces a specific value with either another specific value or a...
Accepted AnswerAmazon Redshift
1
answers
0
votes
154
views
asked 8 months agolg...
Hi,
I am getting yarn does not exist error when Connecting redshift cluster from emr where both are in same vpc. Is there any connectivity missing or any step that I need to make sure ?
1
answers
1
votes
241
views
asked 8 months agolg...
Hello Everyone,
I am facing difficulties while trying to load data from an Amazon Redshift cluster into a Spark dataframe using the included redshift connector from **EMR release 6.13.0** .
My...
1
answers
0
votes
573
views
asked 8 months agolg...
I have established a Redshift connection in AWS Glue already. My project would require me to create tables and schemas dynamically on the fly using the Glue script. Supposing that I have already got...
2
answers
0
votes
344
views
asked 8 months agolg...
Hi,
We have few cross-database views (same cluster, different DBs), which, when querying from a BI tool by multiple users same time produce following error sometimes:
**ERROR:...
2
answers
0
votes
227
views
asked 8 months agolg...
Is there a system view that shows what stored procedures that are currently running?
1
answers
0
votes
216
views
asked 8 months agolg...
Hi Community,
I'm trying to extract data from the SAP data source to a Redshift table. I tried to add a created_at column to the Redshift table with the default current timestamp value, but this...
1
answers
0
votes
255
views
asked 8 months agolg...
I am trying to create a daily ETL that reads data from Redshift and sends it to my RDS. I am using two JDBC connections. I manage to get the data from Redshift but when I try to push to RDS I get the...
1
answers
0
votes
250
views
asked 8 months agolg...
Hello,
I am totally new when it comes to Redshift so I have a question about the setup. What is the best practice when setting up Redshift when we have a AWS DEV, UAT and PROD environment? Should I...
Accepted AnswerAmazon Redshift
1
answers
0
votes
250
views
asked 8 months agolg...
I have an external function in redshift that invocates a lambda function. The lambda functions hits another service that has concurrency limits, therefore I want to be able to limit the number of...
2
answers
0
votes
249
views
asked 8 months agolg...
I attempted to migrate data from a csv file from an S3 storage to a table in my Redshift cluster. I took reference from an autogenerated code which came after I built blocks using Visual mode in AWS...
1
answers
1
votes
1599
views
asked 8 months agolg...