Four Stars

Create orc file format


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.

Re: Create orc file format


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


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