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 2015/10/05 17:59:26 UTC
[jira] [Assigned] (TRAFODION-777) LP Bug: 1394488 - Bulk load for
volatile table gets FileNotFoundException
[ https://issues.apache.org/jira/browse/TRAFODION-777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah reassigned TRAFODION-777:
----------------------------------------
Assignee: Suresh Subbiah (was: Barry Fritchman)
> 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: Suresh Subbiah
> 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)