Module datarush.library
Class LoadVectorOnHadoopDirect
- java.lang.Object
-
- com.pervasive.datarush.operators.AbstractLogicalOperator
-
- com.pervasive.datarush.operators.CompositeOperator
-
- com.pervasive.datarush.operators.io.vectorwise.dl.LoadVectorOnHadoopDirect
-
- All Implemented Interfaces:
LogicalOperator
@Deprecated public final class LoadVectorOnHadoopDirect extends CompositeOperator
Deprecated.this operator has been replaced withLoadActianVector
; use that operator instead.Load data from the data input stream into an Actian Vector on Hadoop database table. Input fields are mapped to output columns by name. Any unmapped input fields are ignored. Unmapped table columns are not loaded and must be nullable. The Actian Vector on Hadoop database supports the concept of streams. A stream represents a unit of parallelism within the distributed database. The loader operator communicates directly with streams to transfer data into the target database. The input data is not repartitioned to match the number of target streams. If the parallelism (partition count) of the loader operator is less than the number of database streams, some streams will be left idle during the load process.
-
-
Field Summary
Fields Modifier and Type Field Description static String
DEFAULT_VECTOR_H_INSTANCE
Deprecated.static int
DEFAULT_VECTOR_SIZE
Deprecated.
-
Constructor Summary
Constructors Constructor Description LoadVectorOnHadoopDirect()
Deprecated.
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description protected void
compose(CompositionContext context)
Deprecated.Compose the body of this operator.String
getDatabase()
Deprecated.Get the database name.String
getFinalizeTableSQL()
Deprecated.Retrieves the SQL statement to execute after processing all the records.String
getHost()
Deprecated.Get the host name of the server where the leader node is running.String
getInitializeTableSQL()
Deprecated.Retrieves the SQL statement to execute before processing any records.RecordPort
getInputPort()
Deprecated.String
getInsertMode()
Deprecated.Get insert mode ( DEFAULT/ROW/BULK).String
getInstance()
Deprecated.Get the Vector instance name.int
getMaxErrors()
Deprecated.Get the maximum number of errors allowed.String
getPassword()
Deprecated.Get user's password.RecordPort
getRejectPort()
Deprecated.Gets the port providing records which failed the load.Map<String,String>
getRenameMapping()
Deprecated.Get the source to target field mapping.boolean
getRollback()
Deprecated.Get whether rollback is enabled or disabled.String
getTable()
Deprecated.Get the target table name.String
getUser()
Deprecated.Get the user account name.int
getVectorSize()
Deprecated.Get the buffer size (in rows).void
setDatabase(String database)
Deprecated.Set the database name.void
setFinalizeTableSQL(String finalizeTableSQL)
Deprecated.Sets the multiple SQL statements to execute after processing all the records.void
setHost(String host)
Deprecated.Set the host name of the server where the leader node is running.void
setInitializeTableSQL(String initializeTableSQL)
Deprecated.Sets the multiple SQL statements to execute before processing any record(s).void
setInsertMode(String insertMode)
Deprecated.Set insert mode statement applies for Insert and Merge operation.void
setInstance(String instance)
Deprecated.Set the Vector instance name.void
setMaxErrors(int maxErrors)
Deprecated.Set the maximum number of errors allowed per stream before rolling back the data load operation.void
setPassword(String password)
Deprecated.Set user's password.void
setRenameMapping(Map<String,String> renameMapping)
Deprecated.Set a rename mapping.void
setRollback(boolean enabled)
Deprecated.Enable or disable rollback processing.void
setTable(String table)
Deprecated.Set the name of the table to load.void
setUser(String user)
Deprecated.Set the user account name.void
setVectorSize(int vectorSize)
Deprecated.Set the size of the buffer (in rows) used to cache data before sending to the Vector engine.-
Methods inherited from class com.pervasive.datarush.operators.AbstractLogicalOperator
disableParallelism, getInputPorts, getOutputPorts, newInput, newInput, newOutput, newRecordInput, newRecordInput, newRecordOutput, notifyError
-
-
-
-
Field Detail
-
DEFAULT_VECTOR_SIZE
public static final int DEFAULT_VECTOR_SIZE
Deprecated.- See Also:
- Constant Field Values
-
DEFAULT_VECTOR_H_INSTANCE
public static final String DEFAULT_VECTOR_H_INSTANCE
Deprecated.- See Also:
- Constant Field Values
-
-
Method Detail
-
getUser
public String getUser()
Deprecated.Get the user account name.- Returns:
- user account name
-
setUser
public void setUser(String user)
Deprecated.Set the user account name.- Parameters:
user
- the name of the user account that has write/copy permissions
-
getPassword
public String getPassword()
Deprecated.Get user's password.- Returns:
- user's password
-
setPassword
public void setPassword(String password)
Deprecated.Set user's password.- Parameters:
password
- the password of the user account having write/copy permissions
-
getRenameMapping
public Map<String,String> getRenameMapping()
Deprecated.Get the source to target field mapping.- Returns:
- the rename mapping
-
setRenameMapping
public void setRenameMapping(Map<String,String> renameMapping)
Deprecated.Set a rename mapping. This should be an ordered (i.e. LinkedHashMap) mapping of names. The keys in the map represent the original names in the input record port. The values in the map represent the column names in the table. If the names are the same, the mapping is not required. Any columns that are not included in the mapping will be dropped from the input.This is an optional property. If not provided, the input fields are mapped to the target database table by schema order.
- Parameters:
renameMapping
- the mapping from old to new names.
-
getInitializeTableSQL
public String getInitializeTableSQL()
Deprecated.Retrieves the SQL statement to execute before processing any records.- Returns:
- the SQL statement to execute before processing any records
-
setInitializeTableSQL
public void setInitializeTableSQL(String initializeTableSQL)
Deprecated.Sets the multiple SQL statements to execute before processing any record(s). For example, if the table does not exist, then the value for the property is required and must have aCREATE TABLE
statement to create the table.Multiple SQL CREATE, INSERT, UPDATE, DELETE or DROP statements separated by semicolon (;) can be executed.
These statements are executed only once, regardless of
#partitionCount
.- Parameters:
initializeTableSQL
- the SQL statement to execute before processing any records
-
getFinalizeTableSQL
public String getFinalizeTableSQL()
Deprecated.Retrieves the SQL statement to execute after processing all the records.- Returns:
- the SQL statement to execute after processing all the records
-
setFinalizeTableSQL
public void setFinalizeTableSQL(String finalizeTableSQL)
Deprecated.Sets the multiple SQL statements to execute after processing all the records. For Example,CREATE INDEX
statement.Multiple SQL CREATE, INSERT, UPDATE, DELETE or DROP statements separated by semicolon (;) can be executed.
This statement is executed only once, regardless of
#partitionCount
.- Parameters:
finalizeTableSQL
- the SQL statement to execute after processing all the records
-
getMaxErrors
public int getMaxErrors()
Deprecated.Get the maximum number of errors allowed.- Returns:
- maximum errors
-
setMaxErrors
public void setMaxErrors(int maxErrors)
Deprecated.Set the maximum number of errors allowed per stream before rolling back the data load operation.- Parameters:
maxErrors
- maximum errors allowed per stream
-
getRollback
public boolean getRollback()
Deprecated.Get whether rollback is enabled or disabled.- Returns:
- rollback setting
-
setRollback
public void setRollback(boolean enabled)
Deprecated.Enable or disable rollback processing. If enabled, after the maximum number of errors allowed has been encountered, the data load will be aborted and rolled back. No new data will be inserted into the target table.If disabled, the operation is still aborted when the maximum number of errors has been encountered. However, the data load is not rolled back. Any data successfully loaded will appear in the target table.
- Parameters:
rollback
- enable (true) or disable (false) rollback
-
getHost
public String getHost()
Deprecated.Get the host name of the server where the leader node is running.- Returns:
- server host name of the leader node
-
setHost
public void setHost(String host)
Deprecated.Set the host name of the server where the leader node is running.- Parameters:
host
- the server host name of the leader node
-
getInstance
public String getInstance()
Deprecated.Get the Vector instance name.- Returns:
- instance name
-
setInstance
public void setInstance(String instance)
Deprecated.Set the Vector instance name. Defaults to "VH".- Parameters:
instance
- the instance name
-
getDatabase
public String getDatabase()
Deprecated.Get the database name.- Returns:
- database name
-
setDatabase
public void setDatabase(String database)
Deprecated.Set the database name. Specify the database where the target table lives.- Parameters:
database
- the database name
-
getTable
public String getTable()
Deprecated.Get the target table name.- Returns:
- target table name
-
setTable
public void setTable(String table)
Deprecated.Set the name of the table to load.- Parameters:
table
- the name of the target table.
-
getVectorSize
public int getVectorSize()
Deprecated.Get the buffer size (in rows).- Returns:
- buffer size
-
setVectorSize
public void setVectorSize(int vectorSize)
Deprecated.Set the size of the buffer (in rows) used to cache data before sending to the Vector engine. Defaults to 1024.- Parameters:
vectorSize
- buffer size in rows
-
getInputPort
public RecordPort getInputPort()
Deprecated.
-
getRejectPort
public RecordPort getRejectPort()
Deprecated.Gets the port providing records which failed the load.- Returns:
- all records for which failed the load.
to
false
ornull
-
getInsertMode
public String getInsertMode()
Deprecated.Get insert mode ( DEFAULT/ROW/BULK).- Returns:
- insertMode
-
setInsertMode
public void setInsertMode(String insertMode)
Deprecated.Set insert mode statement applies for Insert and Merge operation. Default insert mode is set to DEFAULT.- Parameters:
insertMode
- insert mode for inserts and merges.
-
compose
protected void compose(CompositionContext context)
Deprecated.Description copied from class:CompositeOperator
Compose the body of this operator. Implementations should do the following:- Perform any validation of configuration, input types, etc
- Instantiate and configure sub-operators, adding them to the provided context via
the method
OperatorComposable.add(O)
- Create necessary connections via the method
OperatorComposable.connect(P, P)
. This includes connections from the composite's input ports to sub-operators, connections between sub-operators, and connections from sub-operators output ports to the composite's output ports
- Specified by:
compose
in classCompositeOperator
- Parameters:
context
- the context
-
-