Hello, I want to drop lots of tables from hive . Is there any way to specify regex for drop table.
I tried following ways but none of them succeed , how do I drop tables using regex? hive> drop table "poke.*"; FAILED: Parse Error: line 1:11 mismatched input '"poke.*"' expecting Identifier in drop statement hive> drop table like "poke.*"; FAILED: Parse Error: line 1:11 mismatched input 'like' expecting Identifier in drop statement Thanks, Ravi
