Class LoadVectorOnHadoopDirect

  • All Implemented Interfaces:
    LogicalOperator

    @Deprecated
    public final class LoadVectorOnHadoopDirect
    extends CompositeOperator
    Deprecated.
    this operator has been replaced with LoadActianVector; 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.
    • Constructor Detail

      • LoadVectorOnHadoopDirect

        public LoadVectorOnHadoopDirect()
        Deprecated.
    • 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 a CREATE 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 or null
      • 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:
        1. Perform any validation of configuration, input types, etc
        2. Instantiate and configure sub-operators, adding them to the provided context via the method OperatorComposable.add(O)
        3. 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 class CompositeOperator
        Parameters:
        context - the context