Support Questions
Find answers, ask questions, and share your expertise

Bug in LAB 3 - PIG RISK FACTOR ANALYSIS

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

Accepted Solutions

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

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.

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