Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
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