Questions tagged [redshift]
7 questions
6
votes
1 answer
Why does running Redshift commands from crontab does not seem to work?
About redshift:
Redshift adjusts the color temperature of your screen according to your surroundings.
A typical redshift command that I use is redshift -O 9999 which sets the screen color temperature at 9999K. Following a polyphasic sleep…
ToonAlfrink
- 131
- 11
6
votes
2 answers
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' credentials…
Ry4an Brase
- 481
- 3
- 10
4
votes
0 answers
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…
White Shadows
- 41
- 1
2
votes
1 answer
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 of data. I do this within another CTE (let's call…
aggis
- 121
- 1
- 2
0
votes
1 answer
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 .dsv files, and if so, how?
Is it possible to…
0
votes
1 answer
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 it happens). Also it may stay "greyed out" since…
Amessihel
- 355
- 1
- 11
0
votes
0 answers
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 making the smaller file, I need to insert it into a…
Cyrus
- 101
- 4