title: Hive - How to load data from a file with filename as a column?
body: <p>I am running the following commands to create my table ABC and insert data from all files that are in my designated file path.  Now I want to add a column with filename, but I can't find any way to do that without looping through the files or something.  Any suggestions on what the best way to do this would be?</p>
  
  <pre><code>CREATE TABLE ABC
  (NAME string
  ,DATE string
  )
  ROW FORMAT DELIMITED 
  FIELDS TERMINATED BY '\t' 
  STORED AS TEXTFILE;
  
  hive -e "LOAD DATA LOCAL INPATH '${DATA_FILE_PATH}' INTO TABLE ABC;"
  </code></pre>