[
https://issues.apache.org/jira/browse/TRAFODION-3007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16410682#comment-16410682
]
ASF GitHub Bot commented on TRAFODION-3007:
-------------------------------------------
Github user andyyangcn commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1492#discussion_r176620828
--- Diff: core/sql/ustat/hs_parser.cpp ---
@@ -243,13 +243,6 @@ Lng32 AddTableName( const hs_table_type type
}
else
{
- // This is for UPDATE STATISTICS; the volatile schema name
exists.
- // For now, UPDATE STATISTICS is not supported. (See also JIRA
Trafodion-2004.)
-
- HSFuncMergeDiags(-UERR_VOLATILE_TABLES_NOT_SUPPORTED);
- retcode = -1;
- HSHandleError(retcode); // causes a return from this function
-
// The code below is old code that will be needed once we turn
on
// support for UPDATE STATISTICS on volatile tables. We leave
it here
--- End diff --
Thanks Dave. SB_HISTOGRAM* table in the volatile schema gets dropped when
the schema gets dropped. I had tested that.
> update statistics report error on volatile table
> ------------------------------------------------
>
> Key: TRAFODION-3007
> URL: https://issues.apache.org/jira/browse/TRAFODION-3007
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: Yang, Yongfeng
> Assignee: Yang, Yongfeng
> Priority: Major
>
> SQL>update statistics for table ttt on every column;
> *** ERROR[9247] UPDATE STATISTICS is not supported on volatile tables
> presently.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
