amazon-redshift Questions
2
Solved
Is it possible to add multiple columns in a single Alter query in Redshift
Alter table employee
add column Name,
add column Age,
add column Salary
Taenia asked 1/4, 2021 at 5:40
4
Solved
I am converting some SQL Logic from T-SQL used in SSMS to Amazon Redshift. I believe Redshift is a fork of Postgres version 8.0.2 so the below may not be possible unless using Postgres 9.1.
WITH ...
Remediosremedy asked 26/3, 2018 at 19:31
4
Solved
In RedShift, it is convenient to use unload/copy to move data to S3 and load back to redshift, but I feel it is hard to choose the delimiter each time. The right delimiter is relevant to the conten...
Renfrew asked 16/10, 2014 at 17:52
4
Solved
I have 3 table t1, t2 and t3.
t1 has 2 column-> id1, val1
t2 -> id2, val2
t3 -> id3, val3
If id1=id2 and id2 = id3
then I need to update val1 ad val3.
But I have repeating id1 and each...
Necrosis asked 5/8, 2016 at 9:28
3
Solved
Does Redshift support JSON fields, like Postgresql's json data type? If so what do I do to use it?
Somewise asked 22/9, 2015 at 17:0
3
Solved
In AWS Athena you can write
SHOW CREATE TABLE my_table_name;
and see a SQL-like query that describes how to build the table's schema. It works for tables whose schema are defined in AWS Glue. T...
Gregor asked 2/12, 2019 at 21:44
2
I would like to prepare a manifest file using Lambda and then execute the stored procedure providing input parameter manifest_location.
Stored procedure signature:
CREATE OR REPLACE PROCEDURE stage...
Broaden asked 7/12, 2021 at 13:10
4
I have an AWS Kinesis Firehose stream putting data in s3 with the following config:
S3 buffer size (MB)* 2
S3 buffer interval (sec)* 60
Everything works fine. The only problem is that Firehose c...
Hinz asked 28/4, 2016 at 17:9
3
Solved
I am trying to setup a sync between AWS Aurora and Redshift. What is the best way to achieve this sync?
Possible ways to sync can be: -
Query table to find changes in a table(since I am only doi...
Bullnose asked 16/6, 2017 at 21:53
2
Solved
I am interested in performance testing my query in Redshift.
I would like to disable the query from using any cached results from prior queries. In other words, I would like the query to run from ...
Sabir asked 21/2, 2019 at 10:47
2
Solved
I'm trying to convert a query from Redshift to Snowflake SQL.
The Redshift query looks like this:
SELECT
cr.creatives as creatives
, JSON_ARRAY_LENGTH(cr.creatives) as creatives_length
, JSON_E...
Nocturnal asked 15/10, 2021 at 12:47
2
Solved
Getting this error in particular:
ERROR: Error when calling external catalog API: The number of partition keys do not match the number of partition values
Wye asked 9/3, 2018 at 21:55
4
In Amazon Redshift tables, I have a string column from which I need to extract numbers only out. For this currently I use
translate(stringfield, '0123456789'||stringfield, '0123456789')
I was t...
Chiropractor asked 22/3, 2014 at 5:27
2
Solved
There are tons of examples to migrate data from DynamoDB to Redshift, but I couldn't find any example or documentation for migrating data from Redshift to DynamoDB. Any suggestion/example/doc for m...
Tenderloin asked 10/2, 2017 at 11:43
2
Solved
When running the below query:
WITH sublevels AS (
SELECT 1 UNION ALL
SELECT 1 UNION ALL
SELECT 1
), FIELDA AS (
SELECT (ROW_NUMBER() OVER ())::INT sublevel
FROM sublevels sl1, sublevels sl2,...
Hyperbaric asked 2/8, 2019 at 12:21
3
Solved
Getting the list of users belonging to a group in Redshift seems to be a fairly common task but I don't know how to interpret BLOB in grolist field.
I am literally getting "BLOB" in grolist field ...
Uhhuh asked 19/8, 2018 at 1:45
6
I'm getting a 1202 Extra column(s) found error in Redshift when trying to load a simple CSV. I've made sure that there are no additional columns nor any unescaped characters in the file that would ...
Vendue asked 14/3, 2016 at 21:35
5
Solved
I try to have a Kinesis Firehose pushing data in a Redshift table.
The firehose stream is working and putting data in S3.
But nothing arrive in the destination table in Redshift.
In the metrics...
Dilettante asked 10/12, 2015 at 16:46
3
How can we transpose a Redshift table from columns to rows?
For example, if we have a generic (not already known) table like the following:
source table:
date id alfa beta gamma ... omega
2018-0...
Supernormal asked 4/9, 2018 at 21:59
3
Solved
I'm loading a CSV file from S3 into Redshift. This CSV file is analytics data which contains the PageUrl (which may contain user search info inside a query string for example).
It chokes on rows w...
Turnheim asked 6/8, 2015 at 16:52
2
When I run "DESCRIBE table_name;" in SQLWORKBENCHJ for redshift, or mysqlworkbench for MySQL, it will list the columns of the table, primary key, foreign keys, etc. However, I don't find the equiva...
Deferment asked 19/7, 2019 at 1:41
9
Solved
I am attempting to update Redshift from a Lambda function using python. To do this, I am attempting to combine 2 code fragments. Both fragments are functional when I run them separately.
Updating...
Jodoin asked 13/4, 2016 at 19:35
7
Solved
I'd like to view grants on redshifts.
I found this view for postgres:
CREATE OR REPLACE VIEW view_all_grants AS
SELECT
use.usename as subject,
nsp.nspname as namespace,
c.relname as item, ...
Sutter asked 11/9, 2013 at 12:31
4
Solved
I'm trying to figure out the different types of sortkeys in Amazon Redshift and I encountered a strange warning here, which is not explained:
Important: Don’t use an interleaved sort key on col...
Fernyak asked 11/2, 2019 at 13:2
5
Solved
This is my python code and I want to connect my Amazon Redshift database to Python, but it is showing error in host.
Can anyone tell me the correct syntax? Am I passing all the parameters correctl...
Picaresque asked 20/7, 2017 at 10:34
© 2022 - 2024 — McMap. All rights reserved.