Sundar1906

CREATE TABLE Wcount(words STRING);
LOAD DATA LOCAL INPATH '/home/skumares/InputData.txt' OVERWRITE INTO TABLE Wcount;
Select wc,count(*) from(Select explode(split(words,' ')) from Wcount) p group by wc;