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

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

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