hello, I am using hive 1.2.1. I executed the following command to change the type of a column from timestamp to date ALTER TABLE table_name CHANGE column_name column_name date CASCADE; the command was executed successfully. when i want to retrieve the data from the table using: select * from table_name I got the following error: Failed with exception java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: org.apache.hadoop.hive.serde2.io.TimestampWritable cannot be cast to org.apache.hadoop.hive.serde2.io.DateWritable thanks for help. ... View more

Hello, I tried to connect to hive using jdbc but i had the following error: Error: Could not open client transport with JDBC Uri: jdbc:hive2://server:10000/;principal=<Server_Principal_of_HiveServer2> java.net.ConnectException: Connection refused (state=08S01,code=0) I got the same error from beeline : beeline -u 'jdbc:hive2://server:10000/;principal=<Server_Principal_of_HiveServer2>' I will be thankfull for your help. thanks Hive version: 1.2.1 HDP: 2.3 ... View more

Hello, I have many open transactions on table that i cant' delete. Even if i delete the table, transactions are still open. There is a way to rollback these transactions? There is a way to kill pending locks? Hive version : 1.2.1 Thanks ... View more