PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

Month: December 2016

WebHCat Reference

WebHCat Reference: DDL Resources This is an overview page for the WebHCat DDL resources. The full list of WebHCat resources . For information about HCatalog DDL commands, see
Read More

HIVE : Show Commands

These statements provide a way to query the Hive metastore for existing data and metadata accessible to this Hive system. Show Databases SHOW (DATABASES|SCHEMAS) [LIKE 'identifier_with_wildcards']; SHOW DATABASES
Read More

HIVE DDL Commands

Create/Drop/Alter/Use Database Create Database CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name   [COMMENT database_comment]   [LOCATION hdfs_path]   [WITH DBPROPERTIES (property_name=property_value, ...)]; The uses of SCHEMA and DATABASE are interchangeable – they
Read More

HIVE Reserved Keywords

Overview HiveQL DDL statements are documented here, including: CREATE DATABASE/SCHEMA, TABLE, VIEW, FUNCTION, INDEX DROP DATABASE/SCHEMA, TABLE, VIEW, INDEX TRUNCATE TABLE ALTER DATABASE/SCHEMA, TABLE, VIEW MSCK REPAIR TABLE
Read More

CheetSheet – Hive for SQL Users

SQL to HIVE Queries Function MySQL HiveQL Retrieving information SELECT from_columns FROM table WHERE conditions; SELECT from_columns FROM table WHERE conditions; All values SELECT * FROM table; SELECT
Read More

Hive Indexes

Overview of Hive Indexes The goal of Hive indexing is to improve the speed of query lookup on certain columns of a table. Without an index, queries with
Read More