question How to drop large number of tables from a schema using script in efficient and fast. in Support Questions

question How to drop large number of tables from a schema using script in efficient and fast. in Support Questions https://community.cloudera.com/t5/Support-Questions/How-to-drop-large-number-of-tables-from-a-schema-using/m-p/361420#M238581  Hi All,I need to drop around 5000 tables from a schema - schemaDB, am using below script, tableNameList list contains all the 5000 tables names which I need to drop from the schema, but as the loop calling beeline process each time for each drop, the process to drop all the 5000 tables is taking lot of time, do we have another option where we can acheive it fastly. for tableName in $(cat tableNameList) do beeline -u "jdbc:hive2://server1.com:10000/default;principal=hive/server1.com@.com;" -e "drop table schemaDB.$tableName" >> $drop.logdone Thanks praKodi Mon, 16 Jan 2023 15:55:26 GMT prakodi 2023-01-16T15:55:26Z