[
https://issues.apache.org/jira/browse/TRAFODION-278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14708652#comment-14708652
]
Atanu Mishra commented on TRAFODION-278:
----------------------------------------
Trafodion-Gerrit (neo-devtools) wrote on 2015-02-25: Fix proposed to core
(master) #3
Fix proposed to branch: master
Review: https://review.trafodion.org/1181
Trafodion-Gerrit (neo-devtools) wrote on 2015-02-25: Fix merged to core
(master) #4
Reviewed: https://review.trafodion.org/1181
Committed:
https://github.com/trafodion/core/commit/20c1470100060d32e38ba442fd45f794260d5fa8
Submitter: Trafodion Jenkins
Branch: master
commit 20c1470100060d32e38ba442fd45f794260d5fa8
Author: Barry Fritchman <email address hidden>
Date: Wed Feb 25 06:35:30 2015 +0000
Errors reported for Update Stats on Hive tables
Attempts to execute Update Statistics statements on Hive
tables fail with error 1002 (catalog does not exist). The
catalog used to store Hive stats was no longer being
successfully created on demand. The Trafodion catalog is
now used instead, with a schema for Hive stats created
in it on first use. The tables for histograms and
histogram intervals for Hive tables are created in that
schema on first use.
Change-Id: Ib57d0af4a3da6f52f0544d6c2fce3e77d2e823c1
Closes-Bug: #1320397
Changed in trafodion:
status: In Progress → Fix Committed
Julie Thai (julie-y-thai) wrote on 2015-04-14: #5
verified on Traf 1.1.0rc0 build:
SQL>update statistics for table hive.tpch2x.customer on every column;
--- SQL operation complete.
SQL>showstats for table hive.tpch2x.customer on existing columns;
Histogram data for Table HIVE.TPCH2X.CUSTOMER
Table ID: 0
Hist ID # Ints Rowcount UEC Colname(s)
========== ====== =========== =========== ===========================
1864945772 25 300000 25 C_NATIONKEY
1864945777 62 300000 300000 C_ADDRESS
1864945782 62 300000 300000 C_NAME
1864945787 48 300000 300000 C_CUSTKEY
1864945791 62 300000 280754 C_COMMENT
1864945796 5 300000 5 C_MKTSEGMENT
1864945801 36 300000 262499 C_ACCTBAL
1864945806 62 300000 300000 C_PHONE
--- SQL operation complete.
Changed in trafodion:
status: Fix Committed → Fix Released
> 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=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)
