SizedColumnTypes¶
-
class
vertica_sdk.
SizedColumnTypes
¶ Stores type metadata for a collection of columns.
Includes type mod information, such as string length and numeric percision information.
-
addArrayType
(self, element, maxElems, fieldName=u'')¶ Adds an ARRAY-typed column with its element typed according to the ‘element’ argument.
Returns
None
.
-
addBinary
(self, size, field_name=u'')¶ Adds a binary column to the list of columns.
Returns
None
.
-
addBinaryOrderColumn
(self, size, field_name=u'')¶ Adds an order column of type BINARY
Returns
None
.
-
addBinaryPartitionColumn
(self, size, field_name=u'')¶ Adds a partition column of type BINARY
Returns
None
.
-
addBool
(self, field_name=u'')¶ Adds a bool column to the list of columns.
Returns
None
.
-
addBoolOrderColumn
(self, field_name=u'')¶ Adds an order column of type BOOLEAN
Returns
None
.
-
addBoolPartitionColumn
(self, field_name=u'')¶ Adds a partition column of type BOOLEAN
Returns
None
.
-
addChar
(self, size, field_name=u'')¶ Adds a char column to the list of columns.
Returns
None
.
-
addCharOrderColumn
(self, size, field_name=u'')¶ Adds an order column of type CHAR
Returns
None
.
-
addCharPartitionColumn
(self, size, field_name=u'')¶ Adds a partition column of type CHAR
Returns
None
.
-
addColumn
(self, vertica_type, field_name=u'')¶ Adds a column with the given
vertica_sdk.VerticaType
and name to the list of columns.Returns
None
.
-
addDate
(self, field_name=u'')¶ Adds a date column to the list of columns.
Returns
None
.
-
addDateOrderColumn
(self, field_name=u'')¶ Adds an order column of type DATE
Returns
None
.
-
addDatePartitionColumn
(self, field_name=u'')¶ Adds a partition column of type DATE
Returns
None
.
-
addFloat
(self, field_name=u'')¶ Adds a float column to the list of columns.
Returns
None
.
-
addFloatOrderColumn
(self, field_name=u'')¶ Adds an order column of type FLOAT
Returns
None
.
-
addFloatPartitionColumn
(self, field_name=u'')¶ Adds a partition column of type FLOAT
Returns
None
.
-
addInt
(self, field_name=u'')¶ Adds an int column to the list of columns.
Returns
None
.
-
addIntOrderColumn
(self, field_name=u'')¶ Adds an order column of type INTEGER
Returns
None
.
-
addIntPartitionColumn
(self, field_name=u'')¶ Adds a partition column of type INTEGER
Returns
None
.
-
addInterval
(self, field_name=u'')¶ Adds a interval column to the list of columns.
Returns
None
.
-
addIntervalOrderColumn
(self, field_name=u'')¶ Adds an order column of type INTERVAL/INTERVAL DAY TO SECOND
Returns
None
.
-
addIntervalPartitionColumn
(self, field_name=u'')¶ Adds a partition column of type INTERVAL/INTERVAL DAY TO SECOND
Returns
None
.
-
addIntervalYM
(self, field_name=u'')¶ Adds a year-to-month interval column to the list of columns.
Returns
None
.
-
addIntervalYMOrderColumn
(self, field_name=u'')¶ Adds an order column of type INTERVAL YEAR TO MONTH
Returns
None
.
-
addIntervalYMPartitionColumn
(self, field_name=u'')¶ Adds a partition column of type INTERVAL YEAR TO MONTH
Returns
None
.
-
addLongVarbinary
(self, size, field_name=u'')¶ Adds a long varbinary column to the list of columns.
Returns
None
.
-
addLongVarbinaryOrderColumn
(self, size, field_name=u'')¶ Adds an order column of type LONG VARBINARY
Returns
None
.
-
addLongVarbinaryPartitionColumn
(self, size, field_name=u'')¶ Adds a partition column of type LONG VARBINARY
Returns
None
.
-
addLongVarchar
(self, size, field_name=u'')¶ Adds a long varchar column to the list of columns.
Returns
None
.
-
addLongVarcharOrderColumn
(self, size, field_name=u'')¶ Adds an order column of type LONG VARCHAR
Returns
None
.
-
addLongVarcharPartitionColumn
(self, size, field_name=u'')¶ Adds a partition column of type LONG VARCHAR
Returns
None
.
-
addNumeric
(self, precision, scale, field_name=u'')¶ Adds a numeric column to the list of columns.
Returns
None
.
-
addNumericOrderColumn
(self, precision, scale, field_name=u'')¶ Adds an order column of type NUMERIC
Returns
None
.
-
addNumericPartitionColumn
(self, precision, scale, field_name=u'')¶ Adds a partition column of type NUMERIC
Returns
None
.
-
addOrderColumn
(self, vertica_type, field_name=u'')¶ Adds an order column with the given
vertica_sdk.VerticaType
and name to the list of columns. (only relevant to multiphase UDTs.)Returns
None
.
-
addPartitionColumn
(self, vertica_type, field_name=u'')¶ Adds a partition column with the given
vertica_sdk.VerticaType
and name to the list of columns. (only relevant to multiphase UDTs.)Returns
None
.
-
addRowType
(self, fields, fieldName=u'')¶ Adds a ROW-typed column with its fields typed according to the ‘fields’ argument.
Returns
None
.
-
addTime
(self, field_name=u'')¶ Adds a time column to the list of columns.
Returns
None
.
-
addTimeOrderColumn
(self, field_name=u'')¶ Adds an order column of type TIME
Returns
None
.
-
addTimePartitionColumn
(self, field_name=u'')¶ Adds a partition column of type TIME
Returns
None
.
-
addTimeTz
(self, field_name=u'')¶ Adds a timetz column to the list of columns.
Returns
None
.
-
addTimeTzOrderColumn
(self, field_name=u'')¶ Adds an order column of type TIME WITH TIMEZONE
Returns
None
.
-
addTimeTzPartitionColumn
(self, field_name=u'')¶ Adds a partition column of type TIME WITH TIMEZONE
Returns
None
.
-
addTimestamp
(self, field_name=u'')¶ Adds a timestamp column to the list of columns.
Returns
None
.
-
addTimestampOrderColumn
(self, field_name=u'')¶ Adds an order column of type TIMESTAMP
Returns
None
.
-
addTimestampPartitionColumn
(self, field_name=u'')¶ Adds a partition column of type TIMESTAMP
Returns
None
.
-
addTimestampTz
(self, field_name=u'')¶ Adds a timestamptz column to the list of columns.
Returns
None
.
-
addTimestampTzOrderColumn
(self, field_name=u'')¶ Adds an order column of type TIMESTAMP WITH TIMEZONE
Returns
None
.
-
addTimestampTzPartitionColumn
(self, field_name=u'')¶ Adds a partition column of type TIMESTAMP WITH TIMEZONE
Returns
None
.
-
addUuid
(self, field_name=u'')¶ Adds a column of type UUID
Returns
None
.
-
addUuidOrderColumn
(self, field_name=u'')¶ Adds an order column of type UUID
Returns
None
.
-
addVarbinary
(self, size, field_name=u'')¶ Adds a varbinary column to the list of columns.
Returns
None
.
-
addVarbinaryOrderColumn
(self, size, field_name=u'')¶ Adds an order column of type VARBINARY
Returns
None
.
-
addVarbinaryPartitionColumn
(self, size, field_name=u'')¶ Adds a partition column of type VARBINARY
Returns
None
.
-
addVarchar
(self, size, field_name=u'')¶ Adds a varchar column to the list of columns.
Returns
None
.
-
addVarcharOrderColumn
(self, size, field_name=u'')¶ Adds an order column of type VARCHAR
Returns
None
.
-
addVarcharPartitionColumn
(self, size, field_name=u'')¶ Adds a partition column of type VARCHAR
Returns
None
.
-
copyTypesFrom
(self, other)¶ Appends the types from the provided
vertica_sdk.SizedColumnTypes
onto the current one.Returns
None
.
-
getArgumentColumns
(self)¶ Returns indexes of argument columns. Indexes in cols can be used in conjunction with other functions, e.g. getColumnType(idx) and getColumnName(idx).
-
getColumnCount
(self)¶ Returns the number of columns.
-
getColumnName
(self, idx)¶ Returns the name of the indicated column.
-
getColumnType
(self, idx)¶ Returns a
vertica_sdk.VerticaType
object describing the SQL type of the indicated column.
-
getLastOrderColumnIdx
(self)¶ Gets the last ORDER BY column index For example, it returns 5 in case of OVER(PARTITION BY a, b, c ORDER BY d, e, f).
-
getLastPartitionColumnIdx
(self)¶ Gets the last PARTITION BY column index For example, it returns 2 in case of OVER(PARTITION BY a, b, c ORDER BY d, e, f).
-
getOrderByColumns
(self)¶ Returns indexes of ORDER BY columns in the OVER() clause. Indexes in cols can be used in conjunction with other functions, e.g. getColumnType(idx) and getColumnName(idx).
-
getPartitionByColumns
(self)¶ Returns indexes of PARTITION BY columns in the OVER() clause. Indexes in cols can be used in conjunction with other functions, e.g. getColumnType(idx) and getColumnName(idx).
-
isOrderByColumn
(self, idx)¶ Returns a boolean indicating whether the column at the specified index is an ORDER BY column.
-
isPartitionByColumn
(self, idx)¶ Returns a boolean indicating whether the column at the specified index is a PARTITION BY column.
-
static
makeArrayType
(element, maxElems, fieldName=u'')¶
-
static
makeBinary
(size, field_name=u'')¶
-
static
makeBool
(field_name=u'')¶
-
static
makeChar
(size, field_name=u'')¶
-
static
makeDate
(field_name=u'')¶
-
static
makeEmpty
()¶
-
static
makeFloat
(field_name=u'')¶
-
static
makeInt
(field_name=u'')¶
-
static
makeInterval
(field_name=u'')¶
-
static
makeIntervalYM
(field_name=u'')¶
-
static
makeLongVarbinary
(size, field_name=u'')¶
-
static
makeLongVarchar
(size, field_name=u'')¶
-
static
makeNumeric
(precision, scale, field_name=u'')¶
-
static
makeRowType
(fields, fieldName=u'')¶
-
static
makeTime
(field_name=u'')¶
-
static
makeTimeTz
(field_name=u'')¶
-
static
makeTimestamp
(field_name=u'')¶
-
static
makeTimestampTz
(field_name=u'')¶
-
static
makeUuid
(field_name=u'')¶
-
static
makeVarbinary
(size, field_name=u'')¶
-
static
makeVarchar
(size, field_name=u'')¶
-
reset
(self)¶ INTERNAL
-
setPartitionOrderColumnIdx
(self, partition_idx, order_idx)¶ Sets the PARTITION BY and ORDER BY column indexes.
Returns
None
.
-