Hive Functions Examples 2


Hive Functions Examples

SET

SHOW

USE

CREATE DATABASE

CREATE MANAGED TABLE

CREATE EXTERNAL TABLE

CREATING TABLE FROM EXISTING TABLE

CREATING EXTERNAL TABLES FROM MANAGED TABLES

LOAD

COPY DATA FROM ONE TABLE TO ANOHTER

DROP

QUIT

SELECT

DESCRIBE

DESCRIBE SPECIFIC FIELD

DESCRIBE EXTENDED

ALTER

CLONE SCHEMA (DATA IS NOT COPIED)

CLONE SCHEMA TO ANOTHER DB

USING REGULAR EXPRESSIONS

MATHEMATICAL FUNCTIONS

AGGREGATE FUNCTIONS

LIMIT

NESTED SELECT STATEMENT

CASE..WHEN..THEN

LIKE & RLIKE

JOINS

ORDER BY, SORT BY, DISTRIBUTED BY WITH SORT BY, CLUSTER BY

SET

SHOW

USE

CREATE DATABASE

CREATE MANAGED TABLE

CREATE EXTERNAL TABLE:

CREATING TABLE FROM EXISTING TABLE

CREATING EXTERNAL TABLES FROM MANAGED TABLES:

LOAD