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

Errors on Redash when queries are in cache

368545
New Contributor III

We got the following error when running queries on Redash connected to

Databricks early today (2022-08-24):

```

Error running query: [HY000] [Simba][Hardy] (35) Error from server:

error code: '0' error message:

'org.apache.spark.sql.catalyst.expressions.UnsafeRow cannot be cast to

org.apache.spark.sql.Row'. (35) (SQLFetch)

```

This happened when the result was cache. If the query was new then

Redash can get the result.

The query works fine on Databricks SQL editor.

Any idea on how to resolve this? This happened early today (2022-08-24), before that it worked fine.

The Redash version we are using is v10.0.0 (9c928bd).

1 ACCEPTED SOLUTION

Accepted Solutions

368545
New Contributor III

It got fixed last week from Databricks.

There was no problem with the permission, since if the query not hit the cache, then we could get the result. We had to add some workarounds with `select random(), * from table` instead of `select * from table`.

View solution in original post

4 REPLIES 4

Debayan
Esteemed Contributor III
Esteemed Contributor III

This can be related to user permission, particularly necessary permission to access the table in the database instance. I understand in SQL editor it is working fine, still can we check the permissions?

368545
New Contributor III

It got fixed last week from Databricks.

There was no problem with the permission, since if the query not hit the cache, then we could get the result. We had to add some workarounds with `select random(), * from table` instead of `select * from table`.

Kaniz
Community Manager
Community Manager

Hi @Dat Tran​, Thank you for coming back with a solution. We're grateful to have community members like you. I'm marking your answer as the best. Please confirm.

Kaniz
Community Manager
Community Manager

Hi @Dat Tran​, We haven't heard from you on the last response from @Debayan Mukherjee​, and I was checking back to see if his suggestions helped you.

Or else, If you have any solution, please share it with the community as it can be helpful to others.

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.

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.