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 <carlotta.hi...@sas.com> 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:hadooph...@gmail.com] > *Sent:* Wednesday, July 02, 2014 12:51 AM > *To:* user@hive.apache.org > *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" <carlotta.hi...@sas.com> 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 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* > > > >
