[jira] [Created] (TRAFODION-278) LP Bug: 1320397 - update statistics for hive table reports ERROR[9200], ERROR[1002]

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

Alice Chen created TRAFODION-278:
------------------------------------

             Summary: LP Bug: 1320397 - update statistics for hive table reports ERROR[9200], ERROR[1002]
                 Key: TRAFODION-278
                 URL: https://issues.apache.org/jira/browse/TRAFODION-278
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Julie Thai
            Assignee: Barry Fritchman
            Priority: Critical
             Fix For: 1.1 (pre-incubation)


>>select count(*) from hive.hive.nation;

(EXPR)
--------------------

                  25

--- 1 row(s) selected.
>>
>>cqd ustat_log 'updstat_hive';

--- SQL operation complete.
>>update statistics log on;

--- SQL operation complete.
>>update statistics for table hive.hive.nation on every column;

*** ERROR[9200] UPDATE STATISTICS for table HIVE.HIVE.NATION encountered an error (1002) from statement Process_Query.

*** ERROR[1002] Catalog HIVESTATS does not exist or has not been registered on node .

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

--- SQL operation failed with errors.
>>update statistics for table hive.hive.mynation on every column;

*** ERROR[9200] UPDATE STATISTICS for table HIVE.HIVE.MYNATION encountered an error (1002) from statement Process_Query.

*** ERROR[1002] Catalog HIVESTATS does not exist or has not been registered on node .

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

--- SQL operation failed with errors.
>>update statistics log off;

--- SQL operation complete.
>>log off;

encountered on workstation, datalake_64_1 v40596
MY_SQROOT=/opt/home/thaiju/datalake_64_1
who@host=thaiju@g4t3029.houston.hp.com
JAVA_HOME=/opt/home/tools/jdk1.7.0_09_64
linux=2.6.32-279.el6.x86_64
redhat=6.3
Release 0.7.0 (Build release [40596], branch 40596-project/datalake_64_1, date 16May14)

to reproduce, see attached hive_updstats.tar contents:
1. in hive, create and load tables nation/mynation; see hive_setup and nation.tbl files
2. in sqlci, obey traf.sql



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