You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2016/06/02 17:44:59 UTC
[jira] [Commented] (TRAFODION-1128) LP Bug: 1439779 - Internal
error when load command is used on non-default schema
[ https://issues.apache.org/jira/browse/TRAFODION-1128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15312745#comment-15312745 ]
Suresh Subbiah commented on TRAFODION-1128:
-------------------------------------------
This happens only when the table has an index.
This script can be used to reproduce the problem
-- from hive create this table
create table b1 (a int, b int) ;
create schema sch;
set schema sch;
create table tt1 ( a int not null, b int not null, primary key (a,b));
create index tt1_ix on tt1(b) ;
upsert into tt1 values (1,1);
insert into hive.hive.b1 select * from tt1 ;
set schema seabase ;
load into sch.tt1 select * from hive.hive.b1 ;
-- SQL operation complete.
>>load into sch.tt1 select * from hive.hive.b1 ;
Task: LOAD Status: Started Object: TRAFODION.SCH.TT1
Task: CLEANUP Status: Started Object: TRAFODION.SCH.TT1
Task: CLEANUP Status: Ended Object: TRAFODION.SCH.TT1
Task: DISABLE INDEXE Status: Started Object: TRAFODION.SCH.TT1
*** ERROR[2006] Internal error: assertion failure (schemaNamePart == currSchName) in file at line -99999.
*** ERROR[8839] Transaction was aborted.
--- 0 row(s) loaded.
If index is dropped, problem is not seen.
>>drop index sch.tt1_ix ;
--- SQL operation complete.
>>fc load
>>load into sch.tt1 select * from hive.hive.b1 ;
..
Task: LOAD Status: Started Object: TRAFODION.SCH.TT1
Task: CLEANUP Status: Started Object: TRAFODION.SCH.TT1
Task: CLEANUP Status: Ended Object: TRAFODION.SCH.TT1
Task: PREPARATION Status: Started Object: TRAFODION.SCH.TT1
Rows Processed: 1
Task: PREPARATION Status: Ended ET: 00:00:02.463
Task: COMPLETION Status: Started Object: TRAFODION.SCH.TT1
Task: COMPLETION Status: Ended ET: 00:00:04.382
--- 1 row(s) loaded.
>>cqd
> LP Bug: 1439779 - Internal error when load command is used on non-default schema
> --------------------------------------------------------------------------------
>
> Key: TRAFODION-1128
> URL: https://issues.apache.org/jira/browse/TRAFODION-1128
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Suresh Subbiah
> Assignee: Suresh Subbiah
> Fix For: 2.1-incubating
>
>
> set schema sch ;
> >>load into G_TPCH2X.customer1 select * from hive.hive.customer ;
> ..
> Task: LOAD Status: Started Object: TRAFODION.G_TPCH2X.CUSTOMER1
> Task: CLEANUP Status: Started Object: TRAFODION.G_TPCH2X.CUSTOMER1
> Task: CLEANUP Status: Ended Object: TRAFODION.G_TPCH2X.CUSTOMER1
> Task: DISABLE INDEXE Status: Started Object: TRAFODION.G_TPCH2X.CUSTOMER1
> *** ERROR[2006] Internal error: assertion failure (schemaNamePart == currSchName) in file at line -99999.
> Problem is easy to reproduce and should happen with any table. If the source table is on a schema that is different from the current default schema then this error is seen.
> It is interesting to note that the following statement does NOT raise this error
> >>load with no populate indexes into G_TPCH2X.customer1 select * from hive.hive.customer ;
> Task: LOAD Status: Started Object: TRAFODION.G_TPCH2X.CUSTOMER1
> Task: CLEANUP Status: Started Object: TRAFODION.G_TPCH2X.CUSTOMER1
> Task: CLEANUP Status: Ended Object: TRAFODION.G_TPCH2X.CUSTOMER1
> Task: PREPARATION Status: Started Object: TRAFODION.G_TPCH2X.CUSTOMER1
> ....
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)