What is boundary query in sqoop?

KimQ
KimQ

Posted On: Feb 25, 2020

 

The boundary query is used for splitting the value according to id_no of the database table.

To boundary query, we can take a minimum value and maximum value to split the value.

To make split using boundary queries, we need to know all the values in the table.

To import data from the database to HDFS using boundary queries.

Example--boundary-query

"SELECT min(id_value), max(id_value) from table_name"

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Sqoop Interview Questions

    What is Sqoop?

    The sqoop is an acronym of SQL-TO-HADOOP. It is a command-line interface application. It is worked for conveying data between relational databases (MySQL/ PostgreSQL/Oracle/SQL Server/DB2) and Hadoop ...

    Sqoop Interview Questions

    What is sqoop used for?

    The sqoop is primarily conveying the immense data between the relational database and the Hadoop ecosystem. The entire database or individual table import to the ecosystem (HDFS) and after modificatio...

    Sqoop Interview Questions

    List some major features of Apache Sqoop?

    The following list of apache sqoop features.Compression Connectors for all major RDBMS databases Kerberos security integration Full load Incremental load Import results of database query Loa...