You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by "Ravi ." <ip...@gmail.com> on 2011/02/05 02:34:59 UTC

How to drop tables using regex?

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