[
https://issues.apache.org/jira/browse/TRAFODION-777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suresh Subbiah updated TRAFODION-777:
-------------------------------------
Fix Version/s: (was: 2.2.0)
2.4
> 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
> Priority: Major
> Fix For: 2.4
>
>
> 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
(v7.6.3#76005)
