Hive wordcount problem error

Posts: 2
Joined: Tue Nov 24, 2015 10:16 am

Hive wordcount problem error

Postby vinayps91 » Tue Mar 15, 2016 9:24 am

Error:java.lang.RuntimeException:org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row (tag=0) {"key":{"_col0":"(UN)"},"value":{"_col0":1},"alias":0}

select WORD,COUNT(*) from wc LATERAL VIEW EXPLODE(SPLIT(text, ' ')) temptable as word GROUP BY word;

Text in file:-
The United Nations (UN) is an intergovernmental organisation established on 24 October 1945 to promote international cooperation. A replacement for the ineffective League of Nations, the organisation was created following World War II to prevent another such conflict. At its founding, the UN had 51 member states; there are now 193. The UN Headquarters resides in international territory in New York City, with further main offices in Geneva, Nairobi, and Vienna.


Return to “Big Data & Hadoop”



Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.