Package | Description |
---|---|
org.apache.oozie.store | |
org.apache.oozie.util.db |
Modifier and Type | Class and Description |
---|---|
static class |
OozieSchema.OozieColumn |
Modifier and Type | Field and Description |
---|---|
static Map<Schema.Table,List<Schema.Column>> |
OozieSchema.TABLE_COLUMNS |
Modifier and Type | Method and Description |
---|---|
Schema.Column |
OozieSchema.OozieIndex.column() |
Modifier and Type | Method and Description |
---|---|
Schema.Column |
Schema.Index.column()
Column that is to be indexed
|
Modifier and Type | Method and Description |
---|---|
static SqlStatement.Condition |
SqlStatement.between(Schema.Column column,
Object lVal,
Object rVal)
BETWEEN range checking statement
|
<T> T |
SqlStatement.ResultSetReader.get(Class<T> clazz,
Schema.Column col)
Get the Column data given its type and name
|
Boolean |
SqlStatement.ResultSetReader.getBoolean(Schema.Column col)
Get the Boolean Column
|
byte[] |
SqlStatement.ResultSetReader.getByteArray(Schema.Column col)
Get the data for columns with blob type
|
static String |
Schema.getDbDataType(Schema.Column column,
Schema.DBType dbType)
Returns the appropriate DB type for given column according to the DB Type
|
Long |
SqlStatement.ResultSetReader.getLong(Schema.Column col)
Get the Numeric data
|
String |
SqlStatement.ResultSetReader.getString(Schema.Column col)
Get a String Column
|
Timestamp |
SqlStatement.ResultSetReader.getTimestamp(Schema.Column col)
Get the Timestamp Column
|
static SqlStatement.Condition |
SqlStatement.greaterThan(Schema.Column column,
Object value)
Generate Condition statement for GREATER THAN condition checking
|
static SqlStatement.Condition |
SqlStatement.greaterThanOrEqual(Schema.Column column,
Object value)
Generate Condition statement for GREATER THAN OR EQUAL condition checking
|
static SqlStatement.Condition |
SqlStatement.in(Schema.Column column,
Object... values)
IN Condition for checking multiple values
|
static SqlStatement.Condition |
SqlStatement.in(Schema.Column column,
SqlStatement.Select select)
Sub query with IN condition
|
static SqlStatement.Condition |
SqlStatement.isEqual(Schema.Column column,
Object value)
Generate Condition statement for equality check
|
static SqlStatement.Condition |
SqlStatement.isLike(Schema.Column column,
String value)
Generate condition statement for IS LIKE
|
static SqlStatement.Condition |
SqlStatement.isNotEqual(Schema.Column column,
Object value)
Generate InEquality Condition statement
|
static SqlStatement.Condition |
SqlStatement.isNotLike(Schema.Column column,
String value)
Generates condition statement for IS NOT LIKE
|
static SqlStatement.Condition |
SqlStatement.isNotNull(Schema.Column column)
Generate condition statement for IS NOT NULL
|
static SqlStatement.Condition |
SqlStatement.isNull(Schema.Column column)
Generate condition statement for IS NULL
|
static SqlStatement.Condition |
SqlStatement.lessThan(Schema.Column column,
Object value)
Generate Condition statement for LESS THAN condition checking
|
static SqlStatement.Condition |
SqlStatement.lessThanOrEqual(Schema.Column column,
Object value)
Generate Condition statement for LESS THAN OR EQUAL condition checking
|
static SqlStatement.Condition |
SqlStatement.notBetween(Schema.Column column,
Object lVal,
Object rVal)
NOT BETWEEN range checking statement
|
static SqlStatement.Condition |
SqlStatement.notIn(Schema.Column column,
Object... values)
NOT IN Condition for checking multiple values
|
static SqlStatement.Condition |
SqlStatement.notIn(Schema.Column column,
SqlStatement.Select select)
Sub query with NOT IN condition
|
SqlStatement.Select |
SqlStatement.Select.orderBy(Schema.Column column,
boolean order)
Sets the column to sort and the order of sort
|
SqlStatement.Select |
SqlStatement.Select.orderBy(Schema.Column column0,
boolean order0,
Schema.Column column1,
boolean order1)
To sort 2 columns
|
static SqlStatement.Select |
SqlStatement.selectColumns(Schema.Column... columns)
Return a Select Statement
|
SqlStatement.Update |
SqlStatement.Update.set(Schema.Column column,
Object value)
SET clause for update statement
|
SqlStatement.Insert |
SqlStatement.Insert.value(Schema.Column column,
Object value)
Set the VALUES that are to be inserted
|
Modifier and Type | Method and Description |
---|---|
static String |
Schema.generateCreateTableScript(Schema.Table table,
Schema.DBType dbType,
List<Schema.Column> tableColumns)
Generates the SQL Statement for creating the table
|
Copyright © 2018 Apache Software Foundation. All rights reserved.