cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
DELETE
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

unable to execute hll_sketch_estimate built in function from databricks notebook

saras
New Contributor

Tried example from databricks doc https://docs.databricks.com/sql/language-manual/functions/hll_sketch_agg.html

%sql

SELECT hll_sketch_estimate(hll_sketch_agg(col, 12)) FROM VALUES (1), (1), (2), (2), (3) tab(col);

it fails with

AnalysisException: Undefined function: hll_sketch_estimate. This function is neither a built-in/temporary function, nor a persistent function that is qualified as spark_catalog.default.hll_sketch_estimate.; line 1 pos 7

How to execute hll functions from notebook?

1 REPLY 1

sean_owen
Honored Contributor II

That was added in runtime 13.1. Are you using 13.1?

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group