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
I have Pig and Hive v0.12 .

From: D K [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 07, 2014 7:35 PM
To: [EMAIL PROTECTED]
Subject: Re: ERROR 1115: Unsupported type: 5 in Pig's schema

What version of Pig and Hive you are using? Boolean support was added in Pig v0.10 and in the HCatStorer in Hive v0.12.

On Wed, Jul 2, 2014 at 7:07 AM, Carlotta Hicks <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
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]<mailto:[EMAIL PROTECTED]>]
Sent: Wednesday, July 02, 2014 12:51 AM
To: [EMAIL PROTECTED]<mailto:[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