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 <[email protected]> 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.
