How should you control the Sqoop parallel imports if the data does not have a primary key?

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

Leave a Comment