com.vertica.sdk.ParamWriter Class Reference

Inheritance diagram for com.vertica.sdk.ParamWriter:

Collaboration diagram for com.vertica.sdk.ParamWriter:

Public Member Functions
	ParamWriter (ParamReader params)
void	addCol (ByteBuffer arg, int colstride, VerticaType dt, String colName)
void	addCol (ByteBuffer arg, int colstride, VerticaType dt)
void	addCol (ByteBuffer arg, ByteBuffer da, int colstride, VerticaType dt)
void	addCol (ByteBuffer arg, ByteBuffer da, int colstride, VerticaType dt, String colName)
boolean	checkStringUserBlockInfo (int idx)
boolean	checkTimeUserBlockInfo (int idx)
void	clearParameter (String fieldName)
boolean	containsParameter (String paramName)
boolean	getBoolean (int idx)
boolean	getBoolean (String paramName) throws UdfException
ByteBuffer	getColDataAreaRef (int idx)
ByteBuffer	getColRef (int idx)
java.sql.Date	getDate (String paramName) throws UdfException
java.sql.Date	getDate (int idx)
double	getDouble (int idx)
double	getDouble (String paramName) throws UdfException
int	getIndex (String paramName) throws UdfException
long	getLong (int idx)
long	getLong (String paramName) throws UdfException
int	getNumCols ()
int	getNumRows ()
ArrayList< String >	getParamNames ()
BaseDataOID	getProcessBlockUserInfoVectorAt (int i)
String	getString (String paramName) throws UdfException
String	getString (int idx)
int	getStringLength (String paramName) throws UdfException
int	getStringLength (int idx)
int	getStringLoc (int idx)
java.sql.Timestamp	getTimestamp (String paramName) throws UdfException
java.sql.Timestamp	getTimestamp (int idx)
VerticaType	getType (String paramName) throws UdfException
SizedColumnTypes	getTypeMetaData ()
VNumeric	getVNumeric (String paramName) throws UdfException
VNumeric	getVNumeric (int idx)
VString	getVString (String paramName) throws UdfException
VString	getVString (int idx)
boolean	isBooleanNull (int idx)
boolean	isBooleanNull (String paramName) throws UdfException
boolean	isDateNull (String paramName) throws UdfException
boolean	isDateNull (int idx)
boolean	isDoubleNull (int idx)
boolean	isDoubleNull (String paramName) throws UdfException
boolean	isEmpty ()
boolean	isLongNull (int idx)
boolean	isLongNull (String paramName) throws UdfException
boolean	isStringNull (String paramName) throws UdfException
boolean	isStringNull (int idx)
boolean	isTimestampInfinite (String paramName) throws UdfException
boolean	isTimestampInfinite (int idx)
boolean	isTimestampInfiniteNeg (String paramName) throws UdfException
boolean	isTimestampInfiniteNeg (int idx)
boolean	isTimestampInfinitePos (String paramName) throws UdfException
boolean	isTimestampInfinitePos (int idx)
boolean	isTimestampNull (String paramName) throws UdfException
boolean	isTimestampNull (int idx)
boolean	next () throws UdfException, DestroyInvocation
void	resetBuffers ()
void	setBool (String fieldName, boolean r) throws UdfException
	Adds a BOOLEAN value to the output row. More...
void	setDate (String fieldName, java.sql.Date r) throws UdfException
	Adds a DATE value to the output row. More...
void	setDouble (String fieldName, double r) throws UdfException
	Adds a FLOAT value to the output row. More...
void	setLong (String fieldName, Long r) throws UdfException
	Adds a LONG INTEGER value to the output row. More...
void	setLongString (String fieldName, String r) throws UdfException
	Adds a Long String value to the output row. More...
void	setNumeric (String fieldName, BigDecimal bd)
	Allocate a new VNumeric object to use as output. More...
void	setString (String fieldName, String r) throws UdfException
	Adds a String value to the output row. More...
void	setTimestamp (String fieldName, java.sql.Timestamp r) throws UdfException
	Adds a TIMESTAMP value to the output row. More...
void	setTimestampInfiniteNeg (String fieldName) throws UdfException
void	setTimestampInfinitePos (String fieldName) throws UdfException

Public Attributes
int	count
int	index
int	ncols
int	nrows
HashMap< String, Integer >	paramNameToIndex
SizedColumnTypes	typeMetaData

Protected Member Functions
void	clear ()
ByteBuffer	getInlineColBuffer (int idx)

Protected Attributes
ArrayList< ByteBuffer >	coldataareas
ArrayList< ByteBuffer >	cols
ArrayList< Integer >	colstrides
ArrayList< Integer >	currentPos

Detailed Description

Provides write access to a set of named parameters. This class extends ParamReader to add type-specific methods to write values.

Member Function Documentation

addCol() [1/4]

void com.vertica.sdk.VerticaBlock.addCol ( ByteBuffer  arg, int  colstride, VerticaType  dt, String  colName  )

inherited

Add the location for reading a particular argument.

Parameters

arg	The base location to find data.
colstride	The stride between data instances.
dt	The type of input.
colName	Name of the column

Referenced by com.vertica.sdk.VerticaBlock.addCol().

addCol() [2/4]

void com.vertica.sdk.VerticaBlock.addCol ( ByteBuffer  arg, int  colstride, VerticaType  dt  )

inherited

Add the location for reading a particular argument.

Parameters

arg	The base location to find data.
colstride	The stride between data instances.
dt	The type of input.

addCol() [3/4]

void com.vertica.sdk.VerticaBlock.addCol ( ByteBuffer  arg, ByteBuffer  da, int  colstride, VerticaType  dt  )

inherited

Add the location for reading a particular argument.

Parameters

arg	The base location to find data.
da	The location to find out of band string data.
colstride	The stride between data instances.
dt	The type of input.

addCol() [4/4]

void com.vertica.sdk.VerticaBlock.addCol ( ByteBuffer  arg, ByteBuffer  da, int  colstride, VerticaType  dt, String  colName  )

inherited

Add the location for reading a particular argument.

Parameters

arg	The base location to find data.
da	The location to find out of band string data.
colstride	The stride between data instances.
dt	The type of input.
colName	Name of the column

containsParameter()

boolean com.vertica.sdk.ParamReader.containsParameter ( String  paramName )

inherited

Function to see if the ParamReader has a value for the parameter

Parameters

paramName

parameter name to check

Returns

true if it does

getBoolean()

boolean com.vertica.sdk.BlockReader.getBoolean ( int  idx )

inherited

Get a BOOLEAN value from the input row.

Parameters

idx	The column number to retrieve from the input row.

Returns

The value of the idx'th argument, cast as a BOOLEAN.

getColDataAreaRef()

ByteBuffer com.vertica.sdk.VerticaBlock.getColDataAreaRef ( int  idx )

inherited

Get the ByteBuffer that stores out of line string data (Data Area) for the idx'th argument

Parameters

idx	The column number to retrieve from the input row.

Returns

the ByteBuffer

Referenced by com.vertica.sdk.BlockReader.getVString().

getColRef()

ByteBuffer com.vertica.sdk.VerticaBlock.getColRef ( int  idx )

inherited

Example: ByteBuffer a = arg_reader.getColPtr(0);

Parameters

idx	The column number to retrieve from the input row.

Returns

a ByteBuffer to the idx'th argument, containing data for the column

Referenced by com.vertica.sdk.PartitionWriter.copyFromInput(), com.vertica.sdk.BlockReader.getBoolean(), com.vertica.sdk.BlockReader.getDouble(), com.vertica.sdk.VerticaBlock.getInlineColBuffer(), com.vertica.sdk.BlockReader.getLong(), com.vertica.sdk.BlockReader.getStringLength(), com.vertica.sdk.BlockReader.getStringLoc(), com.vertica.sdk.BlockReader.getVNumeric(), com.vertica.sdk.BlockReader.getVString(), com.vertica.sdk.BlockWriter.getVStringWriter(), com.vertica.sdk.BlockReader.isBooleanNull(), com.vertica.sdk.ParamWriter.setBool(), com.vertica.sdk.BlockWriter.setBoolean(), com.vertica.sdk.BlockWriter.setBooleanNull(), com.vertica.sdk.PartitionWriter.setBooleanValue(), com.vertica.sdk.BlockWriter.setDate(), com.vertica.sdk.BlockWriter.setDateNull(), com.vertica.sdk.PartitionWriter.setDateValue(), com.vertica.sdk.BlockWriter.setDouble(), com.vertica.sdk.ParamWriter.setDouble(), com.vertica.sdk.BlockWriter.setDoubleNull(), com.vertica.sdk.PartitionWriter.setDoubleValue(), com.vertica.sdk.BlockWriter.setLong(), com.vertica.sdk.ParamWriter.setLong(), com.vertica.sdk.BlockWriter.setLongNull(), com.vertica.sdk.ParamWriter.setLongString(), com.vertica.sdk.PartitionWriter.setLongValue(), com.vertica.sdk.ParamWriter.setNumeric(), com.vertica.sdk.BlockWriter.setNumeric(), com.vertica.sdk.ParamWriter.setString(), com.vertica.sdk.BlockWriter.setString(), com.vertica.sdk.BlockWriter.setStringNull(), com.vertica.sdk.BlockWriter.setTimestamp(), com.vertica.sdk.BlockWriter.setTimestampInfiniteNeg(), com.vertica.sdk.BlockWriter.setTimestampInfinitePos(), com.vertica.sdk.BlockWriter.setTimestampNull(), and com.vertica.sdk.PartitionWriter.setTimestampValue().

getDate()

java.sql.Date com.vertica.sdk.BlockReader.getDate ( int  idx )

inherited

Get a DATE value from the input row.

Parameters

idx	The column number to retrieve from the input row.

Returns

The value of the idx'th argument, cast as a DATE; null if the column is NULL.

getDouble()

double com.vertica.sdk.BlockReader.getDouble ( int  idx )

inherited

Get a DOUBLE value from the input row.

Parameters

idx	The column number to retrieve from the input row.

Returns

The value of the idx'th argument, cast as a DOUBLE.

getInlineColBuffer()

ByteBuffer com.vertica.sdk.VerticaBlock.getInlineColBuffer ( int  idx )

protectedinherited

Give a ByteBuffer for the given column (inline storage only). Returns a buffer with position and limit bounding the data area for a single element of that column, given the current position in the column.

Parameters

idx	The column number to retrieve from the input row.

Returns

the ByteBuffer for the column

Referenced by com.vertica.sdk.PartitionWriter.setStringBytes(), and com.vertica.sdk.PartitionWriter.setStringValue().

getLong()

long com.vertica.sdk.BlockReader.getLong ( int  idx )

inherited

Get a LONG INTEGER value from the input row.

Example: long a = arg_reader.getLong(0);

Parameters

idx	The column number to retrieve from the input row.

Returns

The value of the idx'th argument, cast as a LONG INTEGER.

Referenced by com.vertica.sdk.BlockReader.getDate(), com.vertica.sdk.BlockReader.getTimestamp(), com.vertica.sdk.BlockReader.isDoubleNull(), com.vertica.sdk.BlockReader.isLongNull(), com.vertica.sdk.BlockReader.isTimestampInfiniteNeg(), and com.vertica.sdk.BlockReader.isTimestampInfinitePos().

getNumCols()

int com.vertica.sdk.VerticaBlock.getNumCols ( )

inherited

Returns

the number of arguments held by this reader.

getNumRows()

int com.vertica.sdk.VerticaBlock.getNumRows ( )

inherited

Returns

the number of rows held by this block.

getParamNames()

ArrayList<String> com.vertica.sdk.ParamReader.getParamNames ( )

inherited

Returns

all names of parameters stored in this ParamReader

getString()

String com.vertica.sdk.BlockReader.getString ( int  idx )

inherited

Get a reference to an VARCHAR/CHAR/VARBINARY/BINARY value from the input row.

Parameters

idx	The column number to retrieve from the input row.

Returns

a reference to the idx'th argument, cast as an String.

getStringLength()

int com.vertica.sdk.BlockReader.getStringLength ( int  idx )

inherited

Get length of the String from the input row

Parameters

idx	The column number to retrieve from the input row.

Returns

The length of the String in specified column.

Referenced by com.vertica.sdk.BlockReader.getVString(), and com.vertica.sdk.BlockReader.isStringNull().

getStringLoc()

int com.vertica.sdk.BlockReader.getStringLoc ( int  idx )

inherited

Get 'location' of the String from the input row.

Parameters

idx	The column number to retrieve from the input row.

Returns

The location of the String in specified column. If zero, data is inlined immediately after the header, otherwise data is at offset loc within the data area.

Referenced by com.vertica.sdk.BlockReader.getVString().

getTimestamp()

java.sql.Timestamp com.vertica.sdk.BlockReader.getTimestamp ( int  idx )

inherited

Get a TIMESTAMP value from the input row.

Parameters

idx	The column number to retrieve from the input row.

Returns

The value of the idx'th argument, cast as a TIMESTAMP; null if the column is NULL or represents 'infinity'.

getType()

VerticaType com.vertica.sdk.ParamReader.getType ( String  paramName ) throws UdfException

inherited

Parameters

paramName

parameter name

Returns

the type of the given parameter

Exceptions

UdfException

UDF problem

getTypeMetaData()

SizedColumnTypes com.vertica.sdk.VerticaBlock.getTypeMetaData ( )

inherited

Returns

information about the types and numbers of arguments

Referenced by com.vertica.sdk.ParamReader.getType(), com.vertica.sdk.PartitionWriter.setRowFromMap(), and com.vertica.sdk.PartitionWriter.setValue().

getVNumeric()

VNumeric com.vertica.sdk.BlockReader.getVNumeric ( int  idx )

inherited

Get a reference to a VNumeric value from the input row.

Parameters

idx	The column number to retrieve from the input row.

Returns

A reference to the retrieved value cast as a Numeric.

getVString()

VString com.vertica.sdk.BlockReader.getVString ( int  idx )

inherited

Get a reference from the input row to an VString value, which represents a SQL VARCHAR/CHAR/VARBINARY/BINARY value.

Parameters

idx	The column number to retrieve from the input row.

Returns

a reference to the idx'th argument, cast as an VString.

Referenced by com.vertica.sdk.BlockReader.getString().

isBooleanNull()

boolean com.vertica.sdk.BlockReader.isBooleanNull ( int  idx )

inherited

Check whether a value from the input row is NULL in BOOLEAN type.

Parameters

idx	The column number to retrieve from the input row.

Returns

true if the value is NULL, false otherwise.

isDateNull()

boolean com.vertica.sdk.BlockReader.isDateNull ( int  idx )

inherited

Check whether a value from the input row is NULL in DATE type.

Parameters

idx	The column number to retrieve from the input row.

Returns

true if the value is NULL, false otherwise.

Referenced by com.vertica.sdk.BlockReader.getDate().

isDoubleNull()

boolean com.vertica.sdk.BlockReader.isDoubleNull ( int  idx )

inherited

Check whether a value from the input row is NULL in DOUBLE type.

Parameters

idx	The column number to retrieve from the input row.

Returns

true if the value is NULL, false otherwise.

isEmpty()

boolean com.vertica.sdk.ParamReader.isEmpty ( )

inherited

Returns

true if there are no parameters

isLongNull()

boolean com.vertica.sdk.BlockReader.isLongNull ( int  idx )

inherited

Check whether a value from the input row is NULL in LONG INTERGER type.

Parameters

idx	The column number to retrieve from the input row.

Returns

true if the value is NULL, false otherwise.

Referenced by com.vertica.sdk.BlockReader.isDateNull(), and com.vertica.sdk.BlockReader.isTimestampNull().

isStringNull()

boolean com.vertica.sdk.BlockReader.isStringNull ( int  idx )

inherited

Check whether a value from the input row is NULL in SQL VARCHAR/CHAR/VARBINARY/BINARY type.

Parameters

idx	The column number to retrieve from the input row.

Returns

true if the value is NULL, false otherwise.

Referenced by com.vertica.sdk.BlockReader.getString().

isTimestampInfinite()

boolean com.vertica.sdk.BlockReader.isTimestampInfinite ( int  idx )

inherited

Check whether a TIMESTAMP value from the input row represents 'infinity'.

Parameters

idx	The column number to retrieve from the input row.

Returns

true if the TIMESTAMP value is '+infinity' or '-infinity', false otherwise.

Referenced by com.vertica.sdk.BlockReader.getTimestamp().

isTimestampInfiniteNeg()

boolean com.vertica.sdk.BlockReader.isTimestampInfiniteNeg ( int  idx )

inherited

Check whether a TIMESTAMP value from the input row represents '-infinity'.

Parameters

idx	The column number to retrieve from the input row.

Returns

true if the TIMESTAMP value is '-infinity', false otherwise.

Referenced by com.vertica.sdk.BlockReader.isTimestampInfinite().

isTimestampInfinitePos()

boolean com.vertica.sdk.BlockReader.isTimestampInfinitePos ( int  idx )

inherited

Check whether a TIMESTAMP value from the input row represents '+infinity'.

Parameters

idx	The column number to retrieve from the input row.

Returns

true if the TIMESTAMP value is '+infinity', false otherwise.

Referenced by com.vertica.sdk.BlockReader.isTimestampInfinite().

isTimestampNull()

boolean com.vertica.sdk.BlockReader.isTimestampNull ( int  idx )

inherited

Check whether a value from the input row is NULL in TIMESTAMP type.

Parameters

idx	The column number to retrieve from the input row.

Returns

true if the value is NULL, false otherwise.

Referenced by com.vertica.sdk.BlockReader.getTimestamp().

next()

boolean com.vertica.sdk.BlockReader.next ( ) throws UdfException, DestroyInvocation

inherited

Advance to the next record.

Returns

true if there are more rows to read, false otherwise.

Exceptions

UdfException	UDF problem
DestroyInvocation	Invocation needed to be destroyed

setBool()

void com.vertica.sdk.ParamWriter.setBool	(	String	fieldName,
		boolean	r
	)		throws UdfException

Adds a BOOLEAN value to the output row.

Parameters

r	The BOOLEAN value to insert into the output row.

setDate()

void com.vertica.sdk.ParamWriter.setDate	(	String	fieldName,
		java.sql.Date	r
	)		throws UdfException

Adds a DATE value to the output row.

Parameters

r	The DATE value to insert into the output row.

setDouble()

void com.vertica.sdk.ParamWriter.setDouble	(	String	fieldName,
		double	r
	)		throws UdfException

Adds a FLOAT value to the output row.

Parameters

r	The FLOAT value to insert into the output row.

setLong()

void com.vertica.sdk.ParamWriter.setLong	(	String	fieldName,
		Long	r
	)		throws UdfException

Adds a LONG INTEGER value to the output row.

Parameters

r	The LONG INTEGER value to insert into the output row.

Referenced by com.vertica.sdk.ParamWriter.setDate(), and com.vertica.sdk.ParamWriter.setTimestamp().

setLongString()

void com.vertica.sdk.ParamWriter.setLongString	(	String	fieldName,
		String	r
	)		throws UdfException

Adds a Long String value to the output row.

Parameters

r	The Long String value to insert into the output row.

setNumeric()

void com.vertica.sdk.ParamWriter.setNumeric	(	String	fieldName,
		BigDecimal	bd
	)

Allocate a new VNumeric object to use as output.

Returns

A new VNumeric object to hold output. This object automatically added to the output row.

setString()

void com.vertica.sdk.ParamWriter.setString	(	String	fieldName,
		String	r
	)		throws UdfException

Adds a String value to the output row.

Parameters

r	The String value to insert into the output row.

setTimestamp()

void com.vertica.sdk.ParamWriter.setTimestamp	(	String	fieldName,
		java.sql.Timestamp	r
	)		throws UdfException

Adds a TIMESTAMP value to the output row.

Parameters

r	The TIMESTAMP value to insert into the output row.