Thanks, Nitin, I guess, as you suggested. I can use text format in temp
table (staging table), and use final table as ORC format. So when I merge
data from staging table to final table, data got re-formatted from text
into ORC.
Johnny
On Wed, Oct 16, 2013 at 11:46 PM, Nitin Pawar wrote:
> Hi Zh
Hi Zhang,
you can not load a text file as orc file as load command does not transform
your txt file to orc.
To write a orc file you will need to use hcatalog apis.
What you can do is
create a temp table and load the data there.
then do a insert into table test select * from temptest
On Thu, Oc
Hi, all,
I am simply using ORC file to store the data and get below exception. Any
idea what's wrong with it?
create table test (f1 int) stored as orc tblproperties
("orc.compress"="NONE");
load data local inpath '/home/athena/test.txt' into table test;
select * from test;
===>
Error: java.io.I
