Unanswered 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.
Hi,
I am trying to use EXTENSION parameter in Redshift UNLOAD function to save file in .csv extension in S3 bucket. However, I am getting the error: "ERROR: syntax error at or near "EXTENSION" .
As...
0
answers
0
votes
81
views
asked a year agolg...
All,
I recently updated an AVRO Schema. I have checked that the updates made to the schema are backward compatible; and they are. Next, I saved an avro file w/ the new schema to an s3 Bucket and...
0
answers
0
votes
47
views
asked a year agolg...
What is the latency/SLA of STL_INSERT, STL_DELETE and STL_QUERY? For example, how soon after an INSERT query is run is it guaranteed to show up in STL INSERT?
Can a query show up in STL_INSERT but be...
0
answers
0
votes
31
views
asked a year agolg...
I want to query data from dynamoDB using GSI and sort key through Amplify Datastore. Is this possible?
0
answers
0
votes
140
views
asked a year agolg...
I have a Redshift serverless workgroup inside a VPC, and I want to securely create a federated schema of an RDS Aurora cluster through a security group or another mechanism. The Aurora cluster is in...
0
answers
0
votes
146
views
asked a year agolg...
Hi all,
I turned on cluster relocation for one of my redshift cluster which was created in past with accessibility on port 8192. And in doing so I was successful.
The Redshift page on console also...
0
answers
0
votes
79
views
asked a year agolg...
HIVE_UNSUPPORTED_FORMAT: Output format org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat with SerDe org.openx.data.jsonserde.JsonSerDe is not supported. If a data manifest file was generated...
0
answers
0
votes
179
views
asked a year agolg...
Hello,
I am reading a specific table from a redshift database using redshift connector. when i am viewing the dataframe it does not show the column headers. It shows only numbers as the column...
0
answers
0
votes
86
views
asked a year agolg...
I tried to use redshift_connector to connect to my redshift cluster using python but I get a timeout error..
```
import redshift_connector
conn = redshift_connector.connect(
...
0
answers
0
votes
171
views
asked 2 years agolg...
We are connecting Redshift with RDS using Federated Queries. When we try to query very simple tables like Month (id (int4) / name (text)) or Practices (text,text,text) from Postgres, we have errors...
0
answers
0
votes
142
views
asked 2 years agolg...
I want to write a Python UDF that uses `scikit-learn`.
Here's the command that I'm running.
```sql
CREATE OR REPLACE LIBRARY scikit_learn LANGUAGE plpythonu FROM '...'
```
I've uploaded the a 2.7...
0
answers
0
votes
75
views
asked 2 years agolg...
Im racking my brain about how to do this and I dont think its possible but not sure what to even search for. So the below is a subset of the data (using example numbers)
I am trying to use the lag...
0
answers
0
votes
75
views
asked 2 years agolg...