SELECT
"ir_id_P1Y_IncidentsOfType_complaint_sum",
"officer_id",
label_value
FROM "historical_features_daily"."ir_aggregation" f
JOIN results.predictions p ON f.officer_id=p.entity_id
WHERE model_id=493
AND p.as_of_date = '2015-08-01 00:00:00'
buth the query run is:
SELECT
"ir_id_p1y_incidentsoftype_complaint_sum",
"officer_id",
label_value
FROM "historical_features_daily"."ir_aggregation" f
JOIN results.predictions p ON f.officer_id=p.entity_id
WHERE model_id=493
AND p.as_of_date = '2015-08-01 00:00:00'
it is correct for the test set but not for the training
Eg the query should be:
buth the query run is:
it is correct for the test set but not for the training