Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Google ProtocolBufferException exception when using ORC file format

Zhang Xiaoyu 2013-10-17, 06:34
Copy link to this message
Re: Google ProtocolBufferException exception when using ORC file format
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, Oct 17, 2013 at 12:04 PM, Zhang Xiaoyu <[EMAIL PROTECTED]>wrote:

> 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.IOException:
> com.google.protobuf.InvalidProtocolBufferException: While parsing a
> protocol message, the input ended unexpectedly in the middle of a field.
>  This could mean either than the input has been truncated or that an
> embedded message misreported its own length. (state=,code=0)
> Thanks for help!
> Johnny

Nitin Pawar
Zhang Xiaoyu 2013-10-17, 07:00