Bulk Loading a CSV Fails - No such file or directory

This document explains how to troubleshoot couple of problems in bulk loading data
Problem
Bulk loading fails with the following error message
com.sqrm.util.SqreamRunTimeException: execute error : open file <file_location> failed with error No such file or directory
Example
com.sqrm.util.SqreamRunTimeException: execute error : open file /home/user3/billing_fact.csv failed with error No such file or directory
Cause

  • Couple of issues can cause this problem:
  • CSV path isn't match to the bulk insert statement

CSV file name isn't match to the bulk insert statement (lower / upper case)
Solution

  • Check that the correct path is in the statement (use pwd command)
  • Check that the file name is identical to the statement

copy_trouble_shoot

  • 60
  • 01-Apr-2018
  • 792 Views