User Tools

Site Tools


**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]]


====== SET Session Option ====== SET statement allows you to set various session-level options. ===== CURRENT SCHEMA ===== Changing the current schema (database): **Syntax**: <code language=sql> SET [CURRENT] SCHEMA [=] schema_name; | SET CURRENT_SCHEMA [=] schema_name; </code> Note: * //schema_name// is an identifier, string literal or expression. * HPL/SQL converts this statement to USE //schema_name// statement in Hive. **Example:** <code language=sql> SET CURRENT SCHEMA = default; SET SCHEMA = 'default'; SET SCHEMA 'def' || 'ault'; </code> **Compatibility:** IBM DB2 **Version:** HPL/SQL 0.3.11 **See also:** * [[use|USE]]