https://community.databricks.com/t5/data-engineering/optimization-failed-for-timestampntz/m-p/66251#M33064 <P>We have a table using timestampNtz type for timestamp, which is also a cluster key for this table using liquid clustering. I ran OPTIMIZE &lt;table-name&gt;, it failed with error</P><LI-CODE lang="markup">Unsupported datatype 'TimestampNTZType'</LI-CODE><P>&nbsp;But the failed optmization also broke the query that filters on this field. Query as below will fail</P><LI-CODE lang="markup">select * from table-name WHERE field_name&gt;'2024-01-02'</LI-CODE><P>&nbsp;with error</P><LI-CODE lang="markup">TimestampNTZType (of class org.apache.spark.sql.types.TimestampNTZType$)</LI-CODE><P>&nbsp;How am I suppose to solve this issue?</P> Mon, 15 Apr 2024 10:11:06 GMT Jennifer 2024-04-15T10:11:06Z https://community.databricks.com/t5/data-engineering/optimization-failed-for-timestampntz/m-p/66251#M33064 <P>We have a table using timestampNtz type for timestamp, which is also a cluster key for this table using liquid clustering. I ran OPTIMIZE &lt;table-name&gt;, it failed with error</P><LI-CODE lang="markup">Unsupported datatype 'TimestampNTZType'</LI-CODE><P>&nbsp;But the failed optmization also broke the query that filters on this field. Query as below will fail</P><LI-CODE lang="markup">select * from table-name WHERE field_name&gt;'2024-01-02'</LI-CODE><P>&nbsp;with error</P><LI-CODE lang="markup">TimestampNTZType (of class org.apache.spark.sql.types.TimestampNTZType$)</LI-CODE><P>&nbsp;How am I suppose to solve this issue?</P> Mon, 15 Apr 2024 10:11:06 GMT https://community.databricks.com/t5/data-engineering/optimization-failed-for-timestampntz/m-p/66251#M33064 Jennifer 2024-04-15T10:11:06Z