<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Querying view gives spurious error in Administration &amp; Architecture</title>
    <link>https://community.databricks.com/t5/administration-architecture/querying-view-gives-spurious-error/m-p/112200#M3104</link>
    <description>&lt;P&gt;Are there DDL updates of the view going on?&lt;/P&gt;</description>
    <pubDate>Mon, 10 Mar 2025 22:30:18 GMT</pubDate>
    <dc:creator>mnorland</dc:creator>
    <dc:date>2025-03-10T22:30:18Z</dc:date>
    <item>
      <title>Querying view gives spurious error</title>
      <link>https://community.databricks.com/t5/administration-architecture/querying-view-gives-spurious-error/m-p/112198#M3102</link>
      <description>&lt;P&gt;When trying to query a view, my_view, we sometimes see a spurious error. This seems to occur after the table underlying the view has been updated. The error persists for a while and then it seems to fix itself.&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;Error running query: [42501] [Simba][Hardy] (35) Error from server: error code: '0' error message: 'org.apache.hive.service.cli.HiveSQLException: Error running query: [UNAUTHORIZED_ACCESS] com.databricks.sql.managedcatalog.acl.UnauthorizedAccessException: PERMISSION_DENIED: User is not an owner of Table 'my_view'. at org.apache.s'. (35) (SQLExecDirectW)&lt;/PRE&gt;&lt;DIV class=""&gt;One hypothesis for this error is that:&amp;nbsp;&lt;SPAN&gt;Databricks is occasionally trying to do something else in addition to running the query, like modifying some metadata, and that's what the actual permissions error comes from.&lt;BR /&gt;&lt;BR /&gt;I was wondering if anyone has seen this before, or would have tips for how to investigate this further.&amp;nbsp;&lt;/SPAN&gt;&lt;/DIV&gt;</description>
      <pubDate>Mon, 10 Mar 2025 21:37:49 GMT</pubDate>
      <guid>https://community.databricks.com/t5/administration-architecture/querying-view-gives-spurious-error/m-p/112198#M3102</guid>
      <dc:creator>PaulJones</dc:creator>
      <dc:date>2025-03-10T21:37:49Z</dc:date>
    </item>
    <item>
      <title>Re: Querying view gives spurious error</title>
      <link>https://community.databricks.com/t5/administration-architecture/querying-view-gives-spurious-error/m-p/112200#M3104</link>
      <description>&lt;P&gt;Are there DDL updates of the view going on?&lt;/P&gt;</description>
      <pubDate>Mon, 10 Mar 2025 22:30:18 GMT</pubDate>
      <guid>https://community.databricks.com/t5/administration-architecture/querying-view-gives-spurious-error/m-p/112200#M3104</guid>
      <dc:creator>mnorland</dc:creator>
      <dc:date>2025-03-10T22:30:18Z</dc:date>
    </item>
  </channel>
</rss>

