Hadoop and Other Systems

Exasol provides a project Hadoop ETL UDFs that you can use this project to transfer data between Exasol and Hadoop cluster. This is an open source project officially supported by Exasol.

The SQL syntax used in the UDF is similar to Exasol's native IMPORT and EXPORT commands. However, the syntax contains some additional parameters to set the Hadoop properties.

The project currently supports the following:

• HCatalog Metadata (for example, table location, columns, partitions)
• Multiple file formats (for example, Parquet, ORC, or RCFile)
• Hadoop Distributed File System (HDFS) High Availability
• Partitions
• Parallelization