You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:15:17 UTC
[jira] [Created] (TRAFODION-230) LP Bug: 1308749 - Update
statistics sees errors 9214/9215/20123/4222
Alice Chen created TRAFODION-230:
------------------------------------
Summary: 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
Assignee: Barry Fritchman
Priority: Critical
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)