Member since
08-19-2019
150
Posts
1
Kudos Received
0
Solutions
12-14-2020
02:37 AM
echo "scan 'emp'" | $HBASE_HOME/bin/hbase shell | awk -F'=' '{print $2}' | awk -F ':' '{print $2}'|awk -F ',' '{print $1}'
... View more
12-08-2020
03:47 AM
backup command running with hbase super user hbase backup create full hdfs://hostname:port/backup -t table_name restore command hbase restore hdfs://hostname:port/backup -t table_name we did this on same cluster
... View more
12-08-2020
02:43 AM
i created a table in phoenix create table t2(pk varchar primary key, col1 varchar); upsert into T2 values('1','abcd'); upsert into T2 values('2','123'); select * from T2; +-----+--------+ | PK | COL1 | +-----+--------+ | 1 | abcd | | 2 | 123 | +-----+--------+ table format in hbase hbase(main):024:0> scan 'T2' ROW COLUMN+CELL 1 column=0:\x00\x00\x00\x00, timestamp=1607423302365, value=x 1 column=0:\x80\x0B, timestamp=1607423302365, value=abcd 2 column=0:\x00\x00\x00\x00, timestamp=1607423295436, value=x 2 column=0:\x80\x0B, timestamp=1607423295436, value=123 2 row(s) i backed up above table and restored in hbase. now i want to create phoenix table on top of that so i used below command to create table create table t2(pk varchar primary key, col1 varchar); 2 rows affected (0.016 seconds) select * from T2; +-----+-------+ | PK | COL1 | +-----+-------+ | 1 | | | 2 | | +-----+-------+ after restored and created table in phoenix the primary key values are coming other values are not showing. please help me to solve this issue
... View more
Labels:
- Labels:
-
Apache HBase
-
Apache Phoenix
12-01-2020
10:03 PM
Hi i got my backup table in list_namespace list_namespace NAMESPACE backup default hbase 3 row(s) list_namespace_tables 'hbase' in this i dont have backup table list_namespace_tables 'hbase' TABLE meta namespace 2 row(s) is it ok or it will throw an error totake backup i am getting below error 2020-12-02 05:54:53,105 WARN [main] impl.BackupManager: Waiting to acquire backup exclusive lock for 3547s 2020-12-02 05:55:46,187 ERROR [main] impl.BackupAdminImpl: There is an active session already running Backup session finished. Status: FAILURE 2020-12-02 05:55:46,189 ERROR [main] backup.BackupDriver: Error running command-line tool java.io.IOException: Failed to acquire backup system table exclusive lock after 3600s at org.apache.hadoop.hbase.backup.impl.BackupManager.startBackupSession(BackupManager.java:415) at org.apache.hadoop.hbase.backup.impl.TableBackupClient.init(TableBackupClient.java:104) at org.apache.hadoop.hbase.backup.impl.TableBackupClient.(TableBackupClient.java:81) at org.apache.hadoop.hbase.backup.impl.FullTableBackupClient.(FullTableBackupClient.java:62) at org.apache.hadoop.hbase.backup.BackupClientFactory.create(BackupClientFactory.java:51) at org.apache.hadoop.hbase.backup.impl.BackupAdminImpl.backupTables(BackupAdminImpl.java:595) at org.apache.hadoop.hbase.backup.impl.BackupCommands$CreateCommand.execute(BackupCommands.java:347) at org.apache.hadoop.hbase.backup.BackupDriver.parseAndRun(BackupDriver.java:138) at org.apache.hadoop.hbase.backup.BackupDriver.doWork(BackupDriver.java:171) at org.apache.hadoop.hbase.backup.BackupDriver.run(BackupDriver.java:204) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.hadoop.hbase.backup.BackupDriver.main(BackupDriver.java:179)
... View more
12-01-2020
09:41 PM
2020-12-02 05:37:06,411 WARN [main] impl.BackupManager: Waiting to acquire backup exclusive lock for 3487s 2020-12-02 05:38:06,508 WARN [main] impl.BackupManager: Waiting to acquire backup exclusive lock for 3547s 2020-12-02 05:38:59,592 ERROR [main] impl.BackupAdminImpl: There is an active session already running Backup session finished. Status: FAILURE 2020-12-02 05:38:59,594 ERROR [main] backup.BackupDriver: Error running command-line tool java.io.IOException: Failed to acquire backup system table exclusive lock after 3600s at org.apache.hadoop.hbase.backup.impl.BackupManager.startBackupSession(BackupManager.java:415) at org.apache.hadoop.hbase.backup.impl.TableBackupClient.init(TableBackupClient.java:104) at org.apache.hadoop.hbase.backup.impl.TableBackupClient.<init>(TableBackupClient.java:81) at org.apache.hadoop.hbase.backup.impl.FullTableBackupClient.<init>(FullTableBackupClient.java:62) at org.apache.hadoop.hbase.backup.BackupClientFactory.create(BackupClientFactory.java:51) at org.apache.hadoop.hbase.backup.impl.BackupAdminImpl.backupTables(BackupAdminImpl.java:595) at org.apache.hadoop.hbase.backup.impl.BackupCommands$CreateCommand.execute(BackupCommands.java:347) at org.apache.hadoop.hbase.backup.BackupDriver.parseAndRun(BackupDriver.java:138) at org.apache.hadoop.hbase.backup.BackupDriver.doWork(BackupDriver.java:171) at org.apache.hadoop.hbase.backup.BackupDriver.run(BackupDriver.java:204) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.hadoop.hbase.backup.BackupDriver.main(BackupDriver.java:179)
... View more
11-30-2020
09:25 PM
I need to take hbase full backup. i fired below command hbase backup create full http://hostname:8020/hbase-backup i am getting below error 2020-12-01 05:23:44,635 WARN [main] impl.BackupManager: Waiting to acquire backup exclusive lock for 1s 2020-12-01 05:24:44,818 WARN [main] impl.BackupManager: Waiting to acquire backup exclusive lock for 61s
... View more
Labels:
- Labels:
-
Apache HBase
11-22-2020
09:12 PM
How can i increase the region server count to ~300-400 Region/RegionServer.
... View more
11-01-2020
10:43 PM
memstore size i reduced to 32MB. still RIT count not reduced. let me know how to increase region count in region server.
... View more
10-07-2020
01:42 AM
Hi all i have 1 Hbase master and 3 region servers. I got a huge number (7000+) in regions in transition state. In hbase master logs 2020-10-07 08:37:02,745 WARN [ProcExecTimeout] assignment.AssignmentManager: STUCK Region-In-Transition rit=OPENING, location=hostname,16020,1601150311831, table=table_name, region=region_id. for that i executed below command assign 'region_id' count is decreased and when i restart hbase again count increased. so i tried hbase hbck -repair ----------------------------------------------------------------------- NOTE: As of HBase version 2.0, the hbck tool is significantly changed. In general, all Read-Only options are supported and can be be used safely. Most -fix/ -repair options are NOT supported. Please see usage below for details on which options are not supported. i got this error. so i need help to reduce regions in transition count or upgrade hbase in ambari to execute repair command.
... View more
Labels:
- Labels:
-
Apache Ambari
-
Apache HBase
07-23-2020
02:38 AM
Can we delete kafka consumer group data? not the consumer group need to delete group data?
... View more