While executing the pig script in LAB3 in "Sandbox tutorial/Hello World/Getting Started with HDP (2.5.0)" I've encountered error as shown below. Any help is appreciated.

[#1]

When exuting the pig script in this tutorial I've encountered error as shown above. Any help is appreciated.

[main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 0: Output Location Validation Failed for: 'riskfactor More info to follow: Pig 'double' type in column 2(0-based) cannot map to HCat 'BIGINT'type. Target filed must be of HCat type {DOUBLE} Details at logfile: /hadoop/yarn/local/usercache/admin/appcache/application_1475025935138_0008/container_1475025935138_000

[#2 · Accepted solution]

Resolved after following the below:

"You can try changing the data type of totmiles variable to double. Drop the table riskfactor from HIve and create it again with:

drop table riskfactor;

CREATE TABLE riskfactor (driverid string,events bigint,totmiles double,riskfactor float) STORED AS ORC;" Thanks to suggestion from @Michael Young and @mrizvi.

[#3]

FYI: I've created a pull request on the docs for this. https://github.com/hortonworks/tutorials/pull/176