Bug in LAB 3 - PIG RISK FACTOR ANALYSIS

[#1]

There is a bug in Lab 3.

Instead of "CREATE TABLE riskfactor (driverid string,events bigint,totmiles bigint,riskfactor float)

STORED AS ORC;"

it should be defined as "CREATE TABLE riskfactor (driverid string,events bigint,totmiles double,riskfactor float)

STORED AS ORC;

[#2]

I can confirm this. My Pig script was throwing an error in the logs and the data wasn't being loaded into Hive. Dropping the table with the statement "DROP TABLE riskfactor;" and recreating the riskfactor table in Hive as shown above resolved this issue and the Pig script was able to execute properly and load the data into Hive.

[#3 · Accepted solution]

Agreed, completely following tutorial, I was getting the same error. Dropping the table and re-adding with double type allowed the pig script to execute.