Stupid script error

[Broly]

Hi guys,

It is late and I am going to sleep now, but I get this error:

The following error occurred:

Invalid expression

test:
load
SHIPMENT_ID,
Min(MinLoadTime) as MinLoadTimeUG
Resident
bi_shipments
Group by DepotID,H_ROUTE_NAME,ORDER_EXECUTION_DATE
Order by DepotID,H_ROUTE_NAME,LASTACTION_TIME_DATA_SOURCE asc
;

The following error occurred:

Invalid expression

Can someone tell me what is wrong?

Thank you, and good night

[MayilVahanan · Accepted solution]

Hi @Broly 

You need to include "SHIPMENT_ID" in the "group by" to avoid the issue. 

Can you explain, why you mentioned many field in the group by?

[PrashantSangle]

you need to include only non aggregated fields which are using resident table. try below code

Test:
load
SHIPMENT_ID,
Min(MinLoadTime) as MinLoadTimeUG
Resident
bi_shipments
Group by SHIPMENT_ID
Order by SHIPMENT_ID asc
;