[jira] [Created] (TRAFODION-777) LP Bug: 1394488 - Bulk load for volatile table gets FileNotFoundException

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-777:
------------------------------------

             Summary: LP Bug: 1394488 - Bulk load for volatile table gets FileNotFoundException
                 Key: TRAFODION-777
                 URL: https://issues.apache.org/jira/browse/TRAFODION-777
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Barry Fritchman
            Assignee: Barry Fritchman
             Fix For: 2.0-incubating


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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)