Home | About | Sematext search-lucene.com search-hadoop.com
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
 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
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
 
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