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.
Parameter name Information missing in system view PG_PROC_INFO.proargnames for not named parameterslg...
In PostgreSQL, when creating a procedure using the following syntax:
CREATE OR REPLACE PROCEDURE schema3.position_test(
OUT arg1 INTEGER,
INOUT BOOLEAN,
OUT arg3 BIGINT
)
LANGUAGE...
1
answers
0
votes
159
views
asked 2 months agolg...
We are encountering a issue where we're utilizing the "super" datatype. The column in the Parquet file we receive has a maximum length of 192K. How should we handle this data? Are there alternative...
2
answers
0
votes
304
views
asked 3 months agolg...
3 different tables are joined upon view creation. On dev and prod environment everything works as expected. On test environment, however, a column A of a table T gets values of a column B of a table...
2
answers
0
votes
196
views
asked 3 months agolg...
# Error while running UNLOAD to PARQUET query using column names with spaces in
## Introduction
I have a table in Athena with the following column names ["column space 1", "column space 2"]. I...
1
answers
0
votes
652
views
asked 3 months agolg...
As per the latest Redshift documentation, this is a valid parameter...
1
answers
0
votes
216
views
asked 3 months agolg...
I have created an External Table using Redshift Spectrum and using AWS Glue to crawl deeply nested json files coming into s3 bucket every second.
I was able to populate a redshift table by...
2
answers
0
votes
239
views
asked 3 months agolg...
My understanding is the Redshift cluster node has one leader node and one or more compute nodes in single-AZ cluster.
when multi-AZ is enabled, additional/same number of nodes are deployed in second...
1
answers
0
votes
157
views
asked 3 months agolg...
I already terminate the cluster I deleted since I dont use it anymore but it keeps charging in my account. Can you please help me check where is the problem? Thank you!
![Enter image description...
5
answers
0
votes
221
views
asked 3 months agolg...
I am trying to fetch 0.5 million records at once using API->lambda. I am executing this using nodejs and while fetching records programmatically using SQL query my API times out as it redshift...
1
answers
0
votes
410
views
asked 3 months agolg...
ERROR StatusLogger Unrecognized conversion specifier [n] starting at position 56 in conversion pattern.
Note: i have already created s3 endpoint in same vpc i am currently working on, also created...
1
answers
0
votes
240
views
asked 3 months agolg...
In Amazon Redshift, the general syntax for creating a procedure is as follows:
```
CREATE [ OR REPLACE ] PROCEDURE sp_procedure_name
( [ [ argname ] [ argmode ] argtype [, ...] ] )
[ NONATOMIC...
2
answers
0
votes
358
views
asked 3 months agolg...
Hi,
I'm trying to use the the pagination functionality of the Redshift Data API (using boto3):...
2
answers
0
votes
517
views
asked 3 months agolg...