question Re: Hbase complete list of columns in column family in Support Questions

Hbase complete list of columns in column family

vamsi123 — Wed, 16 Nov 2016 21:13:13 GMT

How do we get the complete list of columns that exist in a column Family?

Let us assume i have 5 columns for personal data column familyand 4 columns are present for professional data column family

create 'emp', 'personal data', ’professional data’

Re: Hbase complete list of columns in column family

elserj — Wed, 16 Nov 2016 23:32:43 GMT

HBase does not explicitly track the qualifiers that exist in each family. You either need to maintain this information yourself (e.g. in another table) or scan the data.

Re: Hbase complete list of columns in column family

vamsi123 — Thu, 17 Nov 2016 16:00:19 GMT

Hi @Josh Elser.

I got the answer by unix command as mentiond below.

Command:-

echo "scan 'emp" | $HBASE_HOME/bin/hbase shell | awk -F'=' '{print $2}' | awk -F ':' '{print $2}'|awk -F ',' '{print $1}'

Re: Hbase complete list of columns in column family

shital_borude9 — Wed, 21 Dec 2016 14:17:15 GMT

@vamsi valiveti

Thanks, Worked for me!

Re: Hbase complete list of columns in column family

jack0188 — Thu, 05 Oct 2017 13:48:12 GMT

how did you run the script? it didn't return me any result. can your share your's?

Re: Hbase complete list of columns in column family

Manoj690 — Mon, 14 Dec 2020 10:37:53 GMT

echo "scan 'emp'" | $HBASE_HOME/bin/hbase shell | awk -F'=' '{print $2}' | awk -F ':' '{print $2}'|awk -F ',' '{print $1}'