[
https://issues.apache.org/jira/browse/TRAFODION-1443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14680748#comment-14680748
]
Qifan Chen commented on TRAFODION-1443:
---------------------------------------
It looks like to build update stats for these native tables, we need a
description of these tables in Trafodion. Specifically, we need to store the
TABLE_UID of the alias table in SB_HISTOGRAMS table so that we know this stats
is for hive table FOO, and that stats is for HBase table BAR.
Right now, it is possible to update stats for a native HIVE table. But the
TABLE_UID of the SB_HISTOGRAM table is populated with 0s. That is incorrect
because value 0 is not sufficient to distinguish multiple tables, and in fact
the update stats for a different native hive table will fail.
>>--update statistics for table hive.hive.tee on b;
>>update statistics for table hive.hive.bar on c;
*** ERROR[2006] Internal error: assertion failure ((colNum >= 0) && (colNum <
numCols_)) in file at line -99999.
--- SQL operation failed with errors.
I'll put the work on hold, until the alias table feature for native hive and
base tables is in place.
> Update stats utility returns error when creating stats for native HBase tables
> ------------------------------------------------------------------------------
>
> Key: TRAFODION-1443
> URL: https://issues.apache.org/jira/browse/TRAFODION-1443
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 1.1 (pre-incubation)
> Reporter: Qifan Chen
> Assignee: Qifan Chen
>
> The errors are as follows.
> >>update statistics for table hbase."_CELL_"."foo" on row_id;
> *** ERROR[9200] UPDATE STATISTICS for table HBASE._CELL_.foo encountered an
> error (4222) from statement Create SeaBase histograms table.
> *** ERROR[4222] The DDL feature is not supported in this software version.
> *** ERROR[8822] The statement was not prepared.
> --- SQL operation failed with errors.
> =========
> >>update statistics for table hbase."_CELL_"."foo" on every column;
> *** ERROR[9200] UPDATE STATISTICS for table HBASE._CELL_.foo encountered an
> error (4222) from statement Create SeaBase histograms table.
> *** ERROR[4222] The DDL feature is not supported in this software version.
> *** ERROR[8822] The statement was not prepared.
> --- SQL operation failed with errors.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
