Renukaprasad C created HIVE-23927: ------------------------------------- Summary: Cast to Timestamp generates different output for Integer & Float values Key: HIVE-23927 URL: https://issues.apache.org/jira/browse/HIVE-23927 Project: Hive Issue Type: Bug Reporter: Renukaprasad C
Double consider the input value as SECOND and converts into Millis internally. Whereas, Integer value will be considered as Millis and produce different output. org.apache.hadoop.hive.serde2.objectinspector.primitive.PrimitiveObjectInspectorUtils.getTimestamp(Object, PrimitiveObjectInspector, boolean) - Handles Integral & Decimal values differently. This cause the issue. 0: jdbc:hive2://localhost:10000> select cast(1.204135216E9 as timestamp) Double2TimeStamp, cast(1204135216 as timestamp) Int2TimeStamp from abc tablesample(1 rows); OK INFO : Compiling command(queryId=renu_20200724140642_70132390-ee12-4214-a2ca-a7e10556fc14): select cast(1.204135216E9 as timestamp) Double2TimeStamp, cast(1204135216 as timestamp) Int2TimeStamp from abc tablesample(1 rows) INFO : Concurrency mode is disabled, not creating a lock manager INFO : Semantic Analysis Completed (retrial = false) INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:double2timestamp, type:timestamp, comment:null), FieldSchema(name:int2timestamp, type:timestamp, comment:null)], properties:null) INFO : Completed compiling command(queryId=renu_20200724140642_70132390-ee12-4214-a2ca-a7e10556fc14); Time taken: 0.175 seconds INFO : Concurrency mode is disabled, not creating a lock manager INFO : Executing command(queryId=renu_20200724140642_70132390-ee12-4214-a2ca-a7e10556fc14): select cast(1.204135216E9 as timestamp) Double2TimeStamp, cast(1204135216 as timestamp) Int2TimeStamp from abc tablesample(1 rows) INFO : Completed executing command(queryId=renu_20200724140642_70132390-ee12-4214-a2ca-a7e10556fc14); Time taken: 0.001 seconds INFO : OK INFO : Concurrency mode is disabled, not creating a lock manager +------------------------+--------------------------+ | double2timestamp | int2timestamp | +------------------------+--------------------------+ | 2008-02-27 18:00:16.0 | 1970-01-14 22:28:55.216 | +------------------------+--------------------------+ -- This message was sent by Atlassian Jira (v8.3.4#803005)