Analytics: Dates are not being represented correctly

16613
Reporter: trobertson
Type: Bug
Summary: Analytics: Dates are not being represented correctly
Priority: Critical
Status: Open
Created: 2014-11-05 15:59:52.875
Updated: 2014-11-06 09:12:35.45
        
Description: On the temporal precision on the Belgium data pages [1], there is a significant drop during 2014, which is incorrect.  It is possible this relates to http://dev.gbif.org/issues/browse/POR-2339 but requires investigation, fixing, and rerunning of the charts.

We have reason to believe the data is correct, but the charts are inaccurate.  Additionally, the following query which returns 0 for all suggests data are correct in the live index, suggesting this is isolated to the interpreting in the analytics only.
{code}
SELECT
datasetKey,
SUM(CASE year WHEN NULL THEN 1 ELSE 0 END) AS withoutYear,
SUM(CASE month WHEN NULL THEN 1 ELSE 0 END) AS withoutMonth,
SUM(CASE day WHEN NULL THEN 1 ELSE 0 END) AS withoutDay
FROM occurrence_hdfs
WHERE countryCode='BE'
GROUP BY datasetKey
{code}

[1] http://www.gbif.org/analytics/country/BE/about]]>