• interchangeable constructs
• hive is case sensitive
• secmicolon to terminate statements

• Distinct

SELECT DISTINCT 
    col1,
    col2,
    col3
FROM
    some_table;

• Aliasing

SELECT
    col1 + col2 AS col3
FROM
    some_table;

• REGEX Column Specification

SELECT 
    '(ID|Name)?+.+'
FROM
    some_table;

• INerchangeable constructs

SELECT 
    col1,
    col2,
    col3
FROM
    some_table
WHERE
    where_condition
LIMIT
    number_of_records;

above is same as below


FROM
    some_table
SELECT 
    col1,
    col2,
    col3
WHERE
    where_condition
LIMIT
    number_of_records;