I have Pig and Hive v0.12 . From: D K [mailto:deepe...@gmail.com] Sent: Monday, July 07, 2014 7:35 PM To: user@hive.apache.org 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 <carlotta.hi...@sas.com<mailto: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<mailto:hadooph...@gmail.com>] Sent: Wednesday, July 02, 2014 12:51 AM To: user@hive.apache.org<mailto: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<mailto: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<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
