BigData

Hive Create External Tables and Examples

A Hive external table allows you to access external HDFS file as a regular managed tables. You can join the external table with other external table or managed table in the Hive to get required information or perform the complex transformations involving various tables. In this article, we will check on Hive create external tables with an examples. You have to create external table same as if you are creating managed tables. LOCATION is mandatory for creating external tables. LOCATION indicates the location of the HDFS flat file that you want…

Continue ReadingHive Create External Tables and Examples
Comments Off on Hive Create External Tables and Examples
October 26, 2017
General

Teradata Set Operators: UNION, UNION ALL, INTERSECT, EXCEPT/MINUS

You can use the Teradata set operators to combine similar data sets from two or more SELECT statements in the query. The data types of the columns which are being used in the Teradata SET operators should match or explicitly type cast column values to required data types. The SET operators are similar to the JOINs, the only difference is that join combines the columns from different tables whereas SET operators combine rows from different tables. Read: Teradata String Functions and Examples Commonly used Teradata Date Functions and Examples Teradata…

Continue ReadingTeradata Set Operators: UNION, UNION ALL, INTERSECT, EXCEPT/MINUS
Comments Off on Teradata Set Operators: UNION, UNION ALL, INTERSECT, EXCEPT/MINUS
October 25, 2017
General

Commonly used Teradata Date Functions and Examples

This article is about detailed descriptions and examples of the commonly used Teradata date functions that you can use to manipulate date columns in the Teradata, stored procedure or in embedded SQLs. In the real word scenario, many application manipulate the date and time data types. Date types are highly formatted and very complicated. Each date value contains the century, year, month, day, hour, minute, and second. Each RDBMS may employ different date functions, and there may also be differences in the syntax for each RDBMS even when the function…

Continue ReadingCommonly used Teradata Date Functions and Examples
Comments Off on Commonly used Teradata Date Functions and Examples
October 25, 2017
BigData

Hadoop Hive Create, Drop, Alter, Use Database Commands and Examples

Hadoop Hive is database framework on the top of Hadoop distributed file systems (HDFS) developed by Facebook to analyze structured data. It supports almost all commands that regular database supports. Hadoop hive create, drop, alter, use database commands are database DDL commands. This article explains these commands with an examples. Hive contains a default database named default. Read: Hive Create External Tables and Examples Hadoop Hive SHOW DATABASES commds This command displays all the databases available in Hive. Below is the example of using show database command: hive> show databases;…

Continue ReadingHadoop Hive Create, Drop, Alter, Use Database Commands and Examples
Comments Off on Hadoop Hive Create, Drop, Alter, Use Database Commands and Examples
October 12, 2017
BigData

Hive Create Table Command and Examples

The syntax of creating a Hive table is quite similar to creating a table using SQL. In this article explains Hive create table command and examples to create table in Hive command line interface. You will also learn on how to load data into created Hive table. Hive Create Table Command Hive Create Table statement is used to create table. You can also create the table hive while importing data using Sqoop command. To use, Sqoop create Hive table command, you should specify the --create-hive-table option in Sqoop command. You…

Continue ReadingHive Create Table Command and Examples
Comments Off on Hive Create Table Command and Examples
October 11, 2017
BigData

Teradata Analytics Functions and Examples

Teradata analytic functions compute an aggregate value that is based on a group of rows optionally partitioning among rows based on given partition column. Just like other analytics systems, Teradata analytics functions works on the group of rows and optionally ignores the NULL in the data. Teradata also released the analytics system which provides more useful methods. The regular Teradata also provides some useful analytics function that you can use to perform day to day aggregation for reporting. Read: Teradata String Functions and Examples Teradata Set Operators: UNION, UNION ALL,…

Continue ReadingTeradata Analytics Functions and Examples
Comments Off on Teradata Analytics Functions and Examples
October 11, 2017
BigData

Hadoop Hive Bucket Concept and Bucketing Examples

Hadoop Hive bucket concept is dividing Hive partition into number of equal clusters or buckets. The bucketing concept is very much similar to Netezza Organize on clause for table clustering. Hive bucket is decomposing the hive partitioned data into more manageable parts. Let us check out the example of Hive bucket usage. Let us say we have sales table with sales_date, product_id, product_dtl etc. The Hive table will be partitioned on sales_date and product_id as the second-level partition would have led to too many small partitions in HDFS. To tackle this…

Continue ReadingHadoop Hive Bucket Concept and Bucketing Examples
Comments Off on Hadoop Hive Bucket Concept and Bucketing Examples
October 10, 2017
BigData

Load HBase Table from Apache Hive – Examples

In my other post “Sqoop import Relational Database Table into HBase Table” you learned on how to import data from relational database systems such as Netezza. And we have also seen how to export the HBase table data to relational database using Hive framework. In this article, we will check how to load HBase table from Apache Hive with an example. Why you want Load HBase Table from Apache Hive? This is obvious question, why you want to load HBase table from apache Hive? You may offload part of the…

Continue ReadingLoad HBase Table from Apache Hive – Examples
Comments Off on Load HBase Table from Apache Hive – Examples
October 9, 2017
BigData

Apache Hive Load Quoted Values CSV File and Examples

If you are reading this post, then you probably are considering using BigData or started BigData ecosystem for your huge data processing. When you say huge data, that means you may get all different kind of structured, unstructured and semi-structured data. Hive is just like your regular data warehouse appliances and you may receive files with single or double quoted values. In this article, we will see Apache Hive load quoted values CSV files and see some examples for the same. Apache Hive Load Quoted Values CSV File Let us…

Continue ReadingApache Hive Load Quoted Values CSV File and Examples
2 Comments
October 8, 2017
General

Netezza Select Random Rows and Example

If you are working on data warehouse or any database query then you might have received the request to get random numbers based on on some key columns. In this article, we will check Netezza select random rows in nzsql and explanation with an examples. This article also explains you on Netezza select random samples that you may use in other client related applications. Netezza Select Random Rows To demonstrate the Netezza select random, we will use the Netezza random() built in function. Netezza Select Random Rows Example  Suppose you…

Continue ReadingNetezza Select Random Rows and Example
2 Comments
October 6, 2017