0

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"

Improve this question
5
  • What database are you using? Commented Sep 23, 2019 at 14:30
  • Amazon redshift. Commented Sep 23, 2019 at 14:30
  • no, you need to get the data, and then use: compression and decompression of string data in java (* no, because there is also no native method to gzip the data you entered...) Commented Dec 23, 2023 at 19:18
  • or, maybe, MySQL UDF sys_exec Commented Dec 23, 2023 at 19:30
  • Why do you need this? It feels like a faulty design to me... Commented Dec 23, 2023 at 19:42
Related questions
0
Compress file to bytes for uploading to SQL Server
3
How to gunzip sql file in Windows?
1
Uncompressing a Gzip format?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.