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