Version 1.94.01
Contents
1. HareDB com Create Table 1 Select a connection and connect to HBase Reference Connect to HBase 2 Right click on the connection icon and it will pop up a menu 3 Please select Create Table and it will pop up a windows Create Table Disconnect D Open HQL command Refresh Create HTable Table Name Add Column Family Delete Column Family Column Family MaxVersion Cancel 4 Input a table name Create HTable Table Name First_Table Add Column Family Delete Column Family Column Family MaxVersion HareDB com http sourceforge net http www haredb com rojects haredbhbaseclie 5 Atleast input a column family Of course you can delete column family Create HTable Table HBase Table Meta Add Column f1 Family S Max version 3 Create HTable Table Name First_Table Add Column Family Delete Column Family Column Family MaxVersion f en 3 Ok Cancel Create HTable Table Name First_Table Add Column Family Delete Column Family Column Family MaxVersion cf1 3 cf2 3 Ok Cancel 6 Press OK Ms 7 You can check the table you just created in the table list Allen First_Table 10 http www haredb com http sourceforge net projects haredbhbaseclie HareDB com Alter Table 1 Select an connection to connect to HBase Reference Connect to HBase 2 Right click on the HTable you wa2. Create Hive MetaData HBase Table Name First Table Column Name rowkey Type ColumnFamily Qualifier String key Create Meta Cancel EI 18 http www haredb com http sourceforge net projects haredbhbaseclie HareDB com Query Data Register a coprocessor 1 According to the HBase we must register coprocessor for the table first before using it Select a connection and connect to HBase Reference Connect to HBase Right click on the table which you want to register for it and system will pop up a ap First Tab opassen HH Hubert Alter table HA Hubert0o7 _ BI zo test Drop table HHLZO_ TEST HHLZO_TEST Create meta HH PreSpliit Create hive HHsSaleamou Es 72772 Table EH bulkload HH bulkloadi Refresh LD __ 4 Click Coprocessor and system will pop up a window Register Coprocessor Coprocessor Path 19 http www haredb com http sourceforge net projects haredbhbaseclie HareDB com 5 Click Add Coprocessor and system will pop up another window 6 Please select BaseHiveQLEndpoint and fill the Path xxxx jar Example haregl jar Add Coprocessor Coprocessor com haredb hbase hive coprocessor BaseHiveQLEndpoint Coprocessor Path i e Currently we must name the jar of coprocessor hdfs host3 9000 hareqljar REN Corn stem fhanekie Cancel L 7 Press OK here is the success screenshot as fol
3. Embedded Driver class com mysgl jdbc Driver e Local Remote User name root Password 123456 A http www haredb com http sourceforge net projects haredbhbaseclie HareDB com Connection Manager Connection host Connection Name Allen host Zookeeper Host ip hosts host ZooKeeper Client Port 2181 host3 host4 fs default name hdfs host3 9000 ex hdfs hostname 3000 hosts mapred job tracker hdfs host3 9001 ex hafs hostname 9001 host6 Hive metastore host9 Embedded e Local Metastore Uris Remote After filling the information we have to click the button Hereafter the new connection will appear to the connection list in the left side of Connection Manager Alter Connection 1 Open Connection Manager Reference Connection Manager 2 Select a connection you want to alter in the connection list Furthermore the information of the connection you selected will show up at the right side of the Connection Manager 3 To modify any information you want to then click the button Delete Connection 1 Open Connection Manager Reference Connection Manager 2 Right click on the connection you want to delete Then it will pop up a menu http www haredb com HareDB com http sourceforge net projects haredbhbaseclie m ll m n Clone ab Rename I Delete LS ee EZ I 3 Please select Delete and it s done R
4. HareDB com HareDB HBase Client Web Version USER MANUAL HAREDB TEAM http www haredb com http sourceforge net projects haredbhbaseclie HareDB com OSCE el Src ee er ee er ee 2 ENEE 3 COR egen Manag E 3 Add anew COMME CIO een 4 EH 6 Dete COnN CO EE 6 One COnN CHUO EE 7 Rename Conpnecton ENNEN 7 Te ee ee 8 72 I a ee E ee ee 9 ARO TO ee a ne ea nee 11 Edit Col mn Family s Properties nie 13 Drop TIO ee ee nee ee 15 TODE NICK ee ee re 16 EE e E E ENERGIE E E EE 16 Create IV TAB VE 18 EEN Eege EEN 19 Register CODrOCESS e 19 Open HAL COMMaAN E 20 open ATID eae A E E E 23 OBEN ME EE 24 http www haredb com http sourceforge net projects haredbhbaseclie HareDB com Connect to HBase 1 Click the icon Bi 2 Select a connection you want to connect to HAAZ mhosto mhost1 host hosts mhost4 hosts hosts hosts Manage Connections ZS Connecting 3 The system will try to connect to HBase and show 4 After connection is succeed the connection node will show up Allen HareDB com Connection We define a Connection which has two parts of information One is for Hadoop and HBase Cluster Another is for Hive metastore which is a place to store meta Connection Manager 1 Connection Manager is a component which can help us to add modify and delete a connection There is an item Manage Connections in the bottom o
5. http www haredb com http sourceforge net projects haredbhbaseclie HareDB com Open HTable 1 Select a connection and connect to HBase Reference Connect to HBase 2 Double click the table or right click on the table and system will pop up a menu Select OpenHTable H First_Table 1 Open HTable EE id amc HHFirst_Tabl Coprocessor Alter table Hubert Drop table HHubertoo THLZO_TES THLZO_TES THLZO_TES PreSpliit HH SaleAmot fea zzzz H bulkload bulkloadi 2 Refresh FH daan ec Create meta Create hive Table 3 You can click Query f Than data will show up as follow First_Table Column Families kl cf cf2 Show rows 10 Put New Qualifier Delete Refresh Commit RowKey cf1 customer_id cf1 customer_name J cf1 t_amount 20131125 001 C003 appale 300000 20131201 001 Era Sony 10000 20131201 002 C002 htc 123456 http www haredb com http sourceforge net projects haredbhbaseclie HareDB com Open Hive Table 1 Select a connection and connect to HBase Reference Connect to HBase 2 Double click the Hive table mm or right click on the table and system will pop up a menu and select Open hive Table H First_Tablei susuonmernu allen eg firsthivetable HH Hubert Open hive Table HH Hubert007 Rename hive table THLZO TEST z Alter hive table HHLZO_TEST1 FH zo TEst2 Drop hive
6. table HH PreSpiliit HHSaleAmount 9 Refresh Fad 72272 Pe Bu 3 System will show the hive table with data in the right side as fellow rowkey id name phone company aaa rk1 9 stana 03 5630345 14 IS Land rk1aaa rk2 9 stana N32 SRANRAB HY 4 IS Land rk2aaa rk3 10 dif 03 5630345 14 IS Land rk3aaa rk4 10 dif 03 5630345 14 IS Land rk4aaa 4 You can input some criteria in filter area than click Execute You will get the result Filter id 9 and aaa rklaaa RowKey id name phone company aaa rk1 9 stana 03 5630345 14 IS Land rkiaaa 24
7. cel Screenshot of Create Meta without suggestion 4 Rowkey is a must row don t delete it 5 Insert Column gt Click Insert Column gt System will pop up a window Insert Column Column Name Row Key sn les 3 m Column Family Qualifier Cancel N gt Column Name Any name you want gt Data Type this type must the same with the type while you input it to HBase 17 HareDB com http www haredb com http sourceforge net projects haredbhbaseclie gt We support these types as follow boolean double long short float bigdecimal gt Column Family and Qualifier must be the same with your HBase column which you want to map Be careful it s case sensitive Create Hive Table Selecta connection and connect to HBase Reference Connect to HBase 2 Right click on the table which you want to create hive table for it and system will pop up a menu 3 Click Create hive table and system will pop up a windows HA First_Tab H Hubert HH Hubertoo Bo mee Bio rte BL zo TES BO PreSpliit BI SaleAmot Hr HA bulkload HA bulkload1 He dean LD First_Tab Open HTable Coprocessor Alter table Drop table Create meta Create hive Table Refresh 4 Input a table name 5 And you can insert modify column and delete column Reference Create Meta
8. ename Delete ei TTS SF VS a Eng ar Clone Connection 1 Open Connection Manager Reference Connection Manager 2 Right click on the connection you want to clone Then it will pop up a menu wem H 7 n Clone Rename l Delete ei T Tre KRACK I 3 Please select Clone System will up an input window L_ Al Clone Rename ar m a Tear Ae 4 Please input a connection name Please input connection name test1 Rename Connection 1 Open Connection Manager Reference Connection Manager 2 Right click on the connection you want to rename Then it will pop up a menu http www haredb com HareDB com http sourceforge net projects haredbhbaseclie el Rename Clone ou Delete E Ze u Du Bus Be kb Tee I 3 Please select Rename System will up an input window n Clone Rename 4 u Delete LR et we ew Kabel 4 Please input a new connection name Please input connection name test1 Tables We defines 3 kinds of table Each kinds of table has different icon FH It s an HBase table with no table metadata It s an HBase table with table metadata e vi WR It s a Hive table with table metadata This hive table is a child of HBase table HH stana fied tablet ee table07641 http www haredb com http sourceforge net projects haredbhbaseclie
9. f the connection list Please select Manage Connections Alien mhost mhost1 mhost2 mhost3 mhost4 mhosts Mhosts 4 After step 2 System will pop up a Connection Manager windows Connection Manager New host0 host1 host2 host3 host4 host5 host6 host9 Connection Connection Name host5 e ZooKeeper Host ip host3 ZooKeeper Client Port 2181 fs default name hdfs host3 9000 ex hdfs hostname 9000 mapred job tracker hdfs host3 9001 ex hdfs hostname 9001 Hive metastore Cc Embedded Local Path Remote E There are 3 areas in the Connection Manager window http www haredb com http sourceforge net projects haredbhbaseclie http www haredb com http sourceforge net projects haredbhbaseclie HareDB com Area A It is a connection list which contents all connections you have Area B There are information of the connection you selected related with Hadoop and HBase Cluster Area C There are information of the connection you selected related hive metastore Add a new Connection 1 to open a Connection Manager New 2 Click the button Connection Manager Connection Connection Name host1 ZooKeeper Host ip hast2 ZooKeeper Client Port hast3 host4 fs_default name ex hdfs hostname 9000 hosts mapred job tracker ex hdfs hostname 9001 hast6 Di va Hive metastore hast9 Embedded ce Local ce Remote be Here are
10. low Register Coprocessor Coprocessor Path coprocessor 1 com haredb hbase_hive coprocessor BaseHiveQL Endpoint Open HQL Command 1 Register a coprocessor Our HQL HareQL Command is implemented by HBase coprocessor According to the HBase we must register coprocessor first before using it Reference Register Coprocessor 20 Al HareDB com Select a connection and connect to HBase Reference Connect to HBase Right click on the connection icon and system will pop up a menu Create Table Disconnect THE Open HQL command si Refresh 4 Click Open HQL command and system will pop up a window like fellow HQL Commands Run Clean Refresh meta 1 Cancel Mi http www haredb com http sourceforge net projects haredbhbaseclie 21 HareDB com http http www haredb com sourceforge net projects haredbhbaseclie 5 You can use sql here to query data but just Select no Insert Update Delete and DDL HQL Commands Run Clean Refresh meta This Table First_Table must register coprocessor we can add tab each tab can run one sql select from First_Table 477777777 we can input SQL here but currently not support join RowKey cf customer_name C001 Sony C002 htc C003 appale ex 6 After you input the sql press the RUN cf1 t_amount 10000 123456 300000 Cancel E ER
11. nt to alter and system will pop up a menu 3 Please select Alter Table and it will pop up a windows Jad Open HTable HHLZ Coprocessor oes sc Alter table FH Lz FA bu Drop table A bu Bil de Create meta F Refresh Her You can add column family or delete column family here However please be careful while you are deleting column family Deleting column family will lose your data which is belong to the column family Add Column Family Alter HTable Add Column Family Delete Column Family Edit Column Family Column Family MaxVersion Cancel j N 11 http www haredb com http sourceforge net projects haredbhbaseclie HareDB com HBase Table Meta Column er Family Max version 3 Cancel 4 Alter HTable Add Column Family Delete Column Family Edit Column Family Column Family MaxVersion Ok Cancel E Drop Column Family Alter HTable Add Column Family Delete Column Family Edit Column Family Column Family MaxVersion cfi 3 Ok Cancel 4 12 http www haredb com http sourceforge net projects haredbhbaseclie HareDB com Alter HTable Add Column Family Delete Column Family Edit Column Family Column Family MaxVersion le 3 Ok Cancel Edit Column Family s Properties 1 Please open the Alter Table Windows Refe
12. ow there is no schema in HBase We only define table name and column families while we are creating HBase table Furthermore there is no data type in HBase Everything is stored as a byte in HBase However if we don t know the correct type we can t cast the byte to the correct type and we can t read it correctly So we provide some metadata manage tool for you Create Meta Select a connection and connect to HBase Reference Connect to HBase Right click on the table which you want to create meta and it will pop up a menu HA First mes HAFirst Open HTable ERA Hub Coprocessor HH Hub Alter table FH zo HHLZo FH Lzo EUR Create meta BI ale Bis Create hive FH bulk Table HA bulk HH dear Refresh EER a Drop table Click Create meta and it will pop up a windows If the table has some hive tables already system will give you a suggestion according to those hive tables Create Hive MetaData HBase Table Name First_Table1 Column Name Type ColumnFamily Qualifier hubertkey string key customerid string cf1 customer po_amount string cf1 sales_name Create Meta Cancel E Screenshot of Create Meta with suggestion 16 http www haredb com http sourceforge net projects haredbhbaseclie HareDB com Create Hive MetaData HBase Table Name Column Name Type ColumnFamily Qualifier rowkey Create Meta Can
13. rence Alter Table Alter HTable Add Column Family Delete Column Family Edit Column Family Column Family MaxVersion fort 3 Ok Cancel 2 Select a Column Family Alter HTable Add Column Family Delete Column Family Edit Column Family Column Family MaxVersion 13 http www haredb com http sourceforge net projects haredbhbaseclie HareDB com 3 Click Edit Column Family and system will pop up a window 4 You can modify most properties Edit Column Family Property Value Column Family Name cf 1 Data Block Encoding NONE v Bloom Filter NONE Replication Scope 0 Version 3 Compression NONE e Min versions 0 TTL 2147483647 i Keep Deleted Cells false Block Size 65536 14 http www haredb com http sourceforge net projects haredbhbaseclie HareDB com Drop Table 1 Select a connection and connect to HBase Reference Connect to HBase 2 Right click on the connection icon and it will pop up a menu Open HTable HHL Coprocessor HHL Alter table Lz m Drop table Hs ZE Create meta T Wo Create Mappin go TC pping EH bi SBS de 3 Please select Drop Table and it will pop up a message Are you sure to drop Cancel 15 http www haredb com http sourceforge net projects haredbhbaseclie HareDB com Table metadata As we kn
14. the information you need Connection Connection Name Just a name which will show up at the connection list Zookeeper Host ip Input zookeeper s host name or ip If you have ZooKeeper Client Port Input the port that your request can through http www haredb com http sourceforge net projects haredbhbaseclie HareDB com Hive metastore These information is for metadata of the HTable We rely on the metadata database of Apache Hive We support all kinds of hive metadata database First it s Embedded If you don t have any hive metadata database or you don t install hive or even you don t know what is Hive Please select Embedded Second it s Local If you have an rdb to be a Hive metadata database please select Local And please input the rdb connection information Third it s Remote Apache Hive provide a thrift service to interactive with metadata database So please provide the url of thrift server For example http 192 168 1 11 10000 192 168 1 11 gt your hive thrift server 10000 gt Thrift server port Connection Manager Connection hosti Connection Name Allen hosti Zo0Keeper Host ip hosts host fookeeper Client Port 2151 host3 host4 fs default name hdfs host3 9000 ex hdfs hastname 3000 hosts mapred job tracker hdfs host3 9001 ex hdfs hostname 9001 host6 Hive metastore host9 Jdbe Url jdbc mysql host3 3306 metastor
Download Pdf Manuals
Related Search