How to clear a table in hbase?

php hbase
Micku picture Micku · Mar 28, 2012 · Viewed 29.4k times · Source

I want to empty a table in hbase... eg: user. Is there any command or function to empty the table without deleting it...

My table structure is : 

$mutations = array(
                new Mutation( array(
                    'column' => 'username:1',
                    'value' =>$name
                ) ),
                new Mutation( array(
                    'column' => 'email:1',
                    'value' =>$email
                ) )
        );          
$hbase->mutateRow("user",$key,$mutations);

Can someone help me?

Answer

Alexis Gamarra picture Alexis Gamarra · Aug 1, 2013

If you execute this in HBase shell:

 > truncate 'yourTableName'

Then HBase will execute this operations for 'yourTableName':

 > disable 'yourTableName'
 > drop 'yourTableName'
 > create 'yourTableName', 'f1', 'f2', 'f3'

Related questions

Integrate Hbase with PHP

I have installed the Hbase and now I am looking for some PHP library to integrate hbase with PHP I have tried 2 libraries one is I tried to connect with thrift but was unable to do so 2nd is I …

Read More
How do I check if a string contains a specific word?

Consider: $a = 'How are you?'; if ($a contains 'are') echo 'true'; Suppose I have the code above, what is the correct way to write the statement if ($a contains 'are')?

Read More
Get the full URL in PHP

I use this code to get the full URL: $actual_link = 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF']; The problem is that I use some masks in my .htaccess, so what we see in the URL is not always …

Read More