Java SDK Documentation
24.2.0
|
Classes | |
class | PartitionOrderColumnInfo |
Represents the partition by and order by column information for each phase in a multi-phase transform function. | |
Public Member Functions | |
void | addBinary (int len, String fieldName) |
Adds a column of type BINARY. More... | |
void | addBinary (int len) |
void | addBinaryOrderColumn (int len, String fieldName) |
Adds an order column of type BINARY. More... | |
void | addBinaryPartitionColumn (int len, String fieldName) |
Adds a partition column of type BINARY. More... | |
void | addBool (String fieldName) |
Adds a column of type BOOLEAN. More... | |
void | addBool () |
void | addBoolOrderColumn (String fieldName) |
Adds an order column of type BOOLEAN. More... | |
void | addBoolPartitionColumn (String fieldName) |
Adds a partition column of type BOOLEAN. More... | |
void | addChar (int len, String fieldName) |
Adds a column of type CHAR. More... | |
void | addChar (int len) |
void | addCharOrderColumn (int len, String fieldName) |
Adds an order column of type CHAR. More... | |
void | addCharPartitionColumn (int len, String fieldName) |
Adds a partition column of type CHAR. More... | |
void | addDate (String fieldName) |
Adds a column of type DATE. More... | |
void | addDate () |
void | addDateOrderColumn (String fieldName) |
Adds an order column of type DATE. More... | |
void | addDatePartitionColumn (String fieldName) |
Adds a partition column of type DATE. More... | |
void | addFloat (String fieldName) |
Adds a column of type FLOAT. More... | |
void | addFloat () |
void | addFloatOrderColumn (String fieldName) |
Adds an order column of type FLOAT. More... | |
void | addFloatPartitionColumn (String fieldName) |
Adds a partition column of type FLOAT. More... | |
void | addInt (String fieldName) |
Adds a column of type INTEGER. More... | |
void | addInt () |
void | addIntervalOrderColumn (int precision, int range, String fieldName) |
Adds an order column of type INTERVAL/INTERVAL DAY TO SECOND. More... | |
void | addIntervalPartitionColumn (int precision, int range, String fieldName) |
Adds a partition column of type INTERVAL/INTERVAL DAY TO SECOND. More... | |
void | addIntervalYMOrderColumn (int range, String fieldName) |
Adds an order column of type INTERVAL YEAR TO MONTH. More... | |
void | addIntervalYMPartitionColumn (int range, String fieldName) |
Adds a partition column of type INTERVAL YEAR TO MONTH. More... | |
void | addIntOrderColumn (String fieldName) |
Adds an order column of type INTEGER. More... | |
void | addIntPartitionColumn (String fieldName) |
Adds a partition column of type INTEGER. More... | |
void | addLongVarbinary (int len, String fieldName) |
Adds a column of type LONGVARBINARY. More... | |
void | addLongVarbinary (int len) |
void | addLongVarbinaryOrderColumn (int len, String fieldName) |
Adds an order column of type VARBINARY. More... | |
void | addLongVarbinaryPartitionColumn (int len, String fieldName) |
Adds a partition column of type VARBINARY. More... | |
void | addLongVarchar (int len, String fieldName) |
Adds a column of type LONGVARCHAR. More... | |
void | addLongVarchar (int len) |
void | addLongVarcharOrderColumn (int len, String fieldName) |
Adds an order column of type VARCHAR. More... | |
void | addLongVarcharPartitionColumn (int len, String fieldName) |
Adds a partition column of type VARCHAR. More... | |
void | addNumeric (int precision, int scale, String fieldName) |
Adds a column of type NUMERIC. More... | |
void | addNumeric (int precision, int scale) |
void | addNumericOrderColumn (int precision, int scale, String fieldName) |
Adds an order column of type NUMERIC. More... | |
void | addNumericPartitionColumn (int precision, int scale, String fieldName) |
Adds a partition column of type NUMERIC. More... | |
void | addOrderColumn (BaseDataOID typeOid, int typeMod, String fieldName) |
void | addOrderColumn (VerticaType dt, String fieldName) |
Adds an order column of the specified type. (only relevant to multiphase UDTs.) | |
void | addPartitionColumn (BaseDataOID typeOid, int typeMod, String fieldName) |
void | addPartitionColumn (VerticaType dt, String fieldName) |
Adds a partition column of the specified type (only relevant to multiphase UDTs.) | |
void | addTime (int precision, String fieldName) |
Adds a column of type TIME. More... | |
void | addTime (int precision) |
void | addTimeOrderColumn (int precision, String fieldName) |
Adds an order column of type TIME. More... | |
void | addTimePartitionColumn (int precision, String fieldName) |
Adds a partition column of type TIME. More... | |
void | addTimestamp (String fieldName) |
Adds a column of type TIMESTAMP. More... | |
void | addTimestamp () |
void | addTimestampOrderColumn (int precision, String fieldName) |
Adds an order column of type TIMESTAMP. More... | |
void | addTimestampPartitionColumn (int precision, String fieldName) |
Adds a partition column of type TIMESTAMP. More... | |
void | addTimestampTzOrderColumn (int precision, String fieldName) |
Adds an order column of type TIMESTAMP WITH TIMEZONE. More... | |
void | addTimestampTzPartitionColumn (int precision, String fieldName) |
Adds a partition column of type TIMESTAMP WITH TIMEZONE. More... | |
void | addTimeTz (int precision, String fieldName) |
Adds a column of type TIME WITH TIMEZONE. More... | |
void | addTimeTz (int precision) |
void | addTimeTzOrderColumn (int precision, String fieldName) |
Adds an order column of type TIME WITH TIMEZONE. More... | |
void | addVarbinary (int len, String fieldName) |
Adds a column of type VARBINARY. More... | |
void | addVarbinary (int len) |
void | addVarbinaryOrderColumn (int len, String fieldName) |
Adds an order column of type VARBINARY. More... | |
void | addVarbinaryPartitionColumn (int len, String fieldName) |
Adds a partition column of type VARBINARY. More... | |
void | addVarchar (int len, String fieldName) |
Adds a column of type VARCHAR. More... | |
void | addVarchar (int len) |
void | addVarcharOrderColumn (int len, String fieldName) |
Adds an order column of type VARCHAR. More... | |
void | addVarcharPartitionColumn (int len, String fieldName) |
Adds a partition column of type VARCHAR. More... | |
void | copyValues (SizedColumnTypes sizedColumnTypes) |
void | getArgumentColumns (ArrayList< Integer > cols) |
Retrieves indexes of argument columns. Indexes in cols can be used in conjunction with other functions, e.g. getColumnType(size_t) and getColumnName(size_t). More... | |
int | getColumnCount () |
Returns the number of columns. | |
String | getColumnName (int idx) |
Returns the name of the column at the specified index. More... | |
VerticaType | getColumnType (int idx) |
Returns the type of the column at the specified index. More... | |
int | getLastOrderColumnIdx () |
Gets the last ORDER BY column index. | |
int | getLastPartitionColumnIdx () |
Gets the last PARTITION BY column index. | |
void | getOrderByColumns (ArrayList< Integer > cols) |
Retrieves indexes of ORDER BY columns in the OVER() clause. Indexes in cols can be used in conjunction with other functions, e.g. getColumnType(size_t) and getColumnName(size_t). More... | |
void | getPartitionByColumns (ArrayList< Integer > cols) |
Retrieves indexes of PARTITION BY columns in the OVER() clause. Indexes in cols can be used in conjunction with other functions, e.g. getColumnType(size_t) and getColumnName(size_t). More... | |
boolean | isOrderByColumn (int idx) |
Indicates whether the column at the specified index is an ORDER BY column. More... | |
boolean | isPartitionByColumn (int idx) |
Indicates whether the column at the specified index is a PARTITION BY column. More... | |
void | setPartitionOrderColumnIdx (int partition_idx, int order_idx) |
Sets the PARTITION BY and ORDER BY column indexes. More... | |
void | setPartitionOrderColumnIdx (SizedColumnTypes other) |
Sets the PARTITION BY and ORDER BY column indexes from another SizedColumnTypes object. More... | |
Represents types and information to determine the size of the columns as input/output of a User Defined Function/Transform
This class is used to exchange size and precision information between Vertica and the user defined function/transform function. Vertica provides the user code with size/precision information about the particular data types that it has been called with, and expects the user code to provide size/precision information about what it will return.
void com.vertica.sdk.SizedColumnTypes.addBinary | ( | int | len, |
String | fieldName | ||
) |
Adds a column of type BINARY.
len | The length of the binary string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addBinaryOrderColumn | ( | int | len, |
String | fieldName | ||
) |
Adds an order column of type BINARY.
len | The length of the binary string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addBinaryPartitionColumn | ( | int | len, |
String | fieldName | ||
) |
Adds a partition column of type BINARY.
len | The length of the binary string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addBool | ( | String | fieldName | ) |
Adds a column of type BOOLEAN.
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addBoolOrderColumn | ( | String | fieldName | ) |
Adds an order column of type BOOLEAN.
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addBoolPartitionColumn | ( | String | fieldName | ) |
Adds a partition column of type BOOLEAN.
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addChar | ( | int | len, |
String | fieldName | ||
) |
Adds a column of type CHAR.
len | The length of the string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addCharOrderColumn | ( | int | len, |
String | fieldName | ||
) |
Adds an order column of type CHAR.
len | The length of the string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addCharPartitionColumn | ( | int | len, |
String | fieldName | ||
) |
Adds a partition column of type CHAR.
len | The length of the string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addDate | ( | String | fieldName | ) |
Adds a column of type DATE.
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addDateOrderColumn | ( | String | fieldName | ) |
Adds an order column of type DATE.
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addDatePartitionColumn | ( | String | fieldName | ) |
Adds a partition column of type DATE.
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addFloat | ( | String | fieldName | ) |
Adds a column of type FLOAT.
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addFloatOrderColumn | ( | String | fieldName | ) |
Adds an order column of type FLOAT.
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addFloatPartitionColumn | ( | String | fieldName | ) |
Adds a partition column of type FLOAT.
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addInt | ( | String | fieldName | ) |
Adds a column of type INTEGER.
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addIntervalOrderColumn | ( | int | precision, |
int | range, | ||
String | fieldName | ||
) |
Adds an order column of type INTERVAL/INTERVAL DAY TO SECOND.
precision | The precision for the interval. |
range | The range for the interval. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addIntervalPartitionColumn | ( | int | precision, |
int | range, | ||
String | fieldName | ||
) |
Adds a partition column of type INTERVAL/INTERVAL DAY TO SECOND.
precision | The precision for the interval. |
range | The range for the interval. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addIntervalYMOrderColumn | ( | int | range, |
String | fieldName | ||
) |
Adds an order column of type INTERVAL YEAR TO MONTH.
range | The range for the interval. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addIntervalYMPartitionColumn | ( | int | range, |
String | fieldName | ||
) |
Adds a partition column of type INTERVAL YEAR TO MONTH.
range | The range for the interval. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addIntOrderColumn | ( | String | fieldName | ) |
Adds an order column of type INTEGER.
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addIntPartitionColumn | ( | String | fieldName | ) |
Adds a partition column of type INTEGER.
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addLongVarbinary | ( | int | len, |
String | fieldName | ||
) |
Adds a column of type LONGVARBINARY.
len | The length of the binary string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addLongVarbinaryOrderColumn | ( | int | len, |
String | fieldName | ||
) |
Adds an order column of type VARBINARY.
len | The length of the binary string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addLongVarbinaryPartitionColumn | ( | int | len, |
String | fieldName | ||
) |
Adds a partition column of type VARBINARY.
len | The length of the binary string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addLongVarchar | ( | int | len, |
String | fieldName | ||
) |
Adds a column of type LONGVARCHAR.
len | The length of the string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addLongVarcharOrderColumn | ( | int | len, |
String | fieldName | ||
) |
Adds an order column of type VARCHAR.
len | The length of the string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addLongVarcharPartitionColumn | ( | int | len, |
String | fieldName | ||
) |
Adds a partition column of type VARCHAR.
len | The length of the string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addNumeric | ( | int | precision, |
int | scale, | ||
String | fieldName | ||
) |
Adds a column of type NUMERIC.
precision | The precision for the numeric value. |
scale | The scale for the numeric value. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addNumericOrderColumn | ( | int | precision, |
int | scale, | ||
String | fieldName | ||
) |
Adds an order column of type NUMERIC.
precision | The precision for the numeric value. |
scale | The scale for the numeric value. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addNumericPartitionColumn | ( | int | precision, |
int | scale, | ||
String | fieldName | ||
) |
Adds a partition column of type NUMERIC.
precision | The precision for the numeric value. |
scale | The scale for the numeric value. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addTime | ( | int | precision, |
String | fieldName | ||
) |
Adds a column of type TIME.
precision | The precision for the time. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addTimeOrderColumn | ( | int | precision, |
String | fieldName | ||
) |
Adds an order column of type TIME.
precision | The precision for the time. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addTimePartitionColumn | ( | int | precision, |
String | fieldName | ||
) |
Adds a partition column of type TIME.
precision | The precision for the time. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addTimestamp | ( | String | fieldName | ) |
Adds a column of type TIMESTAMP.
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addTimestampOrderColumn | ( | int | precision, |
String | fieldName | ||
) |
Adds an order column of type TIMESTAMP.
precision | The precision for the timestamp. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addTimestampPartitionColumn | ( | int | precision, |
String | fieldName | ||
) |
Adds a partition column of type TIMESTAMP.
precision | The precision for the timestamp. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addTimestampTzOrderColumn | ( | int | precision, |
String | fieldName | ||
) |
Adds an order column of type TIMESTAMP WITH TIMEZONE.
precision | The precision for the timestamp. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addTimestampTzPartitionColumn | ( | int | precision, |
String | fieldName | ||
) |
Adds a partition column of type TIMESTAMP WITH TIMEZONE.
precision | The precision for the timestamp. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addTimeTz | ( | int | precision, |
String | fieldName | ||
) |
Adds a column of type TIME WITH TIMEZONE.
precision | The precision for the time. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addTimeTzOrderColumn | ( | int | precision, |
String | fieldName | ||
) |
Adds an order column of type TIME WITH TIMEZONE.
precision | The precision for the time. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addVarbinary | ( | int | len, |
String | fieldName | ||
) |
Adds a column of type VARBINARY.
len | The length of the binary string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addVarbinaryOrderColumn | ( | int | len, |
String | fieldName | ||
) |
Adds an order column of type VARBINARY.
len | The length of the binary string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addVarbinaryPartitionColumn | ( | int | len, |
String | fieldName | ||
) |
Adds a partition column of type VARBINARY.
len | The length of the binary string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addVarchar | ( | int | len, |
String | fieldName | ||
) |
Adds a column of type VARCHAR.
len | The length of the string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addVarcharOrderColumn | ( | int | len, |
String | fieldName | ||
) |
Adds an order column of type VARCHAR.
len | The length of the string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.addVarcharPartitionColumn | ( | int | len, |
String | fieldName | ||
) |
Adds a partition column of type VARCHAR.
len | The length of the string. |
fieldName | The name for the output column. |
void com.vertica.sdk.SizedColumnTypes.getArgumentColumns | ( | ArrayList< Integer > | cols | ) |
Retrieves indexes of argument columns. Indexes in cols can be used in conjunction with other functions, e.g. getColumnType(size_t) and getColumnName(size_t).
cols | A vector to store the retrieved column indexes. |
String com.vertica.sdk.SizedColumnTypes.getColumnName | ( | int | idx | ) |
Returns the name of the column at the specified index.
idx | The index of the column |
Referenced by com.vertica.sdk.PartitionWriter.setRowFromMap().
VerticaType com.vertica.sdk.SizedColumnTypes.getColumnType | ( | int | idx | ) |
Returns the type of the column at the specified index.
idx | The index of the column |
Referenced by com.vertica.sdk.PartitionWriter.copyFromInput(), com.vertica.sdk.ParamReader.getType(), com.vertica.sdk.BlockReader.getVNumeric(), com.vertica.sdk.ParamWriter.setNumeric(), com.vertica.sdk.BlockWriter.setNumeric(), com.vertica.sdk.PartitionWriter.setRowFromMap(), and com.vertica.sdk.PartitionWriter.setValue().
void com.vertica.sdk.SizedColumnTypes.getOrderByColumns | ( | ArrayList< Integer > | cols | ) |
Retrieves indexes of ORDER BY columns in the OVER() clause. Indexes in cols can be used in conjunction with other functions, e.g. getColumnType(size_t) and getColumnName(size_t).
cols | A vector to store the retrieved column indexes. |
void com.vertica.sdk.SizedColumnTypes.getPartitionByColumns | ( | ArrayList< Integer > | cols | ) |
Retrieves indexes of PARTITION BY columns in the OVER() clause. Indexes in cols can be used in conjunction with other functions, e.g. getColumnType(size_t) and getColumnName(size_t).
cols | A vector to store the retrieved column indexes. |
boolean com.vertica.sdk.SizedColumnTypes.isOrderByColumn | ( | int | idx | ) |
Indicates whether the column at the specified index is an ORDER BY column.
idx | The index of the column |
boolean com.vertica.sdk.SizedColumnTypes.isPartitionByColumn | ( | int | idx | ) |
Indicates whether the column at the specified index is a PARTITION BY column.
idx | The index of the column |
void com.vertica.sdk.SizedColumnTypes.setPartitionOrderColumnIdx | ( | int | partition_idx, |
int | order_idx | ||
) |
Sets the PARTITION BY and ORDER BY column indexes.
partition_idx | Index of the last partition-by column |
order_idx | Index of the last order-by column |
void com.vertica.sdk.SizedColumnTypes.setPartitionOrderColumnIdx | ( | SizedColumnTypes | other | ) |
Sets the PARTITION BY and ORDER BY column indexes from another SizedColumnTypes object.
other | The SizedColumnTypes object to set the indexes from |