I had exactly the same issue and turned out that the count includes also snapshot. To check if that's the case one can add -x option in the count, e.g.:   hdfs dfs -count -v -h -x   /user/hive/warehouse/my_schema.db/* ... View more

HDFS only stores two time points in its INode data structures/persistence: The modification time and the access time [1]. For files, the mtime is effectively the time of when the file was last closed (such as when originally written and closed, or when reopened for append and closed). In general use this does not change very much for most files you'll place on HDFS and can serve as a "good enough" creation time. Is there a specific use-case you have in mind that requires preservation of the original create time? [1] https://github.com/apache/hadoop/blob/trunk/hadoop-hdfs-project/hadoop-hdfs/src/main/java/org/apache/hadoop/hdfs/server/namenode/INodeAttributes.java#L61-L65 ... View more

Please check which unix group the hive user belongs to and add this group into hadoop.proxyuser.hive.groups in the hive configuration via cloudera manager. ... View more

You can try run the following your browser   https://<query_coordinator_server_name>:25000/close_session?session_id=<session_id> ... View more

@ramarov Thank you for the suggestion! We'll keep it in mind for our future sprint updates.  ... View more