Reads documents from a MapR-DB database to load the data in a given Job.
You must have properly installed and configured your MapR Client before using this component. A optmaprconfmapr-clusters.conf file is automatically generated out of the Client configuration process to store the connection information to your MapR cluster and your MapR-DB database. At runtime, this OJAI component reads this connection information by itself to connect to the MapR-DB database to be used.
For further information about how to install and configure your MapR client, see Setting up the Client from the MapR documentation.
tMapROjaiInput Standard properties
These properties are used to configure tMapROjaiInput running in the Standard Job framework.
tMapROjaiInput component belongs to the Databases NoSQL family.
|Distribution and Version
Select the version of your MapR cluster. This cluster must host the MapR-DB database to be used.
Schema and Edit schema
A schema is a row description. It defines the number of fields
schema to make changes to the schema.
Note: If you
make changes, the schema automatically becomes built-in.
This component supports the Document type. If a field is for entire
Use kerberos authentication
If you are accessing a MapR-DB as-OJAI database
Every time when you launch your Job, the
|Use a keytab to authenticate
Select the Use a keytab to authenticate
Note that the user that executes a keytab-enabled Job is not necessarily
Restrict partial sorts with Secondary Indexes
Select this check box to force the query to explicitly sort on the actual
For further information about this partial sorts issue of MapR OJAI, see
Do not select this check box if you do not expect to encounter the lags
Enter the name of the table to be processed.
Specify the where clause of the query to be performed by
For example, type in
As OJAI uses MongoDB query format for queries, see Query Operators from the
Each column of the schema defined for this component represents a field of the documents
For example, in the document reading as
first and the last
fields have person as their parent node but the _id field does not have any parent node. So once completed, this
Mapping table should read as
Select this check box to gather the Job processing metadata at the Job level
ERROR_MESSAGE: the error message generated by the
NB_LINE: the number of rows read by an input component or
A Flow variable functions during the execution of a component while an After variable
To fill up a field or expression with a variable, press Ctrl +
For further information about variables, see
tMapROjaiInput executes queries to read data from a