[
https://issues.apache.org/jira/browse/TRAFODION-1443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14876863#comment-14876863
]
Qifan Chen commented on TRAFODION-1443:
---------------------------------------
I committed a fix minutes ago. The summary of the change is as follows.
0. No change to the syntax and semantics of the update stats utility for
native tables.
1. Use of External Tables as aliases to native tables, in the context of
creating histogram IDs. The IDs used are actually those of the external tables.
2. The histogram tables for native tables are stored in schema
TRAFODION._HBASESTATS_ and TRAFODION._HIVESTATS_, respectively. There is no
change to the location of the histogram tables for Trafodion tables.
3. The restriction that a new table can not be created LIKE an external table
is removed. This facilitates the creation of sample tables for the native tables
4. The column stats for native tables now behave exactly the same as for
Trafodion tables (which leads to many changes in the expected files for
regression/hive).
5. A work-around (disable PCODE for one query) is added to EXECUCTOR/TEST002.
Without it, the compilation runs away in PCODE optimization.
6. TPC-DS data now is converted to UTF8 before loading into the HIVE tables.
This is to fix a character set conversion error when the source string is "Côte
d'Ivoire". The hex code for the 2nd character in the un-converted string is
0xd4, not exactly a valid UTF8 character. After the conversion, the character
is encoded with 2 bytes.
7. Two new tests added: seabase/TEST028 (update stats for native HBase tables),
and hive/TEST021 (update stats for native hive tables - in TPC-DS)
> 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)
