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 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
80
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
182
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
175
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
143
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
78
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
76
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
259
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
221
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
185
views
asked 2 years agolg...
I created glue catalog external schema on Redshift serverless .Both Glue and redshift are in same location .
----------------------
create external schema dojo
from data catalog
database...
0
answers
0
votes
161
views
asked 2 years agolg...
Hi, I read about ANALYZE COMPRESSION and made this script to analyze and set the recommended compression for all tables, the idea is to run it at night once per month or every 15 days.
I set 3M rows...
0
answers
0
votes
39
views
asked 2 years agolg...