Support Questions

Find answers, ask questions, and share your expertise

Bug in LAB 3 - PIG RISK FACTOR ANALYSIS

avatar
New Contributor

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;

1 ACCEPTED SOLUTION

avatar
New Contributor

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.

View solution in original post

2 REPLIES 2

avatar
New Contributor

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.

avatar
New Contributor

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.