Correct Answer for the Question – How should you control the Sqoop parallel imports if the data does not have a primary key? is given below
How should you control the Sqoop parallel imports if the data does not have a primary key?If the actual values for the primary key are not uniformly distributed across its range, then this can result in unbalanced tasks. You should explicitly choose a different column with the –split-by argument. For example, –split-by employee_id.Note: When performing parallel imports, Sqoop needs a criterion by which it can split the workload. Sqoop uses a splitting column to split the workload. By default, Sqoop will identify the primary key column (if present) in a table and use it as the splitting column. The low and high values for the splitting column are retrieved from the database, and the map tasks operate on evenly-sized components of the total range.References: https://sqoop.apache.org/docs/1.4.2/SqoopUserGuide.html#_importing_data_into_hbase
by specifying no primary key with the –no-primary argument
by specifying the number of maps by using the -m option
by indicating the split size by using the –direct-split-size option
by choosing a different column that contains unique data with the –split-by argument
Correct Answer
The Correct Answer for this Question is
by choosing a different column that contains unique data with the –split-by argument
Explanation
The Question – How should you control the Sqoop parallel imports if the data does not have a primary key? has been answered correctly and answers for the question is by choosing a different column that contains unique data with the –split-by argument
More about these Exams
These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.
We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.
you can find more here at Certout
Feel free to contact via comment or email.
Happy Learning
Cheers, Team Certout
