Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Quakes-in-Counties Hive Sample Empty Tables #57

Open
randallwhitman opened this issue Jul 17, 2017 · 0 comments
Open

Quakes-in-Counties Hive Sample Empty Tables #57

randallwhitman opened this issue Jul 17, 2017 · 0 comments
Labels

Comments

@randallwhitman
Copy link
Contributor

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.)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant