[
https://issues.apache.org/jira/browse/TRAFODION-278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-278.
----------------------------------
Resolution: Fixed
Assignee: (was: Barry Fritchman)
> 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
> 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=tha...@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)
