CODEWITHSUNDEEP
azure-data-explorer
Dhiraj
Dhiraj

Reputation: 3696

Creating external table to point to ORC data stored in Azure blob

I have ORC data files in Azure blob , I want to read this data from an ADX cluster by creating an external table. But it appears that we can't specify orc as dataformat while creating an external table. It seems to be only accepting TSV,CSV,JSON,PARQUET. Is there any workaround for this?

UPDATE:

As you can see in the below screenshot Kusto is not showing ORC as one of the options when I am trying to create an external table. Now I intend to use this external table for reading (querying) external data , not really export -- but I guess Kusto won't know my intention.

enter image description here

Upvotes: 2

Views: 160

Answers (1)

Michael Spector
Michael Spector

Reputation: 37019

I'm guessing that you're referring to the following statement from the documentation on external tables:

Using external table for export scenario is limited to the following formats: CSV, TSV, JSON and Parquet

The statement says about scenario, when you export data from ADX to external storage. For "read" scenario, all data formats mentioned on this page are supported.

Upvotes: 3

Related Questions