[ 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)