Is it possible to convert a text file format to ORC file format not the table? Also when I'm trying to insert into ORC table from a text file table, the data is not inserting even though mapreduce job is happening. Please help me in this regard

[#1 · Accepted solution]

Hi @Mayank Pandey

If you have existing tables (not in ORC format), I'd recommend creating the ORC tables. Then run:

insert into yourorctable
select * from yourexistingtable;

Is this how you are currently inserting data?