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.
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
138
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
144
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
77
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
177
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
169
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
140
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...
My workgroup shows a status of "Failed", and has done for a few days. I can still access the data in the Query Editor. I can successfully create a new workgroup, and the namespace associated with the...
0
answers
1
votes
252
views
asked 2 years agolg...