question Bug in LAB 3 - PIG RISK FACTOR ANALYSIS in Archives of Support Questions (Read Only)

Bug in LAB 3 - PIG RISK FACTOR ANALYSIS

dev_abhi_verma — Mon, 26 Dec 2016 08:07:12 GMT

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;

Re: Bug in LAB 3 - PIG RISK FACTOR ANALYSIS

kevinjackswi — Sat, 04 Feb 2017 15:42:22 GMT

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

dstroer — Fri, 17 Feb 2017 00:44:34 GMT

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.