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?

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local communityโ€”sign up today to get started!

Sign Up Now