Deeservent opened a new issue, #1198: URL: https://github.com/apache/incubator-paimon/issues/1198
### Search before asking - [X] I searched in the [issues](https://github.com/apache/incubator-paimon/issues) and found nothing similar. ### Paimon version paimon-hive-connector-3.1-0.5-20230519.001932-15.jar ### Compute Engine hive-3.1.0 ### Minimal reproduce step 0: jdbc:hive2://ambari.bi.lyf.test:2181,nn01.> select id,order_no,create_time from ods.zt_tc_order_paimon a; INFO : Compiling command(queryId=hive_20230522165519_4501567f-83d4-40ae-b6a1-5cc8c2f1a6f9): select id,order_no,create_time from ods.zt_tc_order_paimon a INFO : Semantic Analysis Completed (retrial = false) INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:id, type:bigint, comment:null), FieldSchema(name:order_no, type:string, comment:null), FieldSchema(name:create_time, type:timestamp, comment:null)], properties:null) INFO : Completed compiling command(queryId=hive_20230522165519_4501567f-83d4-40ae-b6a1-5cc8c2f1a6f9); Time taken: 0.325 seconds INFO : Executing command(queryId=hive_20230522165519_4501567f-83d4-40ae-b6a1-5cc8c2f1a6f9): select id,order_no,create_time from ods.zt_tc_order_paimon a INFO : Completed executing command(queryId=hive_20230522165519_4501567f-83d4-40ae-b6a1-5cc8c2f1a6f9); Time taken: 0.25 seconds INFO : OK java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff] at java.sql.Timestamp.valueOf(Timestamp.java:237) at org.apache.hive.jdbc.HiveBaseResultSet.evaluate(HiveBaseResultSet.java:445) at org.apache.hive.jdbc.HiveBaseResultSet.getColumnValue(HiveBaseResultSet.java:425) at org.apache.hive.jdbc.HiveBaseResultSet.getObject(HiveBaseResultSet.java:467) at org.apache.hive.beeline.Rows$Row.<init>(Rows.java:160) at org.apache.hive.beeline.BufferedRows.<init>(BufferedRows.java:57) at org.apache.hive.beeline.IncrementalRowsWithNormalization.<init>(IncrementalRowsWithNormalization.java:50) at org.apache.hive.beeline.BeeLine.print(BeeLine.java:2305) at org.apache.hive.beeline.Commands.executeInternal(Commands.java:1026) at org.apache.hive.beeline.Commands.execute(Commands.java:1201) at org.apache.hive.beeline.Commands.sql(Commands.java:1130) at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:1480) at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:1342) at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:1126) at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:546) at org.apache.hive.beeline.BeeLine.main(BeeLine.java:528) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:318) at org.apache.hadoop.util.RunJar.main(RunJar.java:232) Error: Unrecognized column type:TIMESTAMP_TYPE (state=,code=0) 0: jdbc:hive2://ambari.bi.lyf.test:2181,nn01.> ### What doesn't meet your expectations? timestamp format error ### Anything else? _No response_ ### Are you willing to submit a PR? - [ ] I'm willing to submit a PR! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
