Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

CrushCity2017 avatar image
CrushCity2017 asked Erick Ramirez edited

Getting error when querying Astra DB with pyspark

When trying to query a table on Astra via pyspark, we are getting the below error:

An error occurred while calling o95.load. No SELECT permission on <table system.size_estimates>

We are trying to load the data into a dataframe from our pyspark code (below):

df = spark.read
  .format("org.apache.spark.sql.cassandra")
  .options(table='table', keyspace='keyspace')
  .load()

Of course keyspace and table are replaced with their actual values. We are using an API R/W token which should have read access to ALL keyspaces and there is nowhere to alter these permissions, which is why I am at a loss for what to look at here.

astra
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

CrushCity2017 avatar image
CrushCity2017 answered

Looks like the token was the issue here. I issued a new token and it works fine.

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.