Netezza Export Table Data into Excel Format

You can export the Netezza table in many ways. You can export the data to CSV format using either Netezza external table or Netezza nzsql commands with - o option. Netezza does not support exporting data to excel (xls/xlsx) format. You have to perform some work around to get data out to excel format. In this article, we will check Netezza Export Table Data into Excel Format. Netezza Export Table Data into Excel Format Netezza export table data into excel format involves two steps: Export Netezza table data to CSV…

Continue ReadingNetezza Export Table Data into Excel Format
Comments Off on Netezza Export Table Data into Excel Format

Sqoop import Relational Database Table into HBase Table

Apache Sqoop can be used to transform relational database table into HBase tables. You have to follow some process to import relational database or data warehouse tables into HBase schema. In this article, we will check on Sqoop import relational database table into HBase table and some working examples for the same. Sqoop import Relational Database Table into HBase Table You cannot directly import entire data warehouse or relational database tables into HBase. HBase is column oriented and the schema design is way different for HBase tables compared to Hive…

Continue ReadingSqoop import Relational Database Table into HBase Table
Comments Off on Sqoop import Relational Database Table into HBase Table

Apache HBase Bulk Load CSV and Examples

Apache HBase starts where Hadoop HDFS stops, i.e. HBase provides random, realtime read/write access to the Bigdata. If you have flat files such as CSV and TSV, you can use Apache HBase bulk load CSV and TSV features to get the data into HBase tables. In this post, I will tell you how to import data to HBase from CSV and TSV files. We will not dig into any transformation. We will check importing data into already existing HBase table. HBase Importtsv utility Importtsv is a utility that will load…

Continue ReadingApache HBase Bulk Load CSV and Examples
2 Comments

Check Netezza System Configurations using System Commands

Verifying the Netezza system configuration is basic step to identify any issues with the system. You can troubleshoot the problem once you identify the same. In this article, we will see how to check Netezza system configurations using system commands and see some of examples. Netezza System Configurations All the Netezza system configuration details are available in system.cfg file. This configuration file contains configuration settings that the Netezza uses for system startup, system management, host processes, and SPUs. It is advised to get in touch with IBM support team before…

Continue ReadingCheck Netezza System Configurations using System Commands
Comments Off on Check Netezza System Configurations using System Commands

Commonly used HBase Data Manipulation Shell Commands

Hbase is usually installed on the top of the Hadoop and it uses the Hadoop file system for its storage. Just like other Bigdata framework such as Hive, Pig etc, Hbase provides jruby interactive shell. You can also use various Java API to interact with HBase. In this article, we will check some commonly used HBase Data Manipulation shell commands and explanation on how to use them. Commonly used HBase Data Manipulation Shell Commands HBase provide many data manipulation shell commands that you can use on the interactive shell to…

Continue ReadingCommonly used HBase Data Manipulation Shell Commands
Comments Off on Commonly used HBase Data Manipulation Shell Commands

Read HBase Tables using scan shell command and examples

The set of HBase basic operations are referred to as CRUD operations. i.e. create, read, update, delete operations. HBase scan command is used to get data out of HBase tables. In this article, we will check how to read HBase tables using scan shell command and various examples. HBase scan command The HBase scan command is yet another HBase shell command that you can use to read the table. Scan command is similar to HBase get shell command but supports more options. The HBase scan command scans entire table and…

Continue ReadingRead HBase Tables using scan shell command and examples
Comments Off on Read HBase Tables using scan shell command and examples

Commonly used HBase Table Management Shell Commands

Hbase is installed on the top of the Hadoop and it uses the Hadoop file system only. Just like other Bigdata framework such as Hive, Pig etc, Hbase provides jruby interactive shell. You can also use the Java API to interact with Hbase. In this article, we will check some commonly used HBase table management shell commands and explanation on how to use them. Commonly used HBase Table Management Shell Commands In HBase, jruby interactive shell mode is used to interact with HBase for table operations, table management, and data modeling.…

Continue ReadingCommonly used HBase Table Management Shell Commands
Comments Off on Commonly used HBase Table Management Shell Commands

Hbase Namespace Commands and Examples

You can compare the namespace to the RDBMS shema’s. You can create the namespace in the HBase table and then create multiple tables in that namespace. In this article, we will check out Hbase namespace commands with an examples. Hbase Namespace Commands There are three commonly used namespace commands: create_namespace, alter_namespace, describe_namespace, drop_namespace, list_namespace, list_namespace_tables HBase create_namesace command This command is used to create a namespace in the HBase. Below are the examples to create namespace: hbase(main):019:0> create 'test:test1','cf' 0 row(s) in 2.3760 seconds => Hbase::Table - test:test1 Create Table inside…

Continue ReadingHbase Namespace Commands and Examples
2 Comments

Commonly used General Hbase Shell Commands

Hbase is installed on the top of the Hadoop and it uses the Hadoop file system only. Just like other Bigdata framework such as Hive, Pig etc, Hbase provides interactive shell. You can also use the Java API to interact with Hbase. In this article, we will check some commonly used general Hbase shell commands. Commonly used General Hbase Shell Commands In HBase, interactive shell mode is used to interact with HBase for table operations, table management, and data modeling. We will check out the general Hbase shell commands. There…

Continue ReadingCommonly used General Hbase Shell Commands
Comments Off on Commonly used General Hbase Shell Commands

Drop HBase Tables using shell Commands and Examples

The set of HBase basic operations are referred to as CRUD operations. i.e. create, read, update, delete/drop operations. The HBase drop command is used to drop or delete table from HBase. In this article, we will check drop HBase tables using shell commands and some commonly used examples. Drop HBase Tables using shell Commands In order to drop or delete the table present in HBase, first we have to disable it using ‘disable <table name>’ command. There are two commands available to drop or delete HBase tables: ‘drop’ and ‘drop_all’.…

Continue ReadingDrop HBase Tables using shell Commands and Examples
Comments Off on Drop HBase Tables using shell Commands and Examples