Each table is taking 30 seconds. Without looking at the HBase code I assumed it was doing the same process as I am. Just quicker.
Thanks -Pete -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jean-Daniel Cryans Sent: Monday, February 14, 2011 10:12 AM To: [email protected] Subject: Re: Truncate tables Erm well could it be that your script is truncating a bunch of tables whereas in the shell it only does one? Apart from that I can't think of anything obvious, the truncate command really does the same thing as you. J-D On Mon, Feb 14, 2011 at 9:43 AM, Peter Haidinyak <[email protected]> wrote: > Hi, > I've setup a little utility to truncate my tables during development > but I found that if I truncate a table from the HBase shell it takes 2.5 > seconds, from my program it take 30 seconds. The code to truncate is pretty > simple. Any ideas on what I've done wrong? > > Thanks > > -Pete > > private void truncateTables() > throws IOException > { > m_hbaseConnection = new HbaseConnection(); > m_hbaseConnection.setupHBaseConnection(); > final HBaseAdmin hBaseAdmin = m_hbaseConnection.getAdmin(); > > int counter = 1; > for (final String tableName : CLUSTER_TABLES) > { > final HTableDescriptor hTableDescriptor = > hBaseAdmin.getTableDescriptor(tableName.getBytes()); > m_logger.info("Truncating Table {}.",tableName); > hBaseAdmin.disableTable(tableName); > hBaseAdmin.deleteTable(tableName); > hBaseAdmin.createTable(hTableDescriptor); > m_logger.info("Truncated Table {}.", tableName); > m_logger.info("Finished {} of {} Tables.", counter++, > CLUSTER_TABLES.length); > > } // - End for each table. > > } // - End truncateTables Method. > > > public void setupHBaseConnection() > throws IOException > { > m_hbaseConfiguration = HBaseConfiguration.create(); > m_hbaseConfiguration.clear(); > > // - Get the m_hbaseConfiguration properties from the Command line -D > parameters. > m_hbaseConfiguration.set("hbase.zookeeper.quorum", > System.getProperty("hbase.zookeeper.quorum")); > m_hbaseConfiguration.set("hbase.zookeeper.property.clientPort", > System.getProperty("hbase.zookeeper.property.clientPort")); > > m_logger.info("Using hbase.zookeeper.quorum : {}", > m_hbaseConfiguration.get("hbase.zookeeper.quorum")); > m_logger.info("Using hbase.zookeeper.property.clientPort : {}", > m_hbaseConfiguration.get("hbase.zookeeper.property.clientPort")); > > } // - End setupHBaseConnection Method. > >
