Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - ERROR 1115: Unsupported type: 5  in Pig's schema


Copy link to this message
-
RE: ERROR 1115: Unsupported type: 5 in Pig's schema
Carlotta Hicks 2014-07-02, 14:08
Yes.  Here is a row of data:

cust_1,M,56,D,Hopatcong,NJ,7843,15-May-74,15-May-77,88.00,43,688.00,458.00,N

From: hadoop hive [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 02, 2014 12:51 AM
To: [EMAIL PROTECTED]
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;
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<http://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