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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Ke_Sg
Contributor II
Contributor II

How to load in Qliksense a parquet file generated by Qliksense ?

Hi,

I would like to generate and read parquet files using Qliksense. However, even after following documentation, it seems the file format is not recognised by Qliksense. I tried to generate a tiny dummy table, but with no success.

 

The error is : "Unknown LOAD statement error"

 

My script, in the same (newly-generated) app :

TEST:
LOAD * INLINE [
FIELD1, FIELD2
Val1, Val2
];

TAG FIELD1 WITH '$parquet-string';
TAG FIELD2 WITH '$parquet-string';
STORE TEST into [TEST.parquet](parquet, compression is uncompressed);
DROP TABLE TEST;

// -------

DATA:
LOAD * FROM [TEST.parquet](parquet);
DROP TABLE DATA;

 

I tried snappy compression, no field tagged as string, a LOAD with only one field ... resulting with the same error each time.

Using the data manager, even though Apache Parquet is listed in filetypes, I get a similar error when manually loading my TEST.parquet file : "this filetype is not supported".

My question is : is it possible to generate in Qliksense a parquet file readable by Qliksense ? If so, what are the parameters to use ?

My current Qliksense version is February 2024 Patch 4 (qliksenseserver:14.173.8).

Labels (2)
1 Reply
MatheusC
Specialist II
Specialist II

HI, @Ke_Sg 

Parquet, qlik help example

Store mytable into [lib://AttachedFiles/myfile.parquet] (parquet, compression is lz4);

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularSt...

Regarding the version, I believe it is May 2024 Qlik Sense Enterprise:

https://community.qlik.com/t5/Release-Notes/Sense-Enterprise-on-Windows-release-notes-May-2024-Initi...



- Regards, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!