How to handle hive locking across hive and presto?

@dedrick 

Handling hive locking across hive and presto can be challenging due to the differences in how each system handles locking and transactions. Here are some strategies to help manage hive locking across both systems:

1. Use consistent locking mechanisms: Try to use the same locking mechanism across both hive and presto to ensure consistency in how locks are managed. This can help prevent conflicts between the two systems.
2. Monitor locks and transactions: Keep track of locks and transactions in both hive and presto to identify any potential conflicts. Use tools like Apache Atlas or Apache Ranger to monitor and manage locks across both systems.
3. Coordinate transactions: If possible, try to coordinate transactions between hive and presto to minimize the chances of conflicts. This can involve using transaction management tools or implementing custom logic to handle transactions across both systems.
4. Optimize queries: Consider optimizing your queries to minimize the amount of locking required. This can help reduce the chances of conflicts between hive and presto.
5. Communicate with users: Keep users informed about the potential for locking conflicts between hive and presto and educate them on best practices for managing locks across both systems.

By following these strategies, you can help minimize the chances of locking conflicts between hive and presto and ensure smooth operation across both systems.