This is my script and i have also a table called riskfactor in Hive . a = LOAD 'geolocation' using org.apache.hive.hcatalog.pig.HCatLoader(); b = filter a by event != 'normal'; c = foreach b generate driverid, event, (int) '1' as occurance; d = group c by driverid; e = foreach d generate group as driverid, SUM(c.occurance) as t_occ; g = LOAD 'drivermileage' using org.apache.hive.hcatalog.pig.HCatLoader(); h = join e by driverid, g by driverid; final_data = foreach h generate $0 as driverid, $1 as events, $3 as totmiles, (float) $3/$1 as riskfactor; store final_data into 'riskfactor' using org.apache.hive.hcatalog.pig.HCatStorer(); When i execute this pig script it shows me that error and not saving any data. I did step by step everything it says here : https://hortonworks.com/hadoop-tutorial/hello-world-an-introduction-to-hadoop-hcatalog-hive-and-pig/#section_5 ... View more

I am a begineer to Hadoop and im taking Hortonworks Sandbox tutorials . Ambari server runs so slow , hive , pig , every job every service , it loads and run very very slow , example if i run a simple select query of 10 rows , it takes tike to execute . My question is : is it okay with this , or do i have to install specific tools for different tasks ,like i`ve seen a tutorial when it is saying that qyering with beeline tool is faster , or do i have to execute everything with Putty , or to continue working in Ambari server http://localhost:8080/ . I appriciate every explanation . Thanks for time . ... View more

When attempting to browse to port 4200 WebSSH on HDP Sandbox, the connection is refused : This site can’t be reached We can SSH using Putty to port 22 and 2222, and can reach all other ports like 8080, 8088, 50070, etc. ... View more