Yes.  Here is a row of data:


From: hadoop hive [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 02, 2014 12:51 AM
Subject: Re: ERROR 1115: Unsupported type: 5 in Pig's schema
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" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
Hi All!  I created an hbase table and hcatalog table like the following:
hive> describe formatted client;
# 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
      <>           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 - ERROR 1115: Unsupported type: 5  in Pig's schema

Does anyone understand what the problem could be?
Carlotta Hicks
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB