Quakes-in-Counties Hive Sample Empty Tables

[randallwhitman]

The run-sample.sql script for Hive generates empty tables for both counties and earthquakes, and so the join result is likewise empty. It appears that the LOCATION for CREATE TABLE is intended to be an NFS path, but Hive interprets it as an HDFS path. A developer could be expected to troubleshoot the script. Nevertheless, the sample could better be expected to work as published. Probably need to either create table first then load data infile; else upload data to HDFS first then create external table. I ran the script on Hive-0.12 and Hadoop-2.6, but I'd assume the same happens on newer versions. (Maybe the script worked on Hive-0.10 with which it was originally developed.)