Questions tagged [redshift]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
6 views

Disconnect from Reshift on SQLworkbench J

I am using SQLworkbench J to connect to redshift server. During the connection the team realized that the connection stayed alive for long period of time even when not queried. Is there a way to ...
0
votes
0answers
10 views

On Amazon RedShift, will Queries show up as being aborted on the Main Cluster before they are redirected to Concurrency Scaling clusters?

Recently I've been tasked with using Amazon RedShift to stimulate concurrency scaling (using external / Amazon's own resources to run a query). We are obviously trying this in a sandbox environment ...
0
votes
0answers
25 views

temporary tables created by Amazon Redshift

I can't drop temporary tables created by Redshift. I use this script to find all the temp tables in the cluster: select name, count(distinct id) from stv_tbl_perm where temp = 1 group by 1 The ...
0
votes
1answer
20 views

Can I load .dsv files from S3 to Redshift / SQL Workbench, or convert them to another file type in S3?

I have a lot of files in .dsv format from a client, and I need to get them into SQL Workbench. I have previously only loaded .txt and .csv before and cannot find documentation. Is it possible to copy ...
2
votes
0answers
267 views

Reading data from Amazon redshift in Spark 2.4

We used to read data in Spark 2.3 using databricks with the following code segment Spark-Shell initialization : spark-shell --jars RedshiftJDBC42-1.2.10.1009.jar --packages com.databricks:spark-...
0
votes
1answer
51 views

Autostart redshift-gtk in Window Maker and prevent it to run twice

I struggled to launch redshift-gtk at Window Maker startup. Moreover, editing a dockable icon would not prevent the app to be load twice (I noticed it's the case at WMaker startup, I don't know what ...
0
votes
0answers
15 views

Can Redshift save off or quarantine bad records on import?

In the following command, 90 records import successfully, and two records fail: user@host:~$ psql --host=redshiftcluster.amazonaws.com --username=user --dbname=dev --port=5439 -c "COPY tmp_table FROM ...
1
vote
0answers
412 views

Invalid operation: Assert - Error in Redshift

I am getting an Assert error that I've never seen before within Redshift. I created a CTE (let's call it seed) that joins 6+ tables. From the CTE, I need to do some aggregations and transformations ...
0
votes
0answers
483 views

AWS Redshift failed to inflateinvalid or incomplete deflate data while inserting a zipped csv file

I have a zipped csv file which is a part of a huge file, and extracted from the original huge file using the following command: gunzip -c myFile.csv.gz | head -n 500000 > myFile.csv.gz_p1 after ...
5
votes
1answer
1k views

Running Redshift commands from crontab, doesn't work

About redshift: Redshift adjusts the color temperature of your screen according to your surroundings. This may help your eyes hurt less if you are working in front of the screen at night. A typical ...
6
votes
1answer
1k views

What does it mean when Redshift gives you “invalid end key specified” on a dynamo table load?

Doing a dynamo load into redshift I got this error that didn't show up in the Redshift docs or as a literal string into google at all. # copy redshift_table_name from 'dynamodb://DYANAMOTABLENAME' ...