Support Questions

Find answers, ask questions, and share your expertise

Hbase complete list of columns in column family

avatar
Expert Contributor

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’
1 ACCEPTED SOLUTION

avatar
Super Guru

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.

View solution in original post

5 REPLIES 5

avatar
Super Guru

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.

avatar
Expert Contributor

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}' 

avatar

@vamsi valiveti

Thanks, Worked for me!

avatar
Rising Star

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

avatar
Contributor

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