ORC Reader

Reader for ORC files. It reads either single files or all files in a given directory. Does support all ORC types except map, struct and union.

Options

Input

The file or directory to read.

Input Type Mapping

Change the ORC to KNIME type mapping configuration for subsequent nodes by selecting a KNIME type to the given ORC Type. The dialog allows you to add new or change existing type mapping rules.

Mapping by Name

Columns that match the given name (or regular expression) and ORC type will be mapped to the specified KNIME type.

Mapping by Type

Columns that match the given ORC type will be mapped to the specified KNIME type.

Input Ports

Optional port for a remote connection.

Output Ports

Data table containing the data of the ORC file.

Best Friends (Incoming)

• ORC Writer (36 %) Streamable
• Table Row to Variable (9 %) 
• List Files (9 %) 
• HDFS Connection (9 %) 
• Create Local Big Data Environment (9 %) 
• Spark to ORC (9 %) 
• Amazon S3 Connection (9 %) 
• Azure Blob Store File Picker (9 %) 
• Show all 8 recommendations

Best Friends (Outgoing)

• Table Difference Checker (15 %) 
• Upload (8 %) 
• Read Images (8 %) 
• Loop End (8 %) 
• Chunk Loop Start (8 %) 
• Column Filter (8 %) Streamable
• Row Filter (8 %) Streamable
• GroupBy (8 %) 
• Row Sampling (8 %) 
• Extract Table Spec (8 %) 
• Create Local Big Data Environment (8 %) 
• Table to Spark (8 %) Streamable
• Show all 12 recommendations

Installation

To use this node in KNIME, install KNIME BigData File Format Extension from the following update site: