Hive LPAD function hangs HS2 and its subsequent queries
Recently I have noticed an issue in Hive that running below query will hang HiveServer2 indefinitely until it got cancelled. And because HiveServer2’s global compilation lock, it prevents any further queries from submitted into Hive and all queries appear to be queued. After researching, I concluded that it was caused …