[
https://issues.apache.org/jira/browse/TRAFODION-230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-230.
----------------------------------
Resolution: Fixed
Assignee: (was: Barry Fritchman)
Fix Version/s: 0.8 (pre-incubation)
> LP Bug: 1308749 - Update statistics sees errors 9214/9215/20123/4222
> --------------------------------------------------------------------
>
> Key: TRAFODION-230
> URL: https://issues.apache.org/jira/browse/TRAFODION-230
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Weishiun Tsai
> Priority: Critical
> Fix For: 0.8 (pre-incubation)
>
>
> When running update statistics on the following table, it returns errors
> 9214/9215/20123/4222. This is pretty reproducible right now on the beta
> build v39140 installed on the cluster centos-mapr1. To produce this problem
> will require the QA g_tpcds1x global tables to be created first.
> >>create table sb_customer
> +>(
> +>c_customer_sk integer not null,
> +>c_customer_id char(16) not null,
> +>c_current_cdemo_sk integer ,
> +>c_current_hdemo_sk integer ,
> +>c_current_addr_sk integer ,
> +>c_first_shipto_date_sk integer ,
> +>c_first_sales_date_sk integer ,
> +>c_salutation char(10) ,
> +>c_first_name char(20) not null,
> +>c_last_name char(30) not null,
> +>c_preferred_cust_flag char(1) ,
> +>c_birth_day integer ,
> +>c_birth_month integer ,
> +>c_birth_year integer ,
> +>c_birth_country varchar(20) ,
> +>c_login char(13) ,
> +>c_email_address char(50) ,
> +>c_last_review_date char(10) ,
> +>primary key (c_customer_sk, c_last_name, c_first_name)
> +>);
> --- SQL operation complete.
> >>
> >>upsert using load into sb_customer (select * from
> >>trafodion.g_tpcds1x.customer where c_customer_sk is not null and
> >>c_last_name is not null and c_first_name is not null);
> --- 94760 row(s) inserted.
> >>
> >>select count(*) from trafodion.g_tpcds1x.customer;
> (EXPR)
> --------------------
> 100000
> --- 1 row(s) selected.
> >>select count(*) from sb_customer;
> (EXPR)
> --------------------
> 94760
> --- 1 row(s) selected.
> >>
> >>update statistics for table sb_customer on every column, (C_CUSTOMER_SK,
> >>C_LAST_NAME, C_BIRTH_DAY) sample;
> *** ERROR[9214] Object
> TRAFODION.PUBLIC_ACCESS_SCHEMA.SQLMX_37187003981691445_1397679531_607967
> could not be created.
> *** ERROR[20123] A user-defined transaction has been started. This DDL
> operation cannot be performed.
> *** ERROR[9215] UPDATE STATISTICS encountered an internal error (from
> TRAFODION.PUBLIC_ACCESS_SCHEMA.SQLMX_37187003981691445_1397679531_607967,
> with return value=). Details: ."
> *** ERROR[4222] The ALTER 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)
