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

Latest

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 predicates like 'WHERE tab1.col1 = 10' load the entire table or partition and process all the rows. But if an index exists for col1, then only a portion ...

Hive : Windowing and Analytics Functions

Windowing functions LEAD The number of rows to lead can optionally be specified. If the number of rows to lead is not specified, the lead is one row. Returns null when the lead for the current row extends beyond the end of the window. LAG The number of rows to lag can optionally be ...

HiveServer2 Clients

Beeline – Command Line Shell Example % bin/beeline Hive version 0.11.0-SNAPSHOT by Apache beeline> !connect jdbc:hive2://localhost:10000 scott tiger !connect jdbc:hive2://localhost:10000 scott tiger Connecting to jdbc:hive2://localhost:10000 Connected to: Hive (version 0.10.0) Driver: Hive (version 0.10.0-SNAPSHOT) Transaction isolation: TRANSACTION_REPEATABLE_READ 0: jdbc:hive2://localhost:10000> show tables; show tables; +-------------------+ | tablename | +-------------------+ | Alien ...

Hive Performance Tips

The biggest gift for working with Hadoop system in the recent times which can make every RDBMS user smile is HIVE. Although working with Hive can be a frustrating experience if your used to traditional RDBM systems since the traditional statistics required for query optimization are not available . The most important thing before you work with ...

Beeline – Command Line Shell

The Beeline shell works in both embedded mode as well as remote mode. In the embedded mode, it runs an embedded Hive (similar to Hive CLI) whereas remote mode is for connecting to a separate HiveServer2 process over Thrift. Starting in Hive 0.14, when Beeline is used with HiveServer2, it also prints the log messages ...

An Overview of the new Viewpoint 15.11 Dashboard

Viewpoint

Article by Mitchell Craig, William Darling The Viewpoint Dashboard (released with Viewpoint 15.11) is designed to give you an at-a-glance overview of monitored systems while you perform your everyday tasks. If something catches your eye you can quickly switch to the Dashboard for a system and begin a more in-depth investigation. The Viewpoint Dashboard pulls together data from ...

Teradata XML Data Type

Teradata XML

Teradata XML The XML Data type, introduced in Teradata 14.10, provides the following new capabilities: •A new XML data type that allows you to store XML content in a compact binary form that preserves the information set of the XML document, including the hierarchy information and type information derived from XML validation •Functions and methods on the XML type that ...