[ 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)