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:14:27 UTC
[jira] [Created] (TRAFODION-164) LP Bug: 1269238 - Create volatile
table returns HBASE error from hpdci.
Alice Chen created TRAFODION-164:
------------------------------------
Summary: LP Bug: 1269238 - Create volatile table returns HBASE error from hpdci.
Key: TRAFODION-164
URL: https://issues.apache.org/jira/browse/TRAFODION-164
Project: Apache Trafodion
Issue Type: Bug
Components: sql-general
Reporter: Weishiun Tsai
Assignee: Anoop Sharma
Priority: Critical
Creating a volatile table from hpdci returned HBASE_OPEN_ERROR(-703) in ExpHbaseInterface::scanOpen(), as shown in the following output. The same sequence of commands ran fine from sqlci. This may be related to how mxosrvr handles volatile tables. The build is the beta build trafodion-ci-release-trafodion_beta-20140108-v36687_release.tar running on a workstation.
The first part of the following output shows the error from hpdci. The second part of the output shows that the same commands ran fine from sqlci.
==========================================================================
Welcome to HP Database Command Interface 3.0
(c) Copyright 2010-2012 Hewlett-Packard Development Company, LP.
Connected to Data Source: TDM_Default_DataSource
SQL>obey test.sql;
SQL>create table d1
+>(
+>seqno integer default null,
+>smin1 smallint signed default null,
+>smin2 smallint unsigned default null,
+>inte1 integer signed default null,
+>inte2 integer unsigned default null,
+>lint1 largeint default null,
+>lint2 largeint default null,
+>nume1 numeric(7) unsigned default null,
+>nume2 numeric(9,3) unsigned default null,
+>nume3 numeric(18) signed default null,
+>nume4 numeric(18,15) signed default null,
+>deci1 decimal(3) unsigned default null,
+>deci2 decimal(18,0) signed default null,
+>deci3 decimal(18,9) signed default null,
+>pict1 pic s9(18) comp default null,
+>pict2 pic sv9(2) comp default null,
+>pict3 pic s9(13)v9(5) default null,
+>pict4 pic 9(3)v9(6) default null,
+>flot1 float (12) default null,
+>flot2 float (52) default null,
+>real1 real default null,
+>real2 real default null,
+>dblp1 double precision default null,
+>dblp2 double precision default null,
+>char1 char (12) default null,
+>char2 varchar (30) upshift default null
+>);
--- SQL operation complete.
SQL>create volatile table vd1 as select * from d1;
*** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::scanOpen returned error HBASE_OPEN_ERROR(-703). Cause:
org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.VOLATILE_SCHEMA_MXID110000156652122565079694501530000000002.D1
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegionInMeta(HConnectionManager.java:1024)
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegion(HConnectionManager.java:889)
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.relocateRegion(HConnectionManager.java:860)
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.getRegionLocation(HConnectionManager.java:770)
org.apache.hadoop.hbase.client.HTable.getRegionLocation(HTable.java:388)
org.apache.hadoop.hbase.client.transactional.RMInterface.registerTransaction(RMInterface.java:79)
org.apache.hadoop.hbase.client.transactional.RMInterface.getScanner(RMInterface.java:135)
org.trafodion.sql.HBaseAccess.HTableClient.startScan(HTableClient.java:185)
. [2014-01-15 03:23:39]
*** ERROR[8811] Trying to close a statement that is either not in the open state or has not reached EOF. [2014-01-15 03:23:39]
==========================================================================
-bash-4.1$ sqlci
Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
>>obey test.sql;
>>create table d1
+>(
+>seqno integer default null,
+>smin1 smallint signed default null,
+>smin2 smallint unsigned default null,
+>inte1 integer signed default null,
+>inte2 integer unsigned default null,
+>lint1 largeint default null,
+>lint2 largeint default null,
+>nume1 numeric(7) unsigned default null,
+>nume2 numeric(9,3) unsigned default null,
+>nume3 numeric(18) signed default null,
+>nume4 numeric(18,15) signed default null,
+>deci1 decimal(3) unsigned default null,
+>deci2 decimal(18,0) signed default null,
+>deci3 decimal(18,9) signed default null,
+>pict1 pic s9(18) comp default null,
+>pict2 pic sv9(2) comp default null,
+>pict3 pic s9(13)v9(5) default null,
+>pict4 pic 9(3)v9(6) default null,
+>flot1 float (12) default null,
+>flot2 float (52) default null,
+>real1 real default null,
+>real2 real default null,
+>dblp1 double precision default null,
+>dblp2 double precision default null,
+>char1 char (12) default null,
+>char2 varchar (30) upshift default null
+>);
--- SQL operation complete.
>>
>>create volatile table vd1 as select * from d1;
--- 0 row(s) inserted.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)