Uitvoering van de volgende query:
select max(DAILY_LIMIT) daily_limit_max
, min(DAILY_LIMIT) daily_limit_min
, max(DAILY_REMAINING) daily_remaining_max
, min(DAILY_REMAINING) daily_remaining_min
, avg(DAILY_REMAINING) daily_remaining_avg
, stddev(DAILY_REMAINING) daily_remaining_sd
from SystemPartitions@datadictionary
where provider_data_container_alias = 'eol'
geeft:
itgenrst004
The type of the actual data must match the data type of the column ‘DAILY_REMAINING_AVG’ in ‘’.
Ensure that the actual data data type (currently ‘Double’) in row #1 is cast to the data type (currently ‘int64’).
DAILY_REMAINING_AVG (Double, metadata int64): 4993, DAILY_LIMI…a int64): 4993, DAILY_REMAINING_SD (Double, metadata double): 0