The system I am running this from has an older version of Hive so excuse me if this is already addressed. I am attempting to run this query.
CREATE external TABLE webservers_2009_01_25_web1_log_a (,... referer STRING) row format delimited fields terminated by '\031' stored as TEXTFILE LOCATION '/user/ecapriolo/storage/2009-01-25/webservers/web1.log' I understand that external table needs to be pointed at a directory not a file. However it would be useful to point to a file rather than a directory.
