topic Re: Why do I always get an error on querying the Parquet table - Parquet does not support timestamp in Data Engineering https://community.databricks.com/t5/data-engineering/why-do-i-always-get-an-error-on-querying-the-parquet-table/m-p/20770#M14060 <P>The issue can happen if the Hive syntax for table creation is used instead of the Spark syntax. </P><P>Read more here: <A href="https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-ddl-create-table-hiveformat.html" target="test_blank">https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-ddl-create-table-hiveformat.html</A></P><P></P><P>The issue mentioned in the error message is already fixed on the Hive metastore layer. However, the default version of the hive metastore client used by Databricks is an older version and the fix is not available on that version. Upgrade the metastore client to use a newer version of the Hive metastore client. (1.2.1 or greater) </P><P></P> Thu, 24 Jun 2021 09:24:16 GMT brickster_2018 2021-06-24T09:24:16Z Why do I always get an error on querying the Parquet table - Parquet does not support timestamp https://community.databricks.com/t5/data-engineering/why-do-i-always-get-an-error-on-querying-the-parquet-table/m-p/20769#M14059 Thu, 24 Jun 2021 09:21:47 GMT https://community.databricks.com/t5/data-engineering/why-do-i-always-get-an-error-on-querying-the-parquet-table/m-p/20769#M14059 brickster_2018 2021-06-24T09:21:47Z Re: Why do I always get an error on querying the Parquet table - Parquet does not support timestamp https://community.databricks.com/t5/data-engineering/why-do-i-always-get-an-error-on-querying-the-parquet-table/m-p/20770#M14060 <P>The issue can happen if the Hive syntax for table creation is used instead of the Spark syntax. </P><P>Read more here: <A href="https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-ddl-create-table-hiveformat.html" target="test_blank">https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-ddl-create-table-hiveformat.html</A></P><P></P><P>The issue mentioned in the error message is already fixed on the Hive metastore layer. However, the default version of the hive metastore client used by Databricks is an older version and the fix is not available on that version. Upgrade the metastore client to use a newer version of the Hive metastore client. (1.2.1 or greater) </P><P></P> Thu, 24 Jun 2021 09:24:16 GMT https://community.databricks.com/t5/data-engineering/why-do-i-always-get-an-error-on-querying-the-parquet-table/m-p/20770#M14060 brickster_2018 2021-06-24T09:24:16Z