cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to create bloom filter index

qwerty1
Contributor

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?

1 REPLY 1

Debayan
Esteemed Contributor III
Esteemed Contributor III

Hi, You can refer to https://issues.apache.org/jira/browse/SPARK-27617 for the above error.

Please let us know if this helps, also please tag @Debayan​ with your next response which will notify me, Thank you!

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.