Hi,
I was trying to do a MAX(TIMESTAMP_FIELD). and the job is failing with the error "No default type conversion from type "timestamp" to type "dfloat"."
Pls help me in resolving this.
Thanks in advance.
aggregator issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Hi cparru,
The aggregator stage only accept numeric fields (integer, decimal, float, ect), and the result is dfloat, always, so, you must to make a conversion to the source field.
Example:
2009-08-10 08:19:01 convert to
20090810081901. with this number you must to apply the MAX. The result must be reformated to the timestamp format.
i had a problem to obtain max, min for strings and dates fields, i discovered the reason, the aggregator dont work with that datatypes.
i hope this help.
The aggregator stage only accept numeric fields (integer, decimal, float, ect), and the result is dfloat, always, so, you must to make a conversion to the source field.
Example:
2009-08-10 08:19:01 convert to
20090810081901. with this number you must to apply the MAX. The result must be reformated to the timestamp format.
i had a problem to obtain max, min for strings and dates fields, i discovered the reason, the aggregator dont work with that datatypes.
i hope this help.
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru