org.apache.hadoop.hive.serde2.lazy.objectinspector.primitive.LazyDateObjectInspector

[peter 2 <re...@gmail.com>]

HI Guys,
I am running hive on top of Hbase. I am using the jdbc driver to insert 
and read data. Inserts work fine. The data is present in hbase , as I 
can see it using the Hbase shell.
When I try to retrieve the data I get this exception

Hive Internal Error: no LazyObject for 
org.apache.hadoop.hive.serde2.lazy.objectinspector.primitive.LazyDateObjectInspector

The sql I use to create my table is as follows
CREATE TABLE IF NOT EXISTS `scheduled_job`(`job_id` STRING, `name` 
STRING, `status` STRING, `original _configuration` STRING, `start_time` 
DATE, `end_time` DATE, `created_on` DATE, `error_text` STRING, 
`current_run_id` STRING, `current_run` INT, `config_file` STRING, 
`project_id` STRING, `user` STRING, `config_file_name` STRING) STORED BY 
'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES 
('hbase.key.factory.class' = 
'org.apache.hadoop.hive.hbase.BinarySortableKeyFactory', 
'hbase.table.name' ='scheduled_job', 'hbase.table.default.storage.type' 
= 'binary', 'hbase.value.factory.class' = 
'org.apache.hadoop.hive.hbase.BinarySortableValueFactory', 
'hbase.columns.mapping' = '0:name, 0:status, 0:original_configuration, 
0:start_time, 0:end_time, 0:created_on,0:error_text, 0:current_run_id, 
0:current_run, 0:config_file, 0:project_id, 0:user, 0:config_file_name')

I find it odd that inserts would work and data is obviously in Hbase, 
but reading it fails. It fails using the hive cli and jdbc, always with 
the same exception

Regards,
Peter

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus