[ https://issues.apache.org/jira/browse/HIVE-20900?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16685830#comment-16685830 ]
Jason Dere commented on HIVE-20900: ----------------------------------- Looks like TIMESTAMP WITH LOCAL TIME ZONE never implemented the timestamp.formats support: {noformat} Caused by: org.apache.hadoop.hive.serde2.SerDeException: struct field __time: Could not convert from string to map type timestamp with local time zone at org.apache.hadoop.hive.serde2.json.HiveJsonStructReader.parseStruct(HiveJsonStructReader.java:203) at org.apache.hadoop.hive.serde2.json.HiveJsonStructReader.parseDispatcher(HiveJsonStructReader.java:117) at org.apache.hadoop.hive.serde2.json.HiveJsonStructReader.parseInternal(HiveJsonStructReader.java:100) ... 55 more Caused by: java.io.IOException: Could not convert from string to map type timestamp with local time zone at org.apache.hadoop.hive.serde2.json.HiveJsonStructReader.parsePrimitiveValue(HiveJsonStructReader.java:370) at org.apache.hadoop.hive.serde2.json.HiveJsonStructReader.getObjectOfCorrespondingPrimitiveType(HiveJsonStructReader.java:322) at org.apache.hadoop.hive.serde2.json.HiveJsonStructReader.parsePrimitive(HiveJsonStructReader.java:308) at org.apache.hadoop.hive.serde2.json.HiveJsonStructReader.parseDispatcher(HiveJsonStructReader.java:113) at org.apache.hadoop.hive.serde2.json.HiveJsonStructReader.parseStruct(HiveJsonStructReader.java:201) ... 57 more {noformat} > serde2.JsonSerDe no longer supports timestamp.formats > ----------------------------------------------------- > > Key: HIVE-20900 > URL: https://issues.apache.org/jira/browse/HIVE-20900 > Project: Hive > Issue Type: Bug > Components: Serializers/Deserializers > Reporter: Jason Dere > Assignee: Jason Dere > Priority: Major > Attachments: HIVE-20900.1.patch, HIVE-20900.2.patch > > > Looks like HIVE-18545 broke this. > Also json_serde_tsformat.q only tested the hcat version of JsonSerde, and the > format in that test used the ISO timestamp format which apparently is now > parsed by the default timestamp parsing, so the test was too simple. -- This message was sent by Atlassian JIRA (v7.6.3#76005)