Skip to content

Snowflake Guide

Eric's another Big Data Blog

Primary Menu
  • Home
  • About Me
  • |
  • SQL
  • Security
  • JDBC

Tag: Unload

Nano second precision lost after Parquet file Unload

Posted on 24 May 202124 May 2021 by Eric Lin

When unloading Timestamp data into Parquet file, the nano and micro seconds precision will be lost, and only milliseconds are stored in the file.  To reproduce the issue, please see below script: We can see that the nano seconds part .12434453 was truncated to .124. This is due to limitations on Parquet V1 that is currently being used […]

Continue Reading
Eric Lin
Principal Cloud Support Engineer
@ Snowflake
Blogger | Runner | Ex-Cloudera
3 x SnowPro
Snowflake | Monash University
View Profile

Friendly Links

  • Cloudera Troubleshooting
  • RAYNIX 筆記

Recent Posts

  • String object in Javascript UDF does not have the replaceAll() function
  • Create View Automatically From VARIANT Columns
  • Find Child Queries of a Stored Procedure
  • JavaScript UDF fails with error: TIME inside VARIANT value – not supported
  • Nano second precision lost after Parquet file Unload
All rights reserved!
Copyright All rights reserved | Theme: Advance Blog by WPinterface.