Support Questions
Find answers, ask questions, and share your expertise

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

Solved Go to solution
Highlighted

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

Explorer
 
1 ACCEPTED SOLUTION

Accepted Solutions

Re: 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

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?

View solution in original post

1 REPLY 1

Re: 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

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?

View solution in original post

Don't have an account?