Dear Wiki user, You have subscribed to a wiki page or wiki category on "Lucene-hadoop Wiki" for change notification.
The following page has been changed by udanax: http://wiki.apache.org/lucene-hadoop/Hbase/HbaseShell ------------------------------------------------------------------------------ * [:Hbase/HbaseShell/PHP:PHP HQL] Connect. * [http://shell.hadoop.co.kr/PHPClient.php HQL query test site] on 2 node cluster Hbase - = Hbase Shell Query Language Commands = + = Hbase Query Language Commands = '''Note''' that attribute values are quoted with either single or double quotes. - == Hbase Shell Basic Commands == + == Basic Query Commands == ||<bgcolor="#ececec">'''Command''' ||<bgcolor="#ececec">'''Explanation''' || ||Help ||<99%>'''Help''' command provides information about the use of shell script.[[BR]][[BR]]~-''HELP [function_name];''-~ || ||Show ||<99%>'''Show''' command lists tables.[[BR]][[BR]]~-''SHOW tables;''-~ || @@ -71, +71 @@ ||Select ||<99%>'''Select''' command retrieves rows from a table.[[BR]][[BR]]~-''SELECT { column_name [, column_name] ... | * }[[BR]]{{{ }}}FROM table_name[[BR]]{{{ }}}[WHERE row = 'row-key' | STARTING FROM 'row-key'][[BR]]{{{ }}}[NUM_VERSIONS = version_count][[BR]]{{{ }}}[TIMESTAMP 'timestamp'][[BR]]{{{ }}}[LIMIT = row_count][[BR]]{{{ }}}[INTO FILE 'file_name'][[BR]][[BR]]''-~'''column_name:'''~-''[[BR]]{{{ }}}column_family_name[[BR]]{{{ }}}| column_family_name:column_label_name''-~ || - == Hbase Shell Algebraic Commands == + == Algebraic Query Commands == ||<bgcolor="#E5E5E5">'''Command''' ||<bgcolor="#E5E5E5">'''Explanation''' || ||Table ||<99%>'''Table''' command loads specified table. [[BR]][[BR]]~-''Table('table_name');''-~ || @@ -80, +80 @@ ---- = Example = - == Example Of Basic Command Uses == + == Example Of Basic Query Command Uses == === Create the table in a Hbase === {{{ @@ -181, +181 @@ }}} - == Example Of Relational Algebraic Command Uses == + == Example Of Relational Algebraic Query Command Uses == === Relational Projection ===