[jira] [Created] (TRAFODION-809) LP Bug: 1400556 - Get tables should return proper errors for hbase."_CELL_" and hbase."_ROW_"

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-809:
------------------------------------

             Summary: LP Bug: 1400556 - Get tables should return proper errors for hbase."_CELL_" and hbase."_ROW_"
                 Key: TRAFODION-809
                 URL: https://issues.apache.org/jira/browse/TRAFODION-809
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Weishiun Tsai
            Assignee: Anoop Sharma
            Priority: Minor


If ‘get tables’ is not intended to be supported for hbase native tables using cell-per-row access or row-wise access, then it should return proper errors.  As shown in the following example.  It returns 0 tables, without any error, when specifying ‘get tables’ after setting the schema to hbase."_CELL_" or hbase."_ROW_".  It returns a confusing error message about object DUMMY__ when specifying ‘get tables in schema’ followed by hbase."_CELL_" or hbase."_ROW_".

This is seen on the v1208_0830 build installed on a workstation.

-----------------------------------------------------------------------------
Here is the entire script to reproduce this problem:

set schema hbase."_CELL_";
get tables;
get tables in schema hbase."_CELL_";
set schema hbase."_ROW_";
get tables;
get tables in schema hbase."_ROW_";

-----------------------------------------------------------------------------
Here is the execution output from sqlci:

>>set schema hbase."_CELL_";

--- SQL operation complete.
>>get tables;

--- SQL operation complete.
>>get tables in schema hbase."_CELL_";

*** ERROR[1389] Object DUMMY__ does not exist in Trafodion.

*** ERROR[8822] The statement was not prepared.

>>set schema hbase."_ROW_";

--- SQL operation complete.
>>get tables;

--- SQL operation complete.
>>get tables in schema hbase."_ROW_";

*** ERROR[1389] Object DUMMY__ does not exist in Trafodion.

*** ERROR[8822] The statement was not prepared.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)