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.
I want to query data from dynamoDB using GSI and sort key through Amplify Datastore. Is this possible?
0
answers
0
votes
152
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
162
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
88
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
188
views
asked 2 years 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
87
views
asked 2 years 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
187
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
151
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
86
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
84
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
274
views
asked 2 years agolg...
Hello,
Since the upgrade to version 3.4.7 from 3.4.6 of DMS. Some of our migration tasks are failing, only on some specific tables.
We migrate tables from AuroraMySQL, MySQL RDS and Postgres RDS...
0
answers
0
votes
227
views
asked 2 years agolg...
An architectural mismatch has often led to issue like -
When trying to connect through a dotnet application it fails with the following error message: "ERROR [01000] [unixODBC][Driver Manager]Can't...
0
answers
0
votes
198
views
asked 2 years agolg...