I am strucking out with Hcat storer.

[Muni mahesh <ma...@gmail.com>]

register '/usr/lib/hcatalog/share/hcatalog/*.jar'

register '/usr/lib/hive/lib/*.jar'


A = load 'file' as (one:chararray);
STORE A INTO 'table_name' USING org.apache.hcatalog.pig.HCatStorer();

*Working :*

Hive is working

meta-store is working

H-catalog is working

Using Default database only

*But,*

*ERROR org.apache.pig.**tools.grunt.Gru**nt - ERROR 2116: *
<line 15, column 0> Output Location Validation Failed for: 'table_name More
info to follow:
*org.apache.hcat**alog.common.HCa**tException* : 2007 : Invalid column
position in partition schema : Expected column <name> at position 1, found
column <one>
Details at logfile: /root/pig_1385563490691.log

Re: I am strucking out with Hcat storer.

[Thejas Nair <th...@hortonworks.com>]

Looks like your table has first column name as "name". If your "one"
column is expected to be written as the "name" column, rename one as
name. You can do this in the pig load statement schema or using
another foreach statement.

A = load 'file' as (name : chararray);
STORE A INTO 'table_name' USING org.apache.hcatalog.pig.HCatStorer();

On Wed, Nov 27, 2013 at 7:36 AM, Muni mahesh <ma...@gmail.com> wrote:
> register '/usr/lib/hcatalog/share/hcatalog/*.jar'
>
> register '/usr/lib/hive/lib/*.jar'
>
>
> A = load 'file' as (one:chararray);
> STORE A INTO 'table_name' USING org.apache.hcatalog.pig.HCatStorer();
>
> *Working :*
>
> Hive is working
>
> meta-store is working
>
> H-catalog is working
>
> Using Default database only
>
> *But,*
>
> *ERROR org.apache.pig.**tools.grunt.Gru**nt - ERROR 2116: *
> <line 15, column 0> Output Location Validation Failed for: 'table_name More
> info to follow:
> *org.apache.hcat**alog.common.HCa**tException* : 2007 : Invalid column
> position in partition schema : Expected column <name> at position 1, found
> column <one>
> Details at logfile: /root/pig_1385563490691.log

-- 
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to 
which it is addressed and may contain information that is confidential, 
privileged and exempt from disclosure under applicable law. If the reader 
of this message is not the intended recipient, you are hereby notified that 
any printing, copying, dissemination, distribution, disclosure or 
forwarding of this communication is strictly prohibited. If you have 
received this communication in error, please contact the sender immediately 
and delete it from your system. Thank You.