Group by in Load

[#1]

Hi!,

I havbe a problem when i include a sentence group by in a load sentence, give a error but i don't understand why,

udp_hh:

LOAD
@IdUserDaily,
  COMPANY,
  WORKGROUP,
  @Fecha,
  HORA_MIN,
USERNAME,
trim(upper(USERNAME)) as RUT,
SUM(TIMEUSERLOGGEDIN) as TIMEUSERLOGGEDIN ,
  FULLNAME

FROM $(PathQvd)user_daily_????.qvd (qvd)
WHERE COMPANY='LIPIGAS'
GROUP BY USERNAME
;

please help me, thanks a lot!

[#2]

You have to group all the columns that you did not execute any calculation such as Count, Sum etc..

Exemple:

LOAD A, B, SUM(C), COUNT(D)

FROM X

GROUP BY A, B

Best.