Unable to create bloom filter index

qwerty1
Contributor

‎05-29-2023 03:56 AM

I am unable to create bloom filter index on my table

CREATE BLOOMFILTER INDEX ON TABLE my_namespace.foo FOR COLUMNS (id OPTIONS (fpp = 0.1, numItems = 6000000))

Gives the error

AnalysisException: Table `spark_catalog`.`my_namespace`.`foo` did not specify locationUri.

What does this mean?

Labels:
0 Kudos