org.apache.hive.hplsql

Class Stmt

java.lang.Object

org.apache.hive.hplsql.Stmt

public class Stmt
extends Object

HPL/SQL statements execution

Method Summary

Modifier and Type	Method and Description
Integer	allocateCursor(HplsqlParser.Allocate_cursor_stmtContext ctx) ALLOCATE CURSOR statement
Integer	assignFromSelect(HplsqlParser.Assignment_stmt_select_itemContext ctx) Assignment from SELECT statement
Integer	associateLocator(HplsqlParser.Associate_locator_stmtContext ctx) ASSOCIATE LOCATOR statement
Integer	break_(HplsqlParser.Break_stmtContext ctx) BREAK statement (leave the innermost loop unconditionally)
Integer	close(HplsqlParser.Close_stmtContext ctx) CLOSE cursor statement
Integer	createDatabase(HplsqlParser.Create_database_stmtContext ctx) CREATE DATABASE | SCHEMA statement
Integer	createLocalTemporaryTable(HplsqlParser.Create_local_temp_table_stmtContext ctx) CREATE LOCAL TEMPORARY | VOLATILE TABLE statement
Integer	createTable(HplsqlParser.Create_table_stmtContext ctx) CREATE TABLE statement
Integer	createTableHiveOptions(HplsqlParser.Create_table_options_hive_itemContext ctx) CREATE TABLE options for Hive
Integer	createTableHiveRowFormat(HplsqlParser.Create_table_hive_row_formatContext ctx)
Integer	createTableMysqlOptions(HplsqlParser.Create_table_options_mysql_itemContext ctx) CREATE TABLE options for MySQL
Integer	createTemporaryTable(HplsqlParser.IdentContext identCtx, HplsqlParser.Create_table_definitionContext defCtx, HplsqlParser.Create_table_preoptionsContext optCtx) Create a temporary table statement
Integer	declareCursor(HplsqlParser.Declare_cursor_itemContext ctx) DECLARE cursor statement
Integer	declareTemporaryTable(HplsqlParser.Declare_temporary_table_itemContext ctx) DECLARE TEMPORARY TABLE statement
Integer	delete(HplsqlParser.Delete_stmtContext ctx) DELETE statement
Integer	describe(HplsqlParser.Describe_stmtContext ctx) DESCRIBE statement
Integer	drop(HplsqlParser.Drop_stmtContext ctx) DROP statement
Integer	exec(HplsqlParser.Exec_stmtContext ctx) EXEC, EXECUTE and EXECUTE IMMEDIATE statement to execute dynamic SQL or stored procedure
Boolean	execProc(HplsqlParser.Exec_stmtContext ctx) EXEC to execute a stored procedure
Integer	exit(HplsqlParser.Exit_stmtContext ctx) EXIT statement (leave the specified loop with a condition)
Integer	fetch(HplsqlParser.Fetch_stmtContext ctx) FETCH cursor statement
Integer	forCursor(HplsqlParser.For_cursor_stmtContext ctx) FOR cursor statement
Integer	forRange(HplsqlParser.For_range_stmtContext ctx) FOR (integer range) statement
Integer	getDiagnosticsException(HplsqlParser.Get_diag_stmt_exception_itemContext ctx) GET DIAGNOSTICS EXCEPTION statement
Integer	getDiagnosticsRowCount(HplsqlParser.Get_diag_stmt_rowcount_itemContext ctx) GET DIAGNOSTICS ROW_COUNT statement
Integer	ifBteq(HplsqlParser.If_bteq_stmtContext ctx) IF statement (BTEQ syntax)
Integer	ifPlsql(HplsqlParser.If_plsql_stmtContext ctx) IF statement (PL/SQL syntax)
Integer	ifTsql(HplsqlParser.If_tsql_stmtContext ctx) IF statement (Transact-SQL syntax)
Integer	include(HplsqlParser.Include_stmtContext ctx) INCLUDE statement
Integer	insert(HplsqlParser.Insert_stmtContext ctx) SQL INSERT statement
Integer	insertDirectory(HplsqlParser.Insert_directory_stmtContext ctx) INSERT DIRECTORY statement
Integer	insertSelect(HplsqlParser.Insert_stmtContext ctx) SQL INSERT SELECT statement
Integer	insertValues(HplsqlParser.Insert_stmtContext ctx) SQL INSERT VALUES statement
Integer	leave(HplsqlParser.Leave_stmtContext ctx) LEAVE statement (leave the specified loop unconditionally)
void	leaveLoop(String value) Leave the specified or innermost loop unconditionally
Integer	merge(HplsqlParser.Merge_stmtContext ctx) MERGE statement
Integer	open(HplsqlParser.Open_stmtContext ctx) OPEN cursor statement
Integer	print(HplsqlParser.Print_stmtContext ctx) PRINT Statement
Integer	quit(HplsqlParser.Quit_stmtContext ctx) QUIT Statement
Integer	resignal(HplsqlParser.Resignal_stmtContext ctx) RESIGNAL statement
Integer	return_(HplsqlParser.Return_stmtContext ctx) RETURN statement
Integer	setCurrentSchema(HplsqlParser.Set_current_schema_optionContext ctx) SET current schema
Integer	signal(HplsqlParser.Signal_stmtContext ctx) SIGNAL statement
Integer	truncate(HplsqlParser.Truncate_stmtContext ctx) TRUNCATE statement
Integer	update(HplsqlParser.Update_stmtContext ctx) UPDATE statement
Integer	use(HplsqlParser.Use_stmtContext ctx) USE statement
Integer	use(org.antlr.v4.runtime.ParserRuleContext ctx, String sql)
Integer	values(HplsqlParser.Values_into_stmtContext ctx) VALUES statement
Integer	while_(HplsqlParser.While_stmtContext ctx) WHILE statement

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

allocateCursor

public Integer allocateCursor(HplsqlParser.Allocate_cursor_stmtContext ctx)

ALLOCATE CURSOR statement

associateLocator

public Integer associateLocator(HplsqlParser.Associate_locator_stmtContext ctx)

ASSOCIATE LOCATOR statement

declareCursor

public Integer declareCursor(HplsqlParser.Declare_cursor_itemContext ctx)

DECLARE cursor statement

createTable

public Integer createTable(HplsqlParser.Create_table_stmtContext ctx)

CREATE TABLE statement

createTableHiveOptions

public Integer createTableHiveOptions(HplsqlParser.Create_table_options_hive_itemContext ctx)

CREATE TABLE options for Hive

createTableHiveRowFormat

public Integer createTableHiveRowFormat(HplsqlParser.Create_table_hive_row_formatContext ctx)

createTableMysqlOptions

public Integer createTableMysqlOptions(HplsqlParser.Create_table_options_mysql_itemContext ctx)

CREATE TABLE options for MySQL

declareTemporaryTable

public Integer declareTemporaryTable(HplsqlParser.Declare_temporary_table_itemContext ctx)

DECLARE TEMPORARY TABLE statement

createDatabase

public Integer createDatabase(HplsqlParser.Create_database_stmtContext ctx)

CREATE DATABASE | SCHEMA statement

createLocalTemporaryTable

public Integer createLocalTemporaryTable(HplsqlParser.Create_local_temp_table_stmtContext ctx)

CREATE LOCAL TEMPORARY | VOLATILE TABLE statement

createTemporaryTable

public Integer createTemporaryTable(HplsqlParser.IdentContext identCtx,
                                    HplsqlParser.Create_table_definitionContext defCtx,
                                    HplsqlParser.Create_table_preoptionsContext optCtx)

Create a temporary table statement

describe

public Integer describe(HplsqlParser.Describe_stmtContext ctx)

DESCRIBE statement

drop

public Integer drop(HplsqlParser.Drop_stmtContext ctx)

DROP statement

truncate

public Integer truncate(HplsqlParser.Truncate_stmtContext ctx)

TRUNCATE statement

open

public Integer open(HplsqlParser.Open_stmtContext ctx)

OPEN cursor statement

fetch

public Integer fetch(HplsqlParser.Fetch_stmtContext ctx)

FETCH cursor statement

close

public Integer close(HplsqlParser.Close_stmtContext ctx)

CLOSE cursor statement

include

public Integer include(HplsqlParser.Include_stmtContext ctx)

INCLUDE statement

ifPlsql

public Integer ifPlsql(HplsqlParser.If_plsql_stmtContext ctx)

IF statement (PL/SQL syntax)

ifTsql

public Integer ifTsql(HplsqlParser.If_tsql_stmtContext ctx)

IF statement (Transact-SQL syntax)

ifBteq

public Integer ifBteq(HplsqlParser.If_bteq_stmtContext ctx)

IF statement (BTEQ syntax)

assignFromSelect

public Integer assignFromSelect(HplsqlParser.Assignment_stmt_select_itemContext ctx)

Assignment from SELECT statement

insert

public Integer insert(HplsqlParser.Insert_stmtContext ctx)

SQL INSERT statement

insertSelect

public Integer insertSelect(HplsqlParser.Insert_stmtContext ctx)

SQL INSERT SELECT statement

insertValues

public Integer insertValues(HplsqlParser.Insert_stmtContext ctx)

SQL INSERT VALUES statement

insertDirectory

public Integer insertDirectory(HplsqlParser.Insert_directory_stmtContext ctx)

INSERT DIRECTORY statement

getDiagnosticsException

public Integer getDiagnosticsException(HplsqlParser.Get_diag_stmt_exception_itemContext ctx)

GET DIAGNOSTICS EXCEPTION statement

getDiagnosticsRowCount

public Integer getDiagnosticsRowCount(HplsqlParser.Get_diag_stmt_rowcount_itemContext ctx)

GET DIAGNOSTICS ROW_COUNT statement

use

public Integer use(HplsqlParser.Use_stmtContext ctx)

USE statement

use

public Integer use(org.antlr.v4.runtime.ParserRuleContext ctx,
                   String sql)

values

public Integer values(HplsqlParser.Values_into_stmtContext ctx)

VALUES statement

while_

public Integer while_(HplsqlParser.While_stmtContext ctx)

WHILE statement

forCursor

public Integer forCursor(HplsqlParser.For_cursor_stmtContext ctx)

FOR cursor statement

forRange

public Integer forRange(HplsqlParser.For_range_stmtContext ctx)

FOR (integer range) statement

exec

public Integer exec(HplsqlParser.Exec_stmtContext ctx)

EXEC, EXECUTE and EXECUTE IMMEDIATE statement to execute dynamic SQL or stored procedure

execProc

public Boolean execProc(HplsqlParser.Exec_stmtContext ctx)

EXEC to execute a stored procedure

exit

public Integer exit(HplsqlParser.Exit_stmtContext ctx)

EXIT statement (leave the specified loop with a condition)

break_

public Integer break_(HplsqlParser.Break_stmtContext ctx)

BREAK statement (leave the innermost loop unconditionally)

leave

public Integer leave(HplsqlParser.Leave_stmtContext ctx)

LEAVE statement (leave the specified loop unconditionally)

leaveLoop

public void leaveLoop(String value)

Leave the specified or innermost loop unconditionally

update

public Integer update(HplsqlParser.Update_stmtContext ctx)

UPDATE statement

delete

public Integer delete(HplsqlParser.Delete_stmtContext ctx)

DELETE statement

merge

public Integer merge(HplsqlParser.Merge_stmtContext ctx)

MERGE statement

print

public Integer print(HplsqlParser.Print_stmtContext ctx)

PRINT Statement

quit

public Integer quit(HplsqlParser.Quit_stmtContext ctx)

QUIT Statement

setCurrentSchema

public Integer setCurrentSchema(HplsqlParser.Set_current_schema_optionContext ctx)

SET current schema

signal

public Integer signal(HplsqlParser.Signal_stmtContext ctx)

SIGNAL statement

resignal

public Integer resignal(HplsqlParser.Resignal_stmtContext ctx)

RESIGNAL statement

return_

public Integer return_(HplsqlParser.Return_stmtContext ctx)

RETURN statement