Alter HBase Table using shell command and Examples

You may have to modify properties of the existing table to add more column families or to modify the table attributes. HBase has ‘alter’ command’. In this article, we will check alter HBase table using shell command with some common examples to alter HBase table. Alter HBase Table using shell command This command alters the column family schema. You can use the HBase Alter shell command used to make changes to an existing table. Using this command, you can change the table properties or attributes such as set version, set…

Continue ReadingAlter HBase Table using shell command and Examples
Comments Off on Alter HBase Table using shell command and Examples

HBase Delete Row using HBase shell Command and Examples

The set of HBase basic operations are referred to as CRUD operations. i.e. create, read, update, delete operations. HBase delete operation is nothing but delete command in HBase shell. The delete command is used to delete data from HBase tables. In this article, we will check HBase delete row using HBase shell command and some examples. HBase Delete Row using HBase shell Command HBase shell delete command will delete cell value at defined table of row or column in the HBase table. You can even delete the entire row of…

Continue ReadingHBase Delete Row using HBase shell Command and Examples
Comments Off on HBase Delete Row using HBase shell Command and Examples

Insert data using HBase shell put Command and Examples

The set of HBase basic operations are referred to as CRUD operations. i.e. create, read, update, delete operations. HBase Create operation is nothing but put command. The put command is used to insert the data into HBase tables. In this article, we will check how to insert data using HBase shell put command. In this article, we have concentrated only on shell commands. Consider the below table that we are going to create in HBase for ‘Insert data using HBase shell put command’ implementation. Read: Create Tables using HBase Shell…

Continue ReadingInsert data using HBase shell put Command and Examples
2 Comments

Read HBase Table using HBase shell get Command and Examples

The set of HBase basic operations are referred to as CRUD operations. i.e. create, read, update, delete operations. HBase read operation is nothing but get command in HBase shell. The get command is used to read the data from HBase tables. In this article, we will check how to read HBase table using HBase shell get command. Read HBase Table using HBase shell get Command By using HBase shell get command, you will get a row or cell contents present in the table. In addition to that you can also…

Continue ReadingRead HBase Table using HBase shell get Command and Examples
Comments Off on Read HBase Table using HBase shell get Command and Examples

Create Tables using HBase Shell and Examples

HBase tables are way different compared to the relational database tables. HBase organizes all data into tables. Table names are Strings and composed of characters that are easy and safe for use in a file system path. In this article, we will check create tables using HBase shell commands and examples. We will create the sample tables will couple of columns and insert some sample values to verify the tables. Create Tables using HBase Shell You can create a table using the create command in HBase, table name and the Column Family…

Continue ReadingCreate Tables using HBase Shell and Examples
Comments Off on Create Tables using HBase Shell and Examples

HBase Architecture and its Components

HBase is an open-source, distributed key value data store, column-oriented database running on top of HDFS. HBase Architecture has high write throughput and low latency random read performance. Facebook uses HBase: Leading social media Facebook uses the HBase for its messenger service. Facebook has customised the HBase as HydraBase to meet their requirements to integrate SMS, chat, email and Facebook Messages into one inbox. Apart from messenger, HBase is used in production by other Facebook services, including internal monitoring system, Nearby Friends feature, search indexing, streaming data analysis, and data…

Continue ReadingHBase Architecture and its Components
Comments Off on HBase Architecture and its Components

How Teradata Data Distribution Works on AMPs?

This article is about how Teradata data distribution works on the various AMP's present in the Teradata system. What is AMP? Before going in detail in the Teradata data distribution, lets check what AMP is? AMP, acronym for Access Module Processor, is the Virtual Processor (vproc) used to manage the database, handle file tasks and and manipulate the disk subsystem in the multi-tasking and possibly parallel-processing environment of the Teradata Database. Each AMP then contained its own microprocessor, disk drive, file system, database software (Database Manager), Teradata Operating System (TOS),…

Continue ReadingHow Teradata Data Distribution Works on AMPs?
Comments Off on How Teradata Data Distribution Works on AMPs?

Netezza Recursive Query Alternative and Examples

A recursive query is a way to query hierarchies of data, such as an organizational structure, bill-of-materials, and document hierarchy. Netezza does not support either WITH RECURSIVE Clause or Using the RECURSIVE Clause in a CREATE VIEW Statement. In this article, we will check Netezza Recursive Query Alternative with an working example. Netezza Recursive Query Alternative In the other RDBMS such as Teradata you can specify a recursive query by preceding a query with the WITH RECURSIVE clause or creating a view using the RECURSIVE clause in a CREATE VIEW…

Continue ReadingNetezza Recursive Query Alternative and Examples
Comments Off on Netezza Recursive Query Alternative and Examples

Teradata Architecture – Components of Teradata

The biggest strength of Teradata and Netezza data warehouse appliance (RDBMS) is parallel processing. Just like Netezza architecture, Teradata architecture is based on Massively Parallel Processing (MPP) architecture. The Teradata is made up of Parsing Engine, BYNET and Access Module Processors (AMPs) and other components such as nodes. Teradata is inexpensive, high-quality system that exceeded the performance of conventional relational database management systems. Read: Commonly used Teradata Date Functions and Examples Teradata Analytics Functions and Examples Teradata Set Operators: UNION, UNION ALL, INTERSECT, EXCEPT/MINUS Teradata Architecture – Components of Teradata…

Continue ReadingTeradata Architecture – Components of Teradata
Comments Off on Teradata Architecture – Components of Teradata

Netezza Subqueries and Type of Subqueries with an Examples

A subquery in Netezza is a select expression that is enclosed in parentheses as a nested query block in a query statement. The Subquery may return zero to one or more values to its upper select statements. In this article, we will check Netezza subqueries and and type of subqueries available with an examples. Netezza Subqueries and Type of Subqueries As mentioned earlier, Netezza subquery is a select expression enclosed in parenthesis as a nested query block. You can use these nested query blocks in any of the following SQL…

Continue ReadingNetezza Subqueries and Type of Subqueries with an Examples
Comments Off on Netezza Subqueries and Type of Subqueries with an Examples