Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,400 questions
Partition and zorder
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Shambhu Rai
1,411
Reputation points
Hi Expert,
partition and ZORDER BY not working same query any issue .. it gives error...any issues
here is what MicroSoft says
Z-Ordering is not idempotent but aims to be an incremental operation. The time it takes for Z-Ordering is not guaranteed to reduce over multiple runs. However, if no new data was added to a partition that was just Z-Ordered, another Z-Ordering of that partition will not have any effect.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 45%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAO%3C/text%3E%3C/svg%3E)
Ayomide Oluwaga 901 Reputation points2023-08-06T23:34:54.86+00:00 If you’re having issues with partitioning and Z-Ordering in your query there could be various reasons for that such as incorrect syntax or data-related issues. It’s important to review your query carefully and ensure that it’s written correctly. Also, make sure that your data is structured properly and follows the requirements for partitioning and Z-Ordering.
If you provide more details about the specific error message and the query you’re using, I can help you troubleshoot the issue further.Do not use comments to answer questions.
-
Shambhu Rai 1,411 Reputation points
2023-08-07T00:02:15.2233333+00:00 sure but partition and zorder is not working together as MS Article says... is that correct
https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/delta-optimize
-
Wilko van de Velde 2,231 Reputation points2023-08-07T05:55:17.7566667+00:00 Hi Shambhu Rai,
Please only use relevant tags. This will help us to resolve your problem
Greetings,
Wilko -
Sander van de Velde | MVP 35,971 Reputation points MVP2023-08-07T07:02:19.8066667+00:00 Moderated. Tags limited to Databricks.
-
Shambhu Rai 1,411 Reputation points
2023-08-07T08:39:58.1566667+00:00 yes i am concerned with databricks only
https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/delta-optimize
can someone explain this ... what it is
-
Shambhu Rai 1,411 Reputation points
2023-08-07T17:08:43.2566667+00:00 suggestion please
-
Shambhu Rai 1,411 Reputation points
2023-08-08T18:01:42.9733333+00:00 suggestion please
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache 20,356 Reputation points2023-08-10T04:13:01.5033333+00:00 Hello Shambhu Rai,
partition and ZORDER BY not working same query any issue .. it gives error...any issues
For a deeper investigation and immediate assistance on this issue, if you have a support plan you may file a support ticket. Thanks for understanding.
-
Shambhu Rai 1,411 Reputation points
2023-08-10T10:59:18.56+00:00 hi, the question is related above link
-
QuantumCache 20,356 Reputation points
2023-08-11T17:27:13.0033333+00:00 Thank you for sharing the info!
Sign in to comment
Sign in to answer