Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Bug in LAB 3 - PIG RISK FACTOR ANALYSIS

Solved Go to solution

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

Re: Bug in LAB 3 - PIG RISK FACTOR ANALYSIS

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.

2 REPLIES 2

Re: Bug in LAB 3 - PIG RISK FACTOR ANALYSIS

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.

Re: Bug in LAB 3 - PIG RISK FACTOR ANALYSIS

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.

Don't have an account?
Coming from Hortonworks? Activate your account here