Four Stars

Create orc file format

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.
  • Big Data
  • Data Integration
1 REPLY
Moderator

Re: Create orc file format

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.