How convert csv files to parquet format in Spotfire

[Rayane Boulic]

Hello,

 

I want to convert a csv files to Parquet format in Spotfire

Do you have some suggestions

Thanks

[Kirsten Smith (she/her)]

There isn't a way in Spotfire to convert csv files to parquet, but there are enhancement requests in place to read parquet files. You might want to vote for this suggestion on our Ideas Portal:

 

https://ideas.tibco.com/ideas/TS-I-6416

[Rayane Boulic]

I voted to this request. 

 

Is it possible to use another product of TIBCO for convert to parquet format like Spotfire Data science for exemple 

 

Thank you 

[Olivier Lebret]

Yes, Spotfire Data Science offers an operator to convert csv Hadoop files into Avro or Parquet :

Below is an excerpt of the documentation regarding this operator :

---------------------------------------------------------------------------------------------------------------------

Description

The Convert operator provides a method for converting a Hadoop csv file into either an Avro or Parquet format.

Configuration

Inputs

One CSV dataset from the preceding operator.

Parameters

Notes Enter any notes or helpful information about the parameter settings of this operator.

Format

Options:

Avro

Parquet

Default value: Parquet

Compression

Choose the desired compression of the output.

For Parquet, the compression options are:

GZIP

Deflate

Snappy

no compression

 

Outputs

Visual Output

Preview of the data.

Output To Succeeding Operators

A dataset of the chosen format and compression.