hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ravi ." <iphul...@gmail.com>
Subject How to drop tables using regex?
Date Sat, 05 Feb 2011 01:34:59 GMT
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

Mime
View raw message