[
https://issues.apache.org/jira/browse/TRAFODION-1018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suresh Subbiah closed TRAFODION-1018.
-------------------------------------
> LP Bug: 1423307 - PCode Expr Cache: alter-table-rename fails, ERROR[8448]
> HBASE_COPY_ERROR(710).
> --------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-1018
> URL: https://issues.apache.org/jira/browse/TRAFODION-1018
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Julie Thai
> Assignee: Apache Trafodion
> Priority: Blocker
> Fix For: 1.1 (pre-incubation)
>
>
> On cluster with PCEC_HQC_UTT build:
> >>alter table tab_emp_original_01 rename to tab_emp_new_01;
> *** ERROR[8448] Unable to access Hbase interface. Call to
> ExpHbaseInterface::copy() returned error HBASE_COPY_ERROR(710). Cause:
> org.apache.hadoop.hbase.TableNotFoundException:
> TRAFODION.JULSCH.TAB_EMP_ORIGINAL_01
> org.apache.hadoop.hbase.client.HBaseAdmin.checkTableExistence(HBaseAdmin.java:1033)
> org.apache.hadoop.hbase.client.HBaseAdmin.isTableDisabled(HBaseAdmin.java:1063)
> org.apache.hadoop.hbase.client.HBaseAdmin.isTableDisabled(HBaseAdmin.java:1072)
> org.trafodion.sql.HBaseAccess.HBaseClient.copy(HBaseClient.java:466)
> .
> --- SQL operation failed with errors.
> With HQC disabled:
> >>alter table tab_emp_original_01 rename to tab_emp_new_01;
> *** ERROR[8448] Unable to access Hbase interface. Call to
> ExpHbaseInterface::copy() returned error HBASE_COPY_ERROR(710). Cause:
> org.apache.hadoop.hbase.TableExistsException: TRAFODION.JULSCH.TAB_EMP_NEW_01
> org.apache.hadoop.hbase.client.HBaseAdmin.cloneSnapshot(HBaseAdmin.java:3004)
> org.apache.hadoop.hbase.client.HBaseAdmin.cloneSnapshot(HBaseAdmin.java:2988)
> org.trafodion.sql.HBaseAccess.HBaseClient.copy(HBaseClient.java:470)
> .
> --- SQL operation failed with errors.
> With PCEC and HQC disabled, system-wide:
> SQL>alter table tab_emp_original_01 rename to tab_emp_new_01;
> --- SQL operation complete.
> ====================================
> To reproduce, in sqlci issue:
> create table tab_emp_original_01
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> select * from tab_emp_original_01;
> showddl tab_emp_original_01;
> alter table tab_emp_original_01 rename to tab_emp_new_01;
> Assigned to LaunchPad User James Capps
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
