topic Re: Errors on Redash when queries are in cache in Data Engineering

Errors on Redash when queries are in cache

368545 — Wed, 24 Aug 2022 09:24:36 GMT

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).

Re: Errors on Redash when queries are in cache

368545 — Fri, 02 Sep 2022 14:16:16 GMT

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`.

Re: Errors on Redash when queries are in cache

Debayan — Thu, 25 Aug 2022 16:15:15 GMT

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?