We hawe IRIS Data Platform as Data Warehouses with installed UDAF (isc-aa-udaf 1.2.0) on namespase. In cube data preview we try to visualise distribution of measure by 2 dimensions. AtScale automatically generates a request that involves the hll_estimate function, and we get " User defined SQL function 'SQLUSER.HLL_ESTIMATE' does not exist" error.
The peculiarity of the query is that one of the dimensions (date) is defined in one table, and the other (group) is defined in another table. The relationship was created by the record ID from the second table (for one record in the second table, there are many records in the first). Accordingly, for each of the 4 million records from the first table, a check is made to which group the associated record from the first table belongs.
We hawe IRIS Data Platform as Data Warehouses with installed UDAF (isc-aa-udaf 1.2.0) on namespase. In cube data preview we try to visualise distribution of measure by 2 dimensions. AtScale automatically generates a request that involves the hll_estimate function, and we get " User defined SQL function 'SQLUSER.HLL_ESTIMATE' does not exist" error.
The peculiarity of the query is that one of the dimensions (date) is defined in one table, and the other (group) is defined in another table. The relationship was created by the record ID from the second table (for one record in the second table, there are many records in the first). Accordingly, for each of the 4 million records from the first table, a check is made to which group the associated record from the first table belongs.