We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


I am getting decompression OK, trailing garbage ignored Error — Vertica Forum

I am getting decompression OK, trailing garbage ignored Error

rahul_vertica_infyrahul_vertica_infy
in General Discussion

Dear Vertica,

I have some copy command which are failing with below error

$ more /var/opt/fast/tmp/fact_increment_staging.sh.20190418123527202651.FASTSF1868190412.4khkt.7175.log_vertica_SQL.sql.rejected
gzip: /var/opt/fast/extracts/STGNG_POSDS_FRCST_FCT_1868_20190412_20190412: decompression OK, trailing garbage ignored

Please suggest what can be reason?

Comments

  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    I'm pretty sure that's a problem with your compressed files.

    Is this the file? "/var/opt/fast/extracts/STGNG_POSDS_FRCST_FCT_1868_20190412_20190412"

    Try unzipping it manually:

    gunzip /var/opt/fast/extracts/STGNG_POSDS_FRCST_FCT_1868_20190412_20190412

    Do you get that same warning?

  • rahul_vertica_infyrahul_vertica_infy

    Thanks Jim for response.

    I have tried above command and gets like below

    $ gunzip STGNG_POSDS_FRCST_FCT_1868_20190412_20190412
    gzip: STGNG_POSDS_FRCST_FCT_1868_20190412_20190412: unknown suffix -- ignored

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...