Problem with group by clause

[uridiumabs]

Hi,

I have the following code in a script:

LOAD

  ID_COMMERCIAL_SITE,

  ID_PROVIDER,

  RECEPCION_DATE,

  SUM(NUM_LECTURAS)  AS IND_EFICIENCIA

RESIDENT LECTURAS

GROUP BY

  ID_COMMERCIAL_SITE,

  ID_PROVIDER,

  RECEPCION_DATE

I'm not getting aggregated data as you can see below:

ID_COMMERCIAL_SITE,  ID_PROVIDER,  RECEPCION_DATE,  IND_EFICIENCIA

49255,46747,2015-04-07,7

49255,46747,2015-04-07,7

49255,46747,2015-04-08,7

49255,46747,2015-04-01,7

49255,46747,2015-04-01,7

49255,46747,2015-04-01,7

49255,46747,2015-04-30,7

What I'm doing wrong?

Thank you very much.

[sunny_talwar · Accepted solution]

Is your RECEPCION_DATE a date field of timestamp field? May be you need to use Floor function to make it date.

LOAD ID_COMMERCIAL_SITE,

  ID_PROVIDER,

  RECEPCION_DATE,

  SUM(NUM_LECTURAS)  AS IND_EFICIENCIA

GROUP BY   ID_COMMERCIAL_SITE,  ID_PROVIDER, RECEPCION_DATE;

LOAD ID_COMMERCIAL_SITE,

  ID_PROVIDER,

  Date(Floor(RECEPCION_DATE)) as RECEPCION_DATE,

  NUM_LECTURAS

RESIDENT LECTURAS

[uridiumabs]

Thank you very much.

My script is working ok now.

[sunny_talwar]

Awesome, I am glad I was able to help