Bulk load for volatile table gets FileNotFoundException

Bug #1394488 reported by Barry Fritchman
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
In Progress
Medium
Barry Fritchman

Bug Description

When attempting to perform a bulk load into a volatile table, like this:

create volatile table vps primary key (ps_partkey, ps_suppkey) no load as select * from partsupp;
cqd comp_bool_226 'on';
cqd TRAF_LOAD_PREP_TMP_LOCATION '/bulkload/';
cqd TRAF_LOAD_TAKE_SNAPSHOT 'OFF';
load into vps select * from partsupp;

An error 8448 is raised due to a java.io.FileNotFoundException:

>>>>Task: LOAD Status: Started Object: TRAFODION.HBASE.VPS
Task: CLEANUP Status: Started Object: TRAFODION.HBASE.VPS
Task: CLEANUP Status: Ended Object: TRAFODION.HBASE.VPS
Task: DISABLE INDEXE Status: Started Object: TRAFODION.HBASE.VPS
Task: DISABLE INDEXE Status: Ended Object: TRAFODION.HBASE.VPS
Task: PREPARATION Status: Started Object: TRAFODION.HBASE.VPS
       Rows Processed: 1600000
Task: PREPARATION Status: Ended ET: 00:01:20.660
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.VPS

*** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::doBulkLoad returned error HBASE_DOBULK_LOAD_ERROR(-714). Cause:
java.io.FileNotFoundException: File /bulkload/TRAFODION.HBASE.VPS does not exist.
org.apache.hadoop.hdfs.DistributedFileSystem.listStatusInternal(DistributedFileSystem.java:654)
org.apache.hadoop.hdfs.DistributedFileSystem.access$600(DistributedFileSystem.java:102)
org.apache.hadoop.hdfs.DistributedFileSystem$14.doCall(DistributedFileSystem.java:712)
org.apache.hadoop.hdfs.DistributedFileSystem$14.doCall(DistributedFileSystem.java:708)
org.apache.hadoop.fs.FileSystemLinkResolver.resolve(FileSystemLinkResolver.java:81)
org.apache.hadoop.hdfs.DistributedFileSystem.listStatus(DistributedFileSystem.java:708)
org.trafodion.sql.HBaseAccess.HBulkLoadClient.doBulkLoad(HBulkLoadClient.java:442)

It appears that the presumed qualification of the volatile table name is incorrect.

Tags: sql-cmp
Changed in trafodion:
milestone: none → r2.0
tags: added: sql-cmp
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.