EXPORT INTO SCRIPT
Details
| Detail name | Value |
|---|---|
| Changelog Number | 5191 |
| Type | New Feature |
| Status | Resolved |
| Fix Versions | EXASOL 6.0.7 |
| Resolution Date | 2017-12-01 |
Similar to IMPORT FROM SCRIPT users will get the possibility to use UDF scripts that are directly integrated into the EXPORT syntax.
For further details, please have a look at the user manual's chapter 3.4.5. "User-defined EXPORT using UDFs".
Note: Please note that this feature has been added as beta-feature afterwards to version 6.0. Therefore, the API may change in the future and could differ slightly to this description.
A first example is the implementation of a Hadoop EXPORT integration that has been published on our GitHub repository: https://github.com/EXASOL/hadoop-etl-udfs
Example EXPORT statement for Hadoop integration:
EXPORT my_table_2 INTO SCRIPT etl.export_hcat_table WITH HCAT_DB = 'default' HCAT_TABLE = 'my_hcat_table_2' HCAT_ADDRESS = 'hcatalog-server:50111' HDFS_USER = 'hdfs';
