Earliest/Latest for not null/empty

Hi,
I am very new on druid so forgive my ignorance.

I’ve decided to test druid as a possible alternative to better optimize our reports. On mysql we have a schema like this
`
Client | OrderID | ChargeAmount | Status | CityId | …