Is there a detailed guide for resource allocation, best practices, as well as maybe just a basic guide to Hive Interactive? Searching the archive points to here, but the video is lost.   My current issue is getting the zookeeper to recognize the new namespace, but a overall guide would be ideal. ... View more

UPDATE: I'm wondering if this is happening on deletion, not creation. There is a describe that runs before the external table creation and it's throwing the same error. Checking binlogs in mysql for any clues.   UPDATE2: After reading the binlog, I am more convinced the DROP TABLE <TABLE> cmd for hive isn't complete correctly and isn't delete from TBLS. -------------------------------------------------------------- This is a behavior I've experienced frequently in Hive 3, that occurred almost never in Hive. Hive Version:  3.0.0.3.1 Metastore is mysql.   As part of an incremental data sqoop, I create two tables:One external, one ORC. Sometimes during the creation of these two tables, the metastore doesn't populate the the SERDES, SDS, CDS tables with the corresponding metadata and leaves the SD_ID null in the TBLS table. The table remain non-interactive (not even droppable) until I populate dummy data in the corresponding tables and update the TBLS's SD_ID field.   The statements for table creation are as such: EXTERNAL create external table if not exists <DIFF EXTERNAL TABLE NAME> like <MAIN EXTERNAL TABLE NAME>; ORC create table <DIFF ORC TABLE> stored as orc as select * from <DIFF EXTERNAL TABLE NAME>; The logs in the metastore are a bit unclear:         2019-11-13T04:08:07,696 ERROR [pool-6-thread-187]: metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(201)) - java.lang.NullPointerException 2019-11-13T04:08:07,696 ERROR [pool-6-thread-187]: server.TThreadPoolServer (TThreadPoolServer.java:run(297)) - Error occurred during processing of message.         And the logs in the Hiveserver2 logs only highlight after the issue has happened. ... View more