User Tools

Site Tools


Sidebar

HPL/SQL is included to Apache Hive since version 2.0

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.01