Skip to content
  • Home
  • About
|       { One stop for all Spark Examples }
Spark by {Examples}
  • Spark
    • Spark RDD
    • Spark DataFrame
    • Spark SQL Functions
    • What’s New in Spark 3.0?
    • Spark Streaming
  • PySpark
  • Pandas
  • Hive
  • Kafka
  • H2O.ai
  • More
    • Apache Hadoop
    • Apache HBase
    • Apache Cassandra
    • Snowflake Database
    • H2O Sparkling Water
    • Scala Language
    • Python NumPy
    • FAQ’s
Menu Close
  • Spark
    • Spark RDD
    • Spark DataFrame
    • Spark SQL Functions
    • What’s New in Spark 3.0?
    • Spark Streaming
  • PySpark
  • Pandas
  • Hive
  • Kafka
  • H2O.ai
  • More
    • Apache Hadoop
    • Apache HBase
    • Apache Cassandra
    • Snowflake Database
    • H2O Sparkling Water
    • Scala Language
    • Python NumPy
    • FAQ’s
  • Home
  • About
Apache Hive

Hive Aggregate Functions (UDAF) with Examples

Hive Aggregate Functions are the most used built-in functions that take a set of values and return a single value, when used with a group, it aggregates all values in…

0 Comments
November 18, 2020
Apache Hive

Hive Relational | Arithmetic | Logical Operators

Like any other Database Hive also supports Relation, Arithmetic and Logical operators. Keeps an eye on return values as they changes if one of the operand is NULL. Hive Relational…

0 Comments
November 16, 2020
Apache Hive

Hive Data Types – Primitive | Complex

Hive supports several date types like Hive Numeric TypesHive Date & Time TypesHive String TypesHive Misc Types (Boolean & Binary)Hive Complex Types (Array, Map, Struct) Hive Numeric Types Below are…

0 Comments
November 16, 2020
Read more about the article Hive Collection Functions with Examples
Apache Hive

Hive Collection Functions with Examples

Hive comes with a set of collection functions to work with Map and Array data types. These functions are used to find the size of the array, map types, get…

0 Comments
November 15, 2020
Apache Hive

How to replace NULL values with Default in Hive

Use nvl() function in Hive to replace all NULL values of a column with a default value, In this article, I will explain with an example. You can use this…

0 Comments
November 15, 2020
Read more about the article Hive Conditional Functions with Examples
Apache Hive

Hive Conditional Functions with Examples

Hive conditional functions are used to apply conditions on one or more columns and the conditions are executed for every row on a table. In this article, you will learn…

0 Comments
November 15, 2020
Read more about the article Hive Date and Timestamp Functions | Examples
Apache Hive

Hive Date and Timestamp Functions | Examples

Hive Date and Timestamp functions are used to manipulate Date and Time on HiveQL queries over Hive CLI, Beeline, and many more applications Hive supports. The default date format of…

0 Comments
November 15, 2020
Read more about the article Hive Built-in String Functions with Examples
Apache Hive

Hive Built-in String Functions with Examples

Hive supports several built-in string functions similar to SQL functions to manipulate the strings. These Hive string functions come in handy when you are doing transformations without bringing data into…

0 Comments
November 10, 2020
Read more about the article Hive Cast Function to Convert Data Type
Apache Hive

Hive Cast Function to Convert Data Type

Hive CAST(from_datatype as to_datatype) function is used to convert from one data type to another for example to cast String to Integer(int), String to Bigint, String to Decimal, Decimal to…

0 Comments
November 8, 2020
Read more about the article Apache Hive Installation on Ubuntu
Apache Hive

Apache Hive Installation on Ubuntu

This section of the Apache Hive Tutorial explains step-by-step Apache Hive Installation and configuring on Ubuntu. Apache Hive needs Apache Hadoop Installation to be set up and running HDFS as…

1 Comment
November 7, 2020
  • 1
  • 2
  • 3
  • 4
  • Go to the next page

Apache Hive Tutorials

  • Hive – Introduction
  • Hive – Installation on Ubuntu
  • Hive – Start HiveServer2
  • Hive – Connect Using Beeline
  • Hive – What is Metastore and Data Warehouse Location?
  • Hive – Data Types
  • Hive – Relational | Arithmetic | Logical Operators
  • Hive – DDL Commands
  • Hive – Create Database
  • Hive – Create Managed & External Table
  • Hive – Create Temporary Table
  • Hive – Drop Database & Table
  • Hive – Insert into Table
  • Hive – Load CSV File into Table
  • Hive – Export Table into CSV File
  • Hive – Using ACID Transactions
  • Hive – Using Variables on Scripts
  • Hive – Connect using JDBC Connection

Hive Partitions & Bucketing

  • Hive – Partitions Examples
  • Hive – Bucketing with Examples
  • Hive – Partitioning vs Bucketing
  • Hive – Create Partitioned Table
  • Hive – Load into Partitioned Table
  • Hive – Show All Partitions
  • How – Update or Drop Partitions

Hive Functions

  • Hive – String Functions
  • Hive – Date and Timestamp Functions
  • Hive – Conditional Functions
  • Hive – Collection Functions
  • Hive – Aggregate Functions (UDAF)

Categories

  • Apache Hadoop
  • Apache Spark
  • Apache Spark Streaming
  • Apache Kafka
  • Apache HBase
  • Apache Cassandra
  • Snowflake Database
  • H2O Sparkling Water
  • PySpark

Recent Posts

  • Python Dictionary Methods
  • Python Dictionary setdefault() Method
  • Python Dictionary popitem() Method
  • Python Dictionary pop() Method
  • Python Dictionary update() Method
  • Python Dictionary fromkeys() Usage With Example
  • Python Dictionary copy()
  • Python Dictionary keys() Method Usage
  • Python Dictionary Values()
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

About SparkByExamples.com

SparkByExamples.com is a Big Data and Spark examples community page, all examples are simple and easy to understand, and well tested in our development environment Read more ..
Copyright sparkbyexamples.com