cancel
Showing results for 
Search instead for 
Did you mean: 
0 Kudos

Convert from CSV to ORC - action

I want to convert from CSV format file to ORC format file.

to query sensor data on Azure Storage.

 

ORC format file

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ORC

- defined on Apache Hive.

 

SQL Server 2019 can query ORC format file,

ORC format file store data in column-store instead of row-store.

so, big data of ORC format file is nice.

 

Status: New
Comments
Memorable Member

and also, support of Parquet format file, and RCFILE format file.

and also, support of Gzip compression file, and Snappy compression.

 

ORC, Parquest, RCFILE, Gzip, Snappy supported by SQL Server 2019.

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-file-format-transact-sql?view=...

 

I hope to support the file format on Microsoft Flow.