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
Databricks Employee
Databricks Employee

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