Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
To: "user@hive.apache.org" <user@hive.apache.org>
From: peter 2 <regestrer@gmail.com>
Subject: 
 org.apache.hadoop.hive.serde2.lazy.objectinspector.primitive.LazyDateObjectInspector
Message-ID: <55A695C6.6000105@gmail.com>
Date: Wed, 15 Jul 2015 20:17:58 +0300
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101
 Thunderbird/38.0.1
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

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