Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Apache ORC input/output format support

Status: Under Review Submitted by on ‎08-10-2017 10:30 AM
6 Comments (6 New)

https://orc.apache.org/

 

Apache ORC is commonly used in the context of Hive, Presto, and AWS Athena. A common pattern for us is to use Alteryx to generate Apache Avro files, then convert them to ORC using Hive. For smaller data sizes, it would be convenient to be able to simply output data in the ORC format using Alteryx and skip the extra conversion step.

 

ORC supports a variety of storage options that users may wish to override from sensible Alteryx defaults. We typically use the SNAPPY compression codec.

See more ideas labeled with:
6 Comments
Nitish_Salve
7 - Meteor
‎05-30-2018 03:25 AM

Hi Team,

Is Apache ORC input/output format supported now?

0 Likes
JohnGD
Alteryx
Alteryx
‎05-30-2018 04:23 AM

Hi @Nitish_Salve!

 

At the moment, columnar file formats are not supported by Alteryx.

 

However, they can be accessed in Alteryx via the Hive ODBC Driver.

You will have to create intermediary Hive tables first in order to store the data.

 

I suggest that you take a look at this community article on another type of columnar data and the Hive DDL documentation for Apache ORC.

 

Let me know how it worked for you !

John

0 Likes
ARich
Alteryx Alumni (Retired)
‎06-28-2018 01:28 PM
Status changed to: Under Review
 
0 Likes
simonaubert_bd
13 - Pulsar
‎04-25-2023 02:02 PM

Hello. For information, Qlik now allows to read Parquet, so I guess it's possible..

0 Likes
simonaubert_bd
13 - Pulsar
‎06-30-2023 04:05 AM

For Parquet the idea is here https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/Add-Parquet-data-format-as-input-amp...

 

Both Orc and Parquet should be supported in 2023...

0 Likes
Labels