Interface DatamartContext.DataProfilerResult

  • Enclosing interface:
    DatamartContext

    public static interface DatamartContext.DataProfilerResult
    • Method Detail

      • getDimensions

        ResultMatrix getDimensions()
        Returns:
        ResultMatrix with a row for each dimension profiled. Columns are

        • "Min": Lowest value according to the natural order of the dimension field type (String, Date...)
        • "Max": Lowest value according to the natural order of the dimension field type (String, Date...)
        • "#": Number of values in total (matching the number of rows in the query result set)
        • "#Nulls" Number of rows with a null value (i.e. missing value)
        • "#Distinct": Number of distinct values
        • "Sample": The first 10 such values

      • getMeasures

        ResultMatrix getMeasures()
        Returns:
        ResultMatrix with a row for each numeric projection profiled. Columns are

        • "Min": Lowest value
        • "Max": Highest value
        • "Mean": The population' mean or average value
        • "Std"": The population's standard deviation
        • "#": Number of values in total (matching the number of rows in the query result set)
        • "#Nulls" Number of rows with a null value (i.e. missing value)

      • getMap

        Map<String,​Object> getMap()
        All the results in map format, for fluent access in Groovy
        Returns:
        Map containing entries ."Sample", ."Mean" etc.