HBase is an open source, non-relational, distributed database modeled after Google’sBig Table and written in Java. It is developed as part of Apache Software Foundation’s Apache Hadoop project and runs on top of HDFS (Hadoop Distributed Filesystem), providing Big Table-like capabilities for Hadoop. That is, it provides a fault-tolerant way of storing large quantities of sparse data.
HBase is not a direct replacement for a classic SQLdatabase, however Apache Phoenix project provides a SQL layer for HBase as well as JDBC driver that can be integrated with various analytics and business intelligence applications.
HBase tab provides user friendly interface to manage and run HBase scripts at ease. It provides following features.
Interactively run HBase scripts
HBase scripts can be run interactively from within Big Data Studio by directly typing HBase queries into the provided console.
You can run all queries in the script file loaded in Editor through interactive console one by one by clicking “Run All” button or by choosing the “Run in Console” option in context menu.
You can run selected queries in the script file through interactive console one by one by clicking “Run Selection” button or by choosing the “Run Selection in Console” option in context menu.
Autocomplete feature is added in the Editor. It will provide suggestion for the keywords based on user typing and allows the user to accept the suggestion or select by pressing “down arrow” key.
Manage script files
You can create new script file and load a file using “Script” button.
You can save as a file using “Save As” button.
You have option to import scripts from folder, create new script and delete scripts present in the tree view.
We ship several samples which you can use it for getting started.
Working with HBase Namespace
Big Data studio provides simple interface to create new namespace, table and an option to manage Hive namespaces with tree like explorer.
To create a new namespace, click “New Namespace” button in the HBase tab, provide HBase namespace name in the editor area of the prompt box.
To create a new table, click “New Table” button in the HBase tab, provide HBase query to create table based on the template provided in the editor area of the prompt box.
HBase Data explorer
You can explore the namespaces and tables in HBase in simple tree like view under Tables tab.
Goto context menu by right clicking the namespaces/ tables/ empty tree and explore the available options.
You can create namespace, table, view top 500 rows, drop namespace and table, alter table and add a new column with a simple interface
Access HBase data from .NET applications
Data that is stored in HBase can be accessed through a Syncfusion provided .NET API (Syncfusion.ThriftHBase.Base). This API provides user friendly access to HBase data from within the .NET environment. Several samples are shipped with the Big Data Studio product. You can navigate to these from the Syncfusion Big Data dashboard as shown below.
HBase C# samples
Select any platform from the dashboard under “C# HBase samples” to view the corresponding sample browser. Below screenshot shows the WPF sample browser.
Please note that these samples always connect to the local instance of Syncfusion Big Data. You will have to change the server in code to connect to a remote Syncfusion Big Data server.
For more information about the Thrift library (Syncfusion.ThriftHBase.Base), refer the documentation link available here.