User Tools

Site Tools


Sidebar

**HPL/SQL is included to Apache Hive since version 2.0** * [[home|Home]]\\ * [[why|Why HPL/SQL]]\\ * [[features|Key Features]]\\ * [[start|Get Started]]\\ * [[doc|HPL/SQL Reference]]\\ * [[download|Download]]\\ * [[new|What's New]]\\ * [[about|About]]

use

This is an old revision of the document!


A PCRE internal error occured. This might be caused by a faulty plugin

====== USE Statement ====== USE statement allows you to change the default database used in SQL statements for the current connection. **Syntax:** <code language="sql"> USE database_expr; </code> Note: HPL/SQL allows you to use an expression to specify the database name **Example**: <code language="sql"> USE sales; USE SUBSTR(var, 1, 3); </code> **Compatibility**: Hive, MySQL **Version**: HPL/SQL 0.1 See also: * [[create-database|CREATE DATABASE]] * [[drop-database|DROP DATABASE]]