Create orc file format

[Anonymous]

Hi,

While creating a table in talend in the tHiveCreateTable I can find in file formats drop down: orc file format can I use this to create a orc file format or is there any other way.

[Anonymous]

Hello,

In order to create a ORC file format, here is a way:

1 – Create a table within Hive with for EXT format.
2 – Load you data into this table using: LOAD DATA [LOCAL] INPATH.
3 – Create another table within Hive with the format ORC.
4 – INSERT INTO orc_table SELECT * FROM text_table.

Best regards

Sabrina

[Anonymous]

Hello , wanted to check if talend has come up with a straight forward way to creat an ORC file ?