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.
Hey there,
I have a create table query with sortkey and distkey defined, the source data comes from s3.
The query looks like this
```sql
create table...
1
answers
0
votes
231
views
asked 6 months agolg...
I need to create a aes encryption ECB UDF in the redshift. To achieve this, i have imported pycryptodome zip file in the S3 with the name Crypto.zip and create library in the redshift.
When i try to...
1
answers
0
votes
254
views
asked 6 months agolg...
Scenario:
Source table: Glue Data Catalog table **study** crawled from MySQL with columns:
* id (int),
* code (varchar),
* desc (varchar)
* and 2 other columns not used in the job.
Target table:...
0
answers
0
votes
99
views
asked 6 months agolg...
If my environment is full of Apache Hudi integrating with EMR and Lake Formation, I found out that Hudi environment is not very friendly to be used by Redshift nor Athena. There are many advanced...
1
answers
0
votes
447
views
asked 6 months agolg...
i'm used AWS glue crawler data from S3 Bucket to Datacata log and using AWS redshift query but show error:
ERROR: Parsed manifest is not a valid JSON object. Detail:...
1
answers
0
votes
404
views
asked 6 months agolg...
Hello,
Here is my current situation where I need some help ;)
* I created user groups in Azure Active Directory and added users to it
* I connected AAD with AWS
* I have a redshift database with...
2
answers
0
votes
302
views
asked 6 months agolg...
On `Redshift 1.0.60353`, I'm getting the following error for a query that previously worked:
```
SQL Error [XX000]: ERROR: failed to find conversion function from "unknown" to numeric
```
According to...
1
answers
0
votes
1454
views
asked 6 months agolg...
I have a Redshift cluster currently configured with two ra3.xlplus nodes. I am going to vertical upscale the cluster from two ra3.xlplus nodes to three ra3.xlplus nodes. A planning assumption is that...
1
answers
0
votes
260
views
asked 6 months agolg...
[updated]
Resolved with this...
1
answers
0
votes
368
views
asked 6 months agolg...
when we drop some table in a store procedure, redshift throw below error. After struggling searching on the internet, don't find any. please help. The strange is it only have this issue on dev env, ...
1
answers
0
votes
332
views
asked 6 months agolg...
To connect to Redshift from our app, we would like to replace existing JDBC driver (Java) with the python sql connector if possible. For that purpose, we measured the performance to fetch a few large...
1
answers
0
votes
326
views
asked 6 months agolg...
We're seeing queries running much slower (taking 2-3x the time), and cluster load jumped up to double what it was before this release. We had no changes on or around this date as all the staff who...
1
answers
0
votes
210
views
asked 6 months agolg...