Created 12-26-2016 12:07 AM
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;
Created 02-16-2017 04:44 PM
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.
Created 02-04-2017 07:42 AM
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.
Created 02-16-2017 04:44 PM
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.