Hi @Rohit Sureka, Did you find a solution for this? I am also facing same issue, In my use case I want to add a field for current timestamp with 9 decimal place precision. Hive (v 1.1.0) is giving up to only 3 decimal place, I also tried by casting it in String but no luck. As per hive official document: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-TimestampstimestampTimestamps " Timestamps Supports traditional UNIX timestamp with optional nanosecond precision. Supported conversions: Integer numeric types: Interpreted as UNIX timestamp in seconds Floating point numeric types: Interpreted as UNIX timestamp in seconds with decimal precision Strings: JDBC compliant java.sql.Timestamp format " YYYY-MM-DD HH:MM:SS.fffffffff " (9 decimal place precision) " Thanks In advance. ... View more