Apache HIVE tutorial

      What is Apache HIVE?

      Setting up Hive using Cloudera quickstart VM

      What is Hive metastore?

      How to clear the content in Hive interactive terminal?

      Execute hive command in non-interactive mode

      Hive: Execute sql statements from a file

      Get the Hive version from terminal

      Location of Hive data in HDFS

      Run hive in debug mode

      Hive: Create a database

      What is the default database in Hive?

      Hive: Drop a database

      Hive: print all the databases

      Hive: Print all the databases that match to given regular expression

      Hive: Get the database that user is in the Hive CLI

      HIVE: Create table

      HIVE: Data types

      Hive: rename a table

      Hive: Change the column name and type

      Hive: Add columns to existing table

      Hive: Replace columns of a table

      HIVE: Execute sql statements in a file

      Create, Insert and query data from hive table

      HIVE: SHOW TABLES: show all the available tables

      HIVE: describe table_name: Get all the columns and their datatypes

      HIVE: describe extended table_name: Get extended table information

      HIVE: describe formatted table_name: Get detailed information about the table

      Hive: Different ways to insert data into Hive table

            Hive: Insert data using insert query

            Hive: Insert multiple records using single insert query

            HIVE: load data from local file into hive table

            HIVE: LOAD DATA INPATH: Load data from hdfs file to hive table

            HIVE: Create table from other table

            Hive: Copy data from one table to other table

      Hive: What is the behaviour when I load the file multiple times

      Hive Complex Data Types with Examples

      Hive: Insert array elements using INSERT statement

      SemanticException [Error 10293]: Unable to create temp file for insert values Expression of type TOK_FUNCTION not supported in insert/values

      Hive: Insert map data using INSERT statement

      Hive: Insert struct data using INSERT statement

      HIVE: Exploring select statement

            HIVE: WHERE filter in SELECT query

            HIVE: Select specific columns

            Hive: Print columns names in SELECT statement output

            HIVE: limit number of results

      HIVE: Built in Functions

      Hive: List all the available functions

      Hive: get help about a function usage

      Hive: get extended help about a function usage

            Hive: Mathematical functions

                  Hive: abs: Return absolute value of a number

                  Hive: acos: Return arc cosin value of n

                  Hive: sign(n): Return the sign of a number

                  Hive: asin: Return arc sin value of n

                  Hive: atan(n): Return arc tangent of a number

                  Hive: bin: Return number in binary format

                  Hive: ceil, ceiling: Return ceiling value of n

                  Hive: conv: Convert number from one base to other base

                  Hive: cos: Return cosine of the value

                  Hive: degrees(n): Convert radians to degrees

                  Hive: exp: Return e to the power n

                  Hive: floor(n): Return floor value of this number

                  Hive: hex(n): Return hexa value of this number

                  Hive: hex(string): Convert each character into hexa format

                  Hive: ln(n): Return natural log of a number

                  Hive: log: return logarithm of a number

                  Hive: log2: base-2 logarithm of the number n

                  Hive: log10: Return base 10 logarithm of a number

                  Hive: negative: Negate the number

                  Hive: pi(): Return the value of pi

                  Hive: pmod: Return positive modulus of a number

                  Hive: positive: Return positive number

                  Hive: pow: Return the power of a number

                  Hive: radians(n): Convert degrees to radians

                  Hive: rand(): Return random number

                  Hive: round: round the double to n integer places

                  Hive: sin(n): Return sin of a number

                  Hive: sqrt(n): Return square root of a number

                  Hive: tan(n): Return tangent of a number in radians

                  Hive: unhex: Inverse of hex function

            Hive: Date functions

                  Hive: current_timestamp: Current timestamp of the system

                  Hive: day: Extract day information from date

                  Hive: dayofmonth: Extract day information from date

                  Hive: datediff: Difference between two dates

                  Hive: date_add: Add number of days to the given date

                  Hive: date_sub: subtract number of days from given date

                  Hive: from_unixtime: Convert the epoch time to a date

                  Hive: hour: Return hour part of the date

                  Hive: minute: Return minute part of the date

                  Hive: month: Extract month details from date

                  Hive: second: Return second part of the date

                  Hive: to_date: Extract date part of the timestamp

                  Hive: unix_timestamp: Get number of seconds from Unix Epoch

                  Hive: year: Extract year part of the date

                  Hive: weekofyear: Return week number of the date

            Hive: string functions

                  Hive: ascii: Get the ascii value of first character in a string

                  Hive: concat: Concatenate strings

                  Hive: concat_ds: Concatenate strings using given delimeter

                  Hive: find_in_set: Find the occurrence of a string in given list of strings

                  Hive: length: Return string length

                   Hive: lcase, lower: Return the string in lower case

                  Hive: lpad: Pad the characters to left side of string

                  Hive: ltrim: remove left side trailing spaces

                  Hive: repeat: Repeat the string n times

                  Hive: reverse: Reverse a string

                  Hive: rpad: Pad the character at right side of string

                  Hive: rtrim: Remove right side trailing spaces

                  Hive: space: return n number of spaces

                  Hive: split: Split the string by a separator

                   Hive: substr: return sub string

                  Hive: substring: return sub string

                  Hive: trim: trim all trailing and leading spaces

                  Hive: ucase: Return the string in upper case

                  Hive: upper: Return the string in upper case

             Hive: Conditional functions or statements

                  Hive: assert_true: throw exception when the condition evaluates to false

                  

                  Hive: case statement

                  Hive: coalesce: Return first non-null value

                  Hive: if conditional function

                  Hive: isnull: Return true when the value of column is null, else false

                  Hive: isnotnull: Return true when the value of column is not null, else false

                  Hive: nvl: return default value when the value is null

            Hive: collection functions

                  Hive: array_contains: Check for existence of an element in the array

                  Hive: map_keys: Get all the keys of a map

                  Hive: map_values: Get all the values of a map

                  Hive: size: Get number of elements in the array

                  Hive: size: Get number of key value pairs in a map

                  Hive: sort_array: Sort the array

      Hive: type conversion functions

      Hive: explode an array or map into multiple rows

       Hive: Working with lateral view

      Hive: select other columns with the exploded data

      Hive: subqueries

      Hive: Working with views

      HIVE: beeline: sql client to connect to HIVE

      hive: Beeline: Execute a query in non-interactive mode

      hive: How to exit from beeline terminal?

      hive: How to run the commands from a file in beeline?

      Connect to Hive using Hue

      Hive: How to create custom temporary function?

      Hive: How to create custom function?

      Quick guide to partitioning in Hive

      Hive: static partitioning

      Hive: Dynamic partitioning

      How to get all the partitions of a table IN HIVE?

      Hive: Perform partitioning on multiple columns

      Hive: quick guide to Bucketing

      Hive: How to use Bucketing, partitioning together

Previous                                                    Next                                                    Home