CODEWITHSUNDEEP
sqlgzipamazon-sqsgzipinputstreamgzipoutputstream
Jhutan Debnath
Jhutan Debnath

Reputation: 535

Uncompress Gzip data using Amazon Redshift SQL

We have a service which store the compressed data in the data store(SQL table). This data is compressed using java util library GZIPOutputStream.

My question is is there a way to uncompress this data using SQL?

Sample compressed data:

"H4sIAAAAAAAAAO2QX2vCMBTFv0ueW9FNXeeb2jgCmoqtDBEpsb2FwExckgpO+t0XYytOGIw9S55y7p/fOXd9QjkzbCjyUGblDoTRC/gsuYJ8IhUWhhsOGg3WJ3SQ2v2PIRjGP6x4o5HcjvKCgzrLUGtogNjuS7SY3Le2peYCtG6xfg+Czkvhb4Og53fhteMH/XbmP2fd/lMWQJcVbeTVO5LjHuyWUT181WNZquxcicIYVZX3a4op18bZZ8Yovi0NXJUDKOs4Y4ZLMWyqlO0ccBkTiuM4nZIxpmOc0uVshBeWr4BpKexxasKZZgdmJLYTbymhkwhVG2vo3oljNupUWq50x2qkuZKyaPI2+PkiiiaWar1qa7MuU/x+vcTNph9C3YppQpJVSkJUeff0usUx0mQ1x+loGGPX+aeU3iPPI88jz7/zbC7vGxsilliEBQAA"

Upvotes: 0

Views: 96

Answers (0)

Related Questions