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.
Is there any way to use a federated query against MySQL against a table whose name requires MySQL backtick escape characters or that has a column name that require escaping?
I have a column in a...
1
answers
0
votes
500
views
asked 8 months agolg...
I have converted a json format file in parquet, I can see the parquet file and the columns, but while querying with Athena getting error.
HIVE_UNKNOWN_ERROR: Path is not absolute:...
1
answers
0
votes
280
views
asked 8 months agolg...
Subject says it all. Is there a way to NOT have 000 appended to the filename given in the UNLOAD command when PARALLEL is set to OFF? I've tried EXTENSION but this seems to append the extension given...
Accepted AnswerAmazon Redshift
2
answers
0
votes
751
views
asked 8 months agolg...
Redshift - Four ra3.4xlarge vs a single ra3.16xlarge - what is the performance advantage (if any)?lg...
if i am experiencing long running queries and 100% CPU utilization once a day, would moving from four ra3.4xlarge to a single ra3.16xlarge help?
1
answers
0
votes
354
views
asked 8 months agolg...
Is it currently possible to use Zero-ETL Integrations between Aurora PostgreSQL and Redshift. These Database Instances are in 2 different AWS Account.
If this is not possible, how do I replicate the...
1
answers
0
votes
429
views
asked 8 months agolg...
Hi,
What is the easiest way of accessing data held in a Timestream table from a provisioned Redshift cluster (e.g. to run SQL queries against this table and combine this with other data stored with...
1
answers
0
votes
393
views
asked 8 months agolg...
I have a scenario in which I want to test my redshift workload there could be a possibility of a query load with 40k/hour. I created a python script that will execute the sample queries by...
1
answers
0
votes
925
views
asked 8 months agolg...
Hello.
We have tried the new Zero-ETL integration for the Redshift cluster which is preview now and it's great, except it does not support some RDS MySQL data types (unsigned numeric, JSON, etc.).
So,...
2
answers
1
votes
484
views
asked 8 months agolg...
Hi,
I'm trying to load a parquet in redshift, tried both locally or from S3. I've been trying to use the Load Data tool in Redshift query editor V2. I'm using the "Load new table" (`Create table with...
1
answers
0
votes
308
views
asked 8 months agolg...
I am using AWS Glue to migrate data from Glue Catalog to Redshift Serverless and S3 after some transformations.
Since, I am learning Glue, I am using the Redshift Serverless to save my money.
So, I...
1
answers
0
votes
386
views
asked 8 months agolg...
I was trying to perform Glue ETL transformation and store it in AWS Serverless Redshift database and S3 (both) . However, even the Console generated PySpark sheet fails. Almost none of the methods...
0
answers
0
votes
162
views
asked 8 months agolg...
I am trying to connect AWS Glue Catalog to Redshift, but, I keep getting this error
`An error occurred while calling o86.getSink. The connection attempt failed`
In the logs (a part of it)
File...
0
answers
0
votes
179
views
asked 8 months agolg...