HBASE queries

Discussion in 'Big Data and Analytics' started by _6230, May 9, 2017.

  1. _6230

    _6230 Well-Known Member
    Alumni

    Joined:
    Apr 4, 2017
    Messages:
    152
    Likes Received:
    8
    1. how to recover truncated table in hbase ?
    2. Whether any new column family we can add after table is created?
    3. How to insert bulk data in hbase through excel ? is anyone having sample code or commands in hbase shell?
     
    #1
  2. Karthik Shivana

    Karthik Shivana Moderator
    Simplilearn Support

    Joined:
    Apr 1, 2016
    Messages:
    590
    Likes Received:
    21
    Hi,

    Please find the below details,

    1. how to recover truncated table in hbase ?
    Currently there is no option to recover a dropped table in Hbase directly.
    But there are some possible ways of to recover the same with restrictions.

    2. Whether any new column family we can add after table is created?
    Yes, you can use alter function to add new column family to table.

    hbase(main):015:0> alter 'tablename', {NAME=> 'columnfamily2'}
    Updating all regions with the new schema...
    0/1 regions updated.
    1/1 regions updated.

    3. How to insert bulk data in hbase through excel ?

    Please refer the below link,
    https://community.hortonworks.com/articles/4942/import-csv-data-into-hbase-using-importtsv.html

    Regards
    Karthik
     
    #2
  3. _6230

    _6230 Well-Known Member
    Alumni

    Joined:
    Apr 4, 2017
    Messages:
    152
    Likes Received:
    8
    Thanks for taking my queries and sharing the link. Please elaborate point1 in details or give some example to recover table in Hbase.
     
    #3
  4. Karthik Shivana

    Karthik Shivana Moderator
    Simplilearn Support

    Joined:
    Apr 1, 2016
    Messages:
    590
    Likes Received:
    21
    Hi

    Please find the below example w
     
    #4
  5. Karthik Shivana

    Karthik Shivana Moderator
    Simplilearn Support

    Joined:
    Apr 1, 2016
    Messages:
    590
    Likes Received:
    21
    Hi,

    Please find the below attached hbase example as you requested.
     

    Attached Files:

    #5
  6. _6230

    _6230 Well-Known Member
    Alumni

    Joined:
    Apr 4, 2017
    Messages:
    152
    Likes Received:
    8
    thank you
     
    #6

Share This Page