ORC Writer

Options

Mode

Depending on the selected mode the node writes the input data into a single file or splits it up into several files of the defined size which are then stored in the specified folder.

Output location

Select a file system and location where you want to store the file(s).

Create missing folders

If enabled, missing folders in the specified path will be created automatically.

File compression

The compression codec used to write the ORC file.

Split data into files of size (rows)

Splits up the input data into files with at most the given number of data rows. This option is only available if the folder mode is selected.

File name prefix

The prefix to use for the file within the selected folder. A running index is appended starting with 0 e.g. part_00000.orc, part_00001.orc. This option is only available if the folder mode is selected.

Within file stripe size (rows)

Defines the maximum number of rows of a file stripe. For more details see the ORC documentation.

Name

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

• Column selection type: The option allows you to select how the column is matched.
  • Manual: Use the exact name of the column
  • Regex: Allow regex expressions to select multiple columns
• Column name: The column name or regex expression.
• KNIME type: KNIME data type to map from.
• Mapping to: External data type to map to.

Type

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

• KNIME type: KNIME data type to map from.
• Mapping to: External data type to map to.

Views

This node has no views

Workflows

• Data Export ExampleKNIME Hub
• kn_example_hive_orc_external_tableKNIME Hub
• kn_example_path_local_temp_folderKNIME Hub
• kn_example_python_read_orc_fileKNIME Hub

Links

• No links available

Developers