Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2013-06-10 03:39 AM

zip

Hi,
How to make a gzip file in talend..
I have 10 files and it has to zip with gzip format is that possible in talend?
Labels (2)
Labels
558 Views
0 Likes
10 Replies
Anonymous
Not applicable
‎2013-06-10 05:56 AM
Author

use tFileArchive file your job design should be like this
tFileList--tFileArchive
pass file name from tFileList to tFileArchive from goloble variable, and please refer Talend User guide for more information.
493 Views
0 Likes
Anonymous
Not applicable
‎2013-06-14 05:33 AM
Author

Hi,
Please see the related component references tFileArchive.
Unchecked the "All files" option, and you can set the Filemask for your specified files
See my screenshot
Best regards
Sabrina
0683p000009MEJG.png
493 Views
0 Likes
Anonymous
Not applicable
‎2013-06-14 01:18 PM
Author

hi,
thanks .. But problem is when i upload this gzip file into redshift we are not able to load into the amazon redshift database. so i am thinking there might be the problem with gzip which is not supporting equvalent to redshift
493 Views
0 Likes
Anonymous
Not applicable
‎2013-06-17 12:30 AM
Author

Hi,
I have never load .gzip file into DB. Perhaps you should take a consideration on field type or something else on DB. If the .gzip files are correct, I think the tFileArchive is alright.
Best regards
Sabrina
493 Views
0 Likes
Anonymous
Not applicable
‎2013-06-24 02:20 PM
Author

I am actually trying to do the same exact thing. Load a gzip file into s3 and then use RedShifts copy command along with its gzip feature to push the data into RedShift.
I have used tFileArchive to gzip the file and result in the following error:
Error : ERROR: Failed writing body (0 != 8645) Cause: Failed to inflateinvalid or incomplete deflate data. zlib error code: -3
I run into no issues when I use the command "gzip -c file.txt > file.gz" to gzip the file.
493 Views
0 Likes
Anonymous
Not applicable
‎2013-07-14 01:03 PM
Author

Hi,
If it is linux os there will be no problem but if i want to do it in windows how can i resolve my issue?
493 Views
0 Likes
Anonymous
Not applicable
‎2013-07-22 02:59 PM
Author

I suggest downloading a program that can perform gzip on windows and then execute the program using the cmd talend component.
493 Views
0 Likes
Anonymous
Not applicable
‎2013-07-22 03:07 PM
Author

You can consider writing some code in a tJava. Java core library has a class to create GnuZip files.
Here an example:
http://www.xyzws.com/Javafaq/how-to-make-a-gzip-file-in-java/215
493 Views
0 Likes
_AnonymousUser
Specialist III
Specialist III
‎2014-03-08 12:13 PM

An error occurred when executing the SQL command:

ERROR: Failed writing body (0 != 8576) Cause: Failed to inflateinvalid or incomplete deflate data. zlib error code: -3
Detail:
-----------------------------------------------
error: Failed writing body (0 != 8576) Cause: Failed to inflateinvalid or incomplete deflate data. zlib error code: -3
code: 9001
context: S3 key being read : s3://file.txt.gz.007
query: 7947
location: table_s3_scanner.cpp:383
process: query1_22
-----------------------------------------------
Execution time: 0.64s
1 statement(s) failed.
How to fix this issue?
493 Views
0 Likes