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


Reply via email to