Did you checked your .CSV file it must have same no of column.
Scema looks good.
On Jun 30, 2014 7:37 PM, "Carlotta Hicks" <carlotta.hi...@sas.com> wrote:
> Hi All! I created an hbase table and hcatalog table like the following:
>
>
>
>
>
> hive> describe formatted client;
>
> OK
>
> # col_name data_type
> comment
>
>
>
> a string from
> deserializer
>
> b string from
> deserializer
>
> c int from
> deserializer
>
> d string from
> deserializer
>
> e string from
> deserializer
>
> f string from
> deserializer
>
> g string from
> deserializer
>
> h string from
> deserializer
>
> i string from
> deserializer
>
> j double from
> deserializer
>
> k int from
> deserializer
>
> l double from
> deserializer
>
> m double from deserializer
>
> n boolean from deserializer
>
>
>
> # Detailed Table Information
>
> Database: default
>
> Owner: root
>
> CreateTime: Wed Jun 25 17:29:55 EDT 2014
>
> LastAccessTime: UNKNOWN
>
> Protect Mode: None
>
> Retention: 0
>
> Location:
> hdfs://localhost:8020/user/hive/warehouse/client
>
> Table Type: MANAGED_TABLE
>
> Table Parameters:
>
> hbase.columns.mapping :key, gender:b, age:c,
> maritalStatus:d, city:e, state:f, zip:g, BirthDate:h, startDate:i,
> indInsValue:j, totalInsPolicies:k, totalInsValue:l, maxInsValue:m,
> deceased:n
>
> hbase.table.name client
>
> storage_handler
> org.apache.hcatalog.hbase.HBaseHCatStorageHandler
>
> transient_lastDdlTime 1403731795
>
>
>
> I am trying to store data into the hbase table via Pig, but I am getting
> the following error:
>
>
>
> clientData = LOAD 'hdfs:///user/Data/cleint.csv' USING PigStorage(',') as (
>
> a:chararray, b:chararray, c:int, d:chararray, e:chararray, f:chararray,
> g:chararray,
>
> h:chararray, i:chararray, j:double, k:int, l:double, m:double, n:boolean);
>
>
>
> STORE clientData INTO 'client' USING org.apache.hcatalog.pig.HCatStorer();
>
>
>
> 2014-06-30 09:44:53,999 [main] ERROR org.apache.pig.tools.grunt.Grunt -
> ERROR 1115: Unsupported type: 5 in Pig's schema
>
>
>
> Does anyone understand what the problem could be?
>
>
>
>
>
> *Carlotta Hicks*
>
>
>
