Stack Overflow
Stack Overflow

Questions tagged [hbase-shell]

hbase-shell is a CLI for HBase implemented in JRuby. Use this tag for HBase questions specific to the shell. For general HBase questions use [hbase] instead.

hbase-shell is a CLI for HBase implemented in JRuby.

References

41 questions
35
votes
4 answers

HBase (Easy): How to Perform Range Prefix Scan in hbase shell

I am designing an app to run on hbase and want to interactively explore the contents of my cluster. I am in the hbase shell and I want to perform a scan of all keys starting with the chars "abc". Such keys might inlcude "abc4", "abc92", "abc20014"…
David Williams
  • 8,388
  • 23
  • 83
  • 171
14
votes
1 answer

How do I get a Row with HBASE Shell where the rowkey is in Hexadecimal?

If I have a rowkey that is in Hexadecimal, like x00\x01 , how do I get that in the HBASE shell? hbase(main):004:0> scan 'tsdb-tree' ROW COLUMN+CELL \x00\x01 column=t:tree, timestamp=1379421652764, value={"name":"...
Kyle Brandt
  • 26,938
  • 37
  • 124
  • 165
11
votes
1 answer

How to stop command running in hbase shell and not exit hbase shell

In some times I want quit from my running command in HBase shell, such as a scan ops usually take too much time. So I want to stop running this command, but I don't want exit HBase shell. The usual way for me to stop the running command, I used…
Devin Wu
  • 121
  • 1
  • 8
9
votes
1 answer

What are the non-hex characters in HBase Shell RowKey?

I am saving my key as a byte-array. In HBase Shell when I look at my key I see non-hex values...I do not have any encoding enabled, I do not have any compression enabled. Here is a sample...what is VNQ? what is BBW? I'm guessing there is some…
hba
  • 7,406
  • 10
  • 63
  • 105
9
votes
2 answers

HBase: Create table with same schema as existing table

I tried searching on the forum, where I can create a new empty hbase table from existing hbase table schema, but not able to find. To be more precise, suppose I have a table with multiple column families and many column qualifier within those…
Gyanendra Dwivedi
  • 5,511
  • 2
  • 27
  • 53
7
votes
1 answer

HBase Shell Logging

When using the HBase shell, I'm getting a great deal of logging, including INFO and DEBUG messages. While this is interesting in terms of learning HBase internals, it is quite verbose and can bury the output. I've tried changing the logging levels…
user1219
  • 103
  • 5
7
votes
3 answers

Export data from HBase shell

Im trying to export data from HBase Shell to a text file which I can parse, and add to a msysql db. I am currently using the following command: echo "scan 'registration',{COLUMNS=>'registration:status'}" | hbase shell > registration.txt which…
Yogzzz
  • 2,735
  • 5
  • 36
  • 56
5
votes
3 answers

Delete all data from HBase table according to time range?

I am trying to delete all data from HBase table, which has a timestamp older than a specified timestamp. This contains all the column families and rows. Is there a way this can be done using shell as well as Java API?
Alifiya Ali
  • 77
  • 1
  • 7
5
votes
3 answers

HBase Shell command questions

I have some questions about HBase Shell Command Tool: 1: How to list all column family names (just names!) in a table? 2: How to count the number of rows in a column family?
user2597504
  • 1,503
  • 3
  • 23
  • 32
4
votes
1 answer

Avoid line-wrapping in hbase shell output

I have some long string data in an hbase column and I want to use linux tools like grep, cut, sort, etc on the output of a scan. Unfortunately, the hbase shell is formatting the output of the scan into visual columns in my terminal. This is nice for…
lmsurprenant
  • 1,723
  • 2
  • 14
  • 28
4
votes
2 answers

HBASE row prefix scan in reverse order in hbase

I have a row key of the form: -- Using HBASE shell I want to find last 15 entries with the prefix . scan 'mytable', {LIMIT => 15, ROWPREFIXFILTER => 'name' } Gives me the first 15, but: scan 'mytable', {LIMIT => 15,…
tanbog
  • 600
  • 9
  • 28
3
votes
2 answers

HBase Shell hangs / freezes

I've installed HBase 0.92.1-cdh4.0.1 on Ubuntu 12.04 in Pseudo-Distributed mode. hbase-master, hbase-regionserver and zookeeper-server are running on this machine; the HDFS is running on another machine (property hbase.rootdir set accordingly). Now…
bathyscaph
  • 108
  • 1
  • 6
2
votes
0 answers

Limit the hbase shell to "read only" commands

Is it possible to limit the hbase shell to allow just the "read only" commands? The goal is to avoid inadvertent changes to the data. I am imagining something similar to the readonly connections of many SQL databases.
Andrew Stein
  • 12,880
  • 5
  • 35
  • 43
2
votes
1 answer

Hbase shell error on M1 MacOS: fat file, but missing compatible architecture (have 'i386,x86_64', need 'arm64e')

Intall HBase by homebrew。But HBase shell run error on M1 MacOS, with the help of https://github.com/jruby/jruby/wiki/Native-Libraries, I add "-Djruby.native.verbose=true" to hbase shell commond, then get follow exception: hbase…
yxw
  • 21
  • 3
2
votes
1 answer

Hbase shell - Find all rows where a column does not exist

I have setup Hbase 0.98 with huge data. Being noSQL database, HBase allows each row to have different set of columns in a column family. To filter a specific column, I can use this command scan 'tb_webpage',{COLUMNS => 't:ad'} What if I have to…
Hafiz Muhammad Shafiq
  • 8,168
  • 12
  • 63
  • 121
1
2 3