General

Search for String Pattern in Netezza Database: Google Like Search

Have you ever wondered how to search for string pattern in Netezza database? Here is one of the method that I used in our organisation to search for string pattern in Netezza database. This is process will take bit time to search full Netezza database. Here we have used the current_catalog to search for string pattern in current database. You can pass the database name and string pattern as a form parameter if you have any front end. You can build the query and get the desired results. Read: Netezza…

Continue ReadingSearch for String Pattern in Netezza Database: Google Like Search
Comments Off on Search for String Pattern in Netezza Database: Google Like Search
November 5, 2016
General

Netezza Cumulative Sum, Average and Example

You can make use of the Netezza analytical functions to calculate the cumulative sum or running sum. Sum and Average analytical functions are used along with window options to calculate the Netezza cumulative sum or running sum. Read: Identify and Remove Netezza Duplicate Records in Table IBM Netezza Extract Numbers from String Examples Netezza Pivot Rows to Column With Example Netezza Update Join Syntax and Examples Netezza Recursive Query Alternative and Examples IBM Netezza Rollup Group Aggregates using Grouping sets  Netezza Cumulative Sum, Average Syntax: Below are the Syntax for…

Continue ReadingNetezza Cumulative Sum, Average and Example
Comments Off on Netezza Cumulative Sum, Average and Example
November 5, 2016
Netezza

Basic Netezza Linux Commands to Learn Netezza

In this post you will learn about some basic Netezza Linux commands. As you know, Netezza is Linux based data warehouse appliance that doesn’t have any UI. To get started you need to know some basic Netezza Linux commands to move through the Linux directories, find files, find directory size, create folders, create folders, and use some standard file editor to create file. Read: Commonly used Netezza Basic Commands Basic Netezza Linux Commands Here are the quick and lists of basic Netezza Linux commands that are frequently used when working…

Continue ReadingBasic Netezza Linux Commands to Learn Netezza
Comments Off on Basic Netezza Linux Commands to Learn Netezza
November 2, 2016
Netezza

Commonly used Netezza Basic Commands

In this post you will learn about some commonly day to day Netezza basic commands. There are lot of Netezza basic commands available along with Netezza commonly used utilities that are used but here are listed some commonly used commands. Read: Netezza Commonly used Utilities Basic Netezza Linux Commands to Learn Netezza nzrev Command Check the Netezza build version [nz@netezza01 ~]$ nzrev Release 7.2.1.0 [Build 46322] [nz@netezza01 ~]$ nzstats Command Provide the statistics about the Netezza appliance [nz@netezza01 ~]$ nzstats Field Name Value -------------------- -------------------------------------------- Name netezza 01 Description <sys…

Continue ReadingCommonly used Netezza Basic Commands
Comments Off on Commonly used Netezza Basic Commands
November 1, 2016
Netezza

Netezza Failover – High Availability Architecture

Netezza appliance include necessary components to function seamlessly in the event of any hardware issue so that its availability is more that 99.99%. This is called Netezza high availability architecture that perform seamlessly in case of Netezza failover. There are two host in a cluster in all Netezza appliances so that if one fails other once can take over the task that is being carried out. Netezza Failover - High Availability Architecture Overview Netezza appliance uses the Linux-HA (high availability) and Distributed Replicated Block Device (DRBD) for the host cluster…

Continue ReadingNetezza Failover – High Availability Architecture
Comments Off on Netezza Failover – High Availability Architecture
October 31, 2016
BigData

Basic Hadoop HDFS Filesystem Operations With Examples

There are many interfaces to HDFS available, but the command line (CLI) is one of the simplest and, to many developers, the most familiar interface. You can perform most advanced and basic Hadoop HDFS filesystem operations using CLI. Basic Hadoop HDFS Filesystem Operations The when Hadoop HDFS filesystem is set, you can do all of the basic HDFS filesystem operations, such as reading files, creating directories, moving files, deleting data, and listing directories. You can also perform the advance Hadoop HDFS filesystem operations such as updates, administrator from command line.…

Continue ReadingBasic Hadoop HDFS Filesystem Operations With Examples
Comments Off on Basic Hadoop HDFS Filesystem Operations With Examples
October 31, 2016
BigData

Hadoop HDFS Schema Design for ETL Process

Now a day’s many organisations are using Hadoop for their ETL processing. In this post we will learn Hadoop HDFS Schema Design for ETL Process. In this section, you will learn about good schema design for data that you store in Hadoop HDFS directly. Hadoop HDFS Schema Design Overview Many organisation uses Hadoop for storing and processing unstructured, semi-structured or structured data. Hadoop is schema-on-read model that does not impose any requirements when loading data into Hadoop ecosystem. You can simply ingest data into Hadoop HDFS by using available ingestion…

Continue ReadingHadoop HDFS Schema Design for ETL Process
Comments Off on Hadoop HDFS Schema Design for ETL Process
October 26, 2016
BigData

Hadoop Data Warehouse and Design Considerations

A data warehouse, also known as an enterprise data warehouse (EDW), is a large collective store of data that is used to make such data-driven decisions, thereby becoming one of the centrepiece of an organization’s data infrastructure. Hadoop Data Warehouse was challenge in initial days when Hadoop was evolving but now with lots of improvement, it is very easy to develop Hadoop data warehouse Architecture. This article will server as a guide to Hadoop data warehouse system design. Hadoop data warehouse integration is now a days become very much popular…

Continue ReadingHadoop Data Warehouse and Design Considerations
Comments Off on Hadoop Data Warehouse and Design Considerations
October 26, 2016
Netezza

Netezza Backup and Restore: Best Practices

In this post you will learn about Netezza backup and restore data. It provides general information on backup and restore methods available with Netezza system. Netezza Backup and Restore Overview Netezza provides several backup and restore methods as per the different requirements. You can take table or database backup whenever required: You can create full and incremental backups of your various Netezza databases in compressed internal using the nzbackup command and restore them to a Netezza system whenever required using nzrestore command. As a best practice create script that perform…

Continue ReadingNetezza Backup and Restore: Best Practices
Comments Off on Netezza Backup and Restore: Best Practices
October 25, 2016
Netezza

Netezza Pad Zero with Working Example

Netezza pad zero functions are string functions used to remove or add the string to beginning or end of the expression. An expression could be column values. There are two pad functions available in Netezza; LPAD and RPAD string functions. You can use those function in Netezza pad zero or any other character provided in arguments: Read: Netezza String Functions and Usage Different types of Netezza Trim Functions and Examples Netezza Date Functions and Examples nzsql Command and its Usage Netezza LPAD function You can use this function to pad string…

Continue ReadingNetezza Pad Zero with Working Example
Comments Off on Netezza Pad Zero with Working Example
October 24, 2016