Create a gist now

Instantly share code, notes, and snippets.

Word count using Hive
Hello
World
Bye
World
CREATE TABLE words(word STRING);
LOAD DATA LOCAL INPATH 'C:\Temp\wordcount\InputData.txt' OVERWRITE INTO TABLE words;
SELECT word, count(*) FROM words GROUP BY word;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment