You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:15:56 UTC
[jira] [Created] (TRAFODION-404) LP Bug: 1336463 - Insert into hive
table on a HortonWorks machine sees LOB_DATA_FILE_CREATE_ERROR(506)
Alice Chen created TRAFODION-404:
------------------------------------
Summary: LP Bug: 1336463 - Insert into hive table on a HortonWorks machine sees LOB_DATA_FILE_CREATE_ERROR(506)
Key: TRAFODION-404
URL: https://issues.apache.org/jira/browse/TRAFODION-404
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Reporter: Weishiun Tsai
Assignee: Sandhya Sundaresan
Priority: Critical
Insert into a hive table on rhel-mapr1, a HortonWorks machine, sees error 8442 saying that it is unable to access LOB interface, as shown below. Strangely enough, this problem only shows up on a HortonWorks machine. It is not seen on other Cloudera machines.
Here is the script to reproduce this problem:
>From hive:
create table myhivetable (a int);
>From sqlci:
set schema hive.hive;
invoke myhivetable;
insert into myhivetable values (1),(2),(3);
Here is the execution output and the error message:
[trafodion@rhel-mapr1 scripts]$ hive
Logging initialized using configuration in file:/etc/hive/conf.dist/hive-log4j.properties
hive> create table myhivetable (a int);
OK
Time taken: 1.923 seconds
hive> exit;
[trafodion@rhel-mapr1 scripts]$
[trafodion@rhel-mapr1 scripts]$ sqlci | cat
Trafodion Conversational Interface 0.8.1
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>set schema hive.hive;
--- SQL operation complete.
>>invoke myhivetable;
-- Definition of hive table MYHIVETABLE
-- Definition current Tue Jul 1 10:51:11 2014
(
A INT
)
--- SQL operation complete.
>>insert into myhivetable values (1),(2),(3);
*** ERROR[8442] Unable to access LOB interface. Call to ExpLOBinterfaceCreate returned error LOB_DATA_FILE_CREATE_ERROR(506). Error detail 0.
--- 0 row(s) inserted.
>>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)