/InputData.txt
Created Jan 1, 2013
| 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; |
This comment has been minimized.
Show comment
Hide comment
This comment has been minimized.
Show comment
Hide comment
SundarHadoopDeveloper
commented
May 19, 2018
|
Hi, The WordCount is working fine, but its consider whole line as a Word, if i want to count the words in each line then what is the HQL query??? |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hi, The WordCount is working fine, but its consider whole line as a Word, if i want to count the words in each line then what is the HQL query???