Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Troy1
Contributor III
Contributor III

store data into Parquet format

is it possible to store data into parquet format? how

11 Replies
Anil_Babu_Samineni

I haven't seen anywhere, Kindly check If there is any too which can change format from Qlik to Parquet.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vunguyenq89
Creator III
Creator III

Hi, Qlik engine only support storing data to delimited text and QVD files. You may consider storing data to CSV, then use EXECUTE command to call an external script which converts the CSV to parquet file. For example Python script: https://stackoverflow.com/questions/50604133/convert-csv-to-parquet-file-using-python

Hope this helps,

BR,

Vu Nguyen

dilruksha
Contributor
Contributor

Use the below code:

 

// Store the data in a Parquet file

Store MyData into [lib://MyFolder/MyData.parquet] (qvx);

 

simonaubert
Partner - Specialist II
Partner - Specialist II

Hello @Troy1 

You can add your vote here for more store format :
https://community.qlik.com/t5/Suggest-an-Idea/QS-Script-store-with-more-format/idi-p/2005668

Best regards,

Simon

Bi Consultant (Dataviz & Dataprep) @ Business & Decision
Lucke_Hallbergson

Use

parquet.png

simonaubert
Partner - Specialist II
Partner - Specialist II

Hello @Lucke_Hallbergson 

First of all, that's nice O_O

3 things : 

-this is not mentioned in the help ! 

The Store statement creates a QVD, or text file.
https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

-what are the other format available?
-when was it added ?

Best regards,

Simon

Bi Consultant (Dataviz & Dataprep) @ Business & Decision
PrashantSangle

Interesting.. When I tried in my qlik it is not working. Any additional setting need to add?

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Lucke_Hallbergson

It is enabled on Qlikcloud atm!

PrashantSangle

ohh cool... let me try it.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂