<?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 dbutils.fs.ls MAX_LIST_SIZE_EXCEEDED in Get Started Discussions</title>
    <link>https://community.databricks.com/t5/get-started-discussions/dbutils-fs-ls-max-list-size-exceeded/m-p/49978#M6055</link>
    <description>&lt;P&gt;Hi!&lt;/P&gt;&lt;P&gt;I'm experiencing different behaviours between two DBX Workspaces when trying to list file contents from an abfss: location.&lt;/P&gt;&lt;P&gt;In workspace A running len(dbutils.fs.ls('abfss://~~@~~~~.dfs.core.windows.net/~~/')) results in "Out[1]: 1551", while running the same command in workspace B results in "&lt;SPAN class=""&gt;&lt;SPAN class=""&gt;AnalysisException&lt;/SPAN&gt;: MAX_LIST_SIZE_EXCEEDED: There are more than 1001 files. Please specify [LIMIT] to limit the number of files returned.&lt;/SPAN&gt;"&lt;/P&gt;&lt;P&gt;I can't seem to find any way to increase this limit and would prefer to work with dbutils.fs.ls as opposed to mounting the location.The only difference between these two Workspaces and the clusters I've tried is that Workspace B has Unity Catalog enabled.&lt;/P&gt;</description>
    <pubDate>Fri, 27 Oct 2023 07:26:52 GMT</pubDate>
    <dc:creator>thuovi</dc:creator>
    <dc:date>2023-10-27T07:26:52Z</dc:date>
    <item>
      <title>dbutils.fs.ls MAX_LIST_SIZE_EXCEEDED</title>
      <link>https://community.databricks.com/t5/get-started-discussions/dbutils-fs-ls-max-list-size-exceeded/m-p/49978#M6055</link>
      <description>&lt;P&gt;Hi!&lt;/P&gt;&lt;P&gt;I'm experiencing different behaviours between two DBX Workspaces when trying to list file contents from an abfss: location.&lt;/P&gt;&lt;P&gt;In workspace A running len(dbutils.fs.ls('abfss://~~@~~~~.dfs.core.windows.net/~~/')) results in "Out[1]: 1551", while running the same command in workspace B results in "&lt;SPAN class=""&gt;&lt;SPAN class=""&gt;AnalysisException&lt;/SPAN&gt;: MAX_LIST_SIZE_EXCEEDED: There are more than 1001 files. Please specify [LIMIT] to limit the number of files returned.&lt;/SPAN&gt;"&lt;/P&gt;&lt;P&gt;I can't seem to find any way to increase this limit and would prefer to work with dbutils.fs.ls as opposed to mounting the location.The only difference between these two Workspaces and the clusters I've tried is that Workspace B has Unity Catalog enabled.&lt;/P&gt;</description>
      <pubDate>Fri, 27 Oct 2023 07:26:52 GMT</pubDate>
      <guid>https://community.databricks.com/t5/get-started-discussions/dbutils-fs-ls-max-list-size-exceeded/m-p/49978#M6055</guid>
      <dc:creator>thuovi</dc:creator>
      <dc:date>2023-10-27T07:26:52Z</dc:date>
    </item>
  </channel>
</rss>

