amazon-redshift Questions
4
Solved
My Redshift cluster is in a private VPC. I've written the following AWS Lamba in Node.js which should connect to Redshift (dressed down for this question):
'use strict';
console.log('Loading funct...
Knopp asked 22/5, 2017 at 11:49
2
I am querying a timestamp column with datediff from current_timestamp. But it gives error.
DATEDIFF(minute, timestamp_field ,current_timestamp::TIMESTAMP)
or
DATEDIFF(minute, timestamp_field ,cu...
Tragedy asked 26/9, 2016 at 12:1
1
Solved
I had a look at this topic: ERROR: Unsupported PIVOT column type: text but unfortunately it didn't provide me with an answer.
I have a simple table that looks like the following:
user_id | type | r...
Cascabel asked 8/7, 2022 at 9:24
9
Solved
In AWS Redshift, I want to add a sort key to a table that is already created. Is there any command which can add a column and use it as sort key?
Berni asked 26/7, 2013 at 14:35
4
Solved
We are migrating from Redshift to Spark. I have a table in Redshift that I need to export to S3. From S3 this will be fed to Apache Spark (EMR).
I found there is only one way to export data from ...
Mosera asked 25/10, 2016 at 10:27
10
I am wondering how to convert comma-delimited values into rows in Redshift. I am afraid that my own solution isn't optimal. Please advise. I have table with one of the columns with coma-separated v...
Kerin asked 4/8, 2014 at 5:43
4
I was using psycopg2 in python script to connect to Redshift database and occasionally I receive the error as below:
psycopg2.OperationalError: SSL SYSCALL error: EOF detected
This error only ...
Deathbed asked 5/6, 2018 at 21:5
5
I'm trying to load some data from stage to relational environment and something is happening I can't figure out.
I'm trying to run the following query:
SELECT
CAST(SPLIT_PART(some_field,'_',2) A...
Crepitate asked 19/3, 2018 at 21:11
2
My company recently changed our Redshift cluster and now they require an SSL connection. In the past I've connected Python/pandas to Redshift via the method I've detailed here: http://measureallthe...
Hitherto asked 24/6, 2015 at 15:32
4
Solved
We've got a pretty big MongoDB instance with sharded collections. It's reached a point where it's becoming too expensive to rely on MongoDB query capabilities (including aggregation framework) for ...
Insane asked 24/10, 2014 at 10:43
10
I have a text field "presence_changed_at" with text values i.e. '2014/12/17 08:05:28 +0000. I need to convert this into timestamp. In postgreSQL there is function TO_TIMESTAMP(), however in redshif...
Clemons asked 26/7, 2015 at 11:11
3
Solved
I am creating a copy of a production redshift database at a development level. I know how to unload data from my production instance/cluster to s3, then copy that data into my development instance/...
Mitra asked 21/8, 2015 at 21:10
3
Solved
With a table like:
uid | segmentids
-------------------------+----------------------------------------
f9b6d54b-c646-4bbb-b0ec | 4454918|4455158|4455638|4455878|4455998
asd7a0s9-c646-asd7-b0ec ...
Threadbare asked 17/10, 2017 at 7:29
1
Solved
I am trying to replicate a functionality from SQL Server into redshift where I have to ignore column if the column exists, otherwise add it into the table.
I have come across these posts, however c...
Nummular asked 25/3, 2022 at 20:3
3
Solved
Redshift doesn't support DISTINCT aggregates in its window functions. AWS documentation for COUNT states this, and distinct isn't supported for any of the window functions.
My use case: count cust...
Bellringer asked 10/12, 2017 at 6:48
2
I have created a cluster in Amazon Redshift Database and have configured security inbound rules. When trying to connect to it using SQLWorkbench client tool I get the following error.
AmazonError ...
Cite asked 5/1, 2016 at 5:52
4
Solved
We plan to start using Redshift soon, and one of our fields (columns) is a a JSON value. It's a flat JSON (i.e. by definition no nested levels) and the reason we must use JSON is that each record h...
Phillisphilly asked 28/10, 2014 at 15:59
3
Solved
CREATE EXTENSION dblink;
I tried to create an extension dblink in AWS, but I receive this error.
ERROR: syntax error at or near "EXTENSION" LINE 1: create extension
dblink;
Landon asked 4/8, 2017 at 23:52
7
Solved
I am quite new to Amazon DynamoDB. I currently have 20000 rows that I need to add to a table. However, based on what I've read, it seems that I can only write up to 25 rows at a time using BatchWri...
Giefer asked 26/6, 2015 at 5:55
3
Solved
I have a Redshift table that looks like this:
id | metadata
---------------------------------------------------------------------------
1 | [{"pet":"dog"},{"country":"uk"}]
2 | [{"pet":"cat"}]
...
Grits asked 12/5, 2015 at 15:48
14
Solved
Hello I am trying to retrieve the schema of an existing table. I am mysql developer and am trying to work with amazon redshift. How can I export the schema of an existing table. In mysql we can use...
Ewing asked 30/4, 2014 at 3:44
6
Solved
I am trying to perform a load/copy operation to import data from JSON files in an S3 bucket directly to Redshift.
The COPY operation succeeds, and after the COPY, the table has the correct number o...
Clem asked 30/6, 2015 at 1:24
4
Solved
pg_tables provides a list of tables. Is there a pg_columns or its equivalent to provide the list of columns?
In DB2, I would query sysibm.systables/columns to get such information. What is the equ...
Equanimous asked 22/1, 2014 at 3:9
6
I know this question has been asked before but any of the answers were not able to help me to meet my desired requirements. So asking the question in new thread
In redshift how can use pivot the d...
Manchester asked 9/3, 2017 at 11:24
2
Solved
I was checking this, but not find the proper one. So I prepared one and sharing that query here.
Haemal asked 8/6, 2020 at 8:22
© 2022 - 2024 — McMap. All rights reserved.