I am just wondering has anybody come across the scenario where you need to import or read the data from excel to Hadoop? Is there such thing like Flume Excel source around? btw, I know I can convert the excel file to csv then deal with it. Really just trying to explore flume source a bit further here. ... View more

What are the prerequisites dor starting HWI on HDP 2.2 ... View more

I installed Hive ODBC Driver for HDP 2.2 on my windows 7 machine and trying to connect to hive through ODBC(hadoop istalled on CENTOS).I encoutered with following error. configs are all default. For example authentication for hiveserver2 is "none"(default).Is anything i missed out.I followed the document of hortoworks.I gave the server ip and port is 10000.I assumed hiveserver2 is running because beeline command line is working for following command beeline -u jdbc:hive2://ip:10000 ... View more

Hi All, According to my requirement i need script like following A = load '/bsuresh/sample' USING PigStorage(',') as (id,name,sal,deptid); B = GROUP A by deptid; C = foreach B { D = A.name,A.sal;--two fields E = DISTINCT D; generate group,COUNT(E); }; In relation 'D', i am extracting two fields.Where exactly i am facing error. If i chnaged the script like,which is working fine. C = foreach B { D = A.name; --one filed E = DISTINCT D; generate group,COUNT(E); }; But i need count based on distinct of two columns .Can any one help me?? ... View more