Querying Row Comparison Details

Updated on 2024-08-23 GMT+08:00

View PDF

Function

This API is used to query row comparison details.

URI

GET /v3/{project_id}/jobs/{job_id}/compare/{compare_job_id}/line-detail

**Table 1** Path parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Project ID of a tenant in a region. For details, see Obtaining a Project ID.
job_id	Yes	String	Task ID.
compare_job_id	Yes	String	ID of a comparison task.

**Table 2** Query parameters
Parameter	Mandatory	Type	Description
status	No	Integer	Comparison status. 0: The comparison result is inconsistent. 2: The comparison result is consistent. 3: The destination database table does not exist. 4: The comparison failed. 5: The comparison task is in progress. 6: The comparison task is waiting to be started. 7: The comparison task is canceled. 8: The source database is empty. 9: The destination database is empty. 10: Both the source and destination databases are empty. 11: The source table does not exist. 12: The destination table does not exist. 13: Neither the source table nor the destination table exists. 14: Failed to connect to the source database. 15: Failed to connect to the destination database. 16: SQL execution timed out on the source database. 17: SQL execution timed out on the destination database. 18: A source database SQL execution error occurred. 19: A destination database SQL execution error occurred. 20: Neither the source database nor the destination database exists. 21: The source database does not exist. 22: The destination database does not exist. 23: The number of rows exceeds 100 million, and the comparison cannot be performed. 27: The comparison task timed out.
type	No	String	Type. compare: Items that can be compared. unCompare: Items that cannot be compared.
db_name	No	String	Source database name.
target_db_name	No	String	Destination database name.
query_tb_name	No	String	Keyword for filtering table names.
limit	No	Integer	Number of items displayed per page. Default value: 1000
offset	No	Integer	Offset, which is the position where the query starts. The value must be no less than 0. Default value: 0

Request Parameters

**Table 3** Request header parameters
Parameter	Mandatory	Type	Description
Content-Type	Yes	String	The content type. The default value is application/json.
X-Auth-Token	Yes	String	User token obtained from IAM.
X-Language	No	String	Request language type. Default value: en-us Enumerated values: en-us zh-cn

Response Parameters

Status code: 200

**Table 4** Response body parameters
Parameter	Type	Description
total_count	Integer	Comparison quantity.
table_line_compare_result_infos	Array of objects	Comparison information list. For details, see Table 5.

**Table 5** Data structure description of field **TableLineCompareResultInfo**
Parameter	Type	Description
source_table_name	String	Table name of the source database.
source_row_num	Long	Number of table rows in the source database.
target_table_name	String	Table name of the destination database.
target_row_num	Long	Number of table rows in the destination database.
difference_row_num	Long	Row differences.
status	Integer	Comparison status. 0: The comparison result is inconsistent. 2: The comparison result is consistent. 3: The destination database table does not exist. 4: The comparison failed. 5: The comparison task is in progress. 6: The comparison task is waiting to be started. 7: The comparison task is canceled. 8: The source database is empty. 9: The destination database is empty. 10: Both the source and destination databases are empty. 11: The source table does not exist. 12: The destination table does not exist. 13: Neither the source table nor the destination table exists. 14: Failed to connect to the source database. 15: Failed to connect to the destination database. 16: SQL execution timed out on the source database. 17: SQL execution timed out on the destination database. 18: A source database SQL execution error occurred. 19: A destination database SQL execution error occurred. 20: Neither the source database nor the destination database exists. 21: The source database does not exist. 22: The destination database does not exist. 23: The number of rows exceeds 100 million, and the comparison cannot be performed. 27: The comparison task timed out.
compare_line_config_filter	String	Row filtering condition.

Example Request

Querying row comparison details

https://{endpoint}/v3/054ba152d480d55b2f5dc0069e7ddef0/jobs/f8688cfa-4e05-406f-a2e6-37a773cjb20y/table/compare/48c6acb4-1473-48fd-8676-df3705758c27/line-detail?offset=0&limit=10

Example Response

Status code: 200

{
  "total_count" : 2,
  "table_line_compare_result_infos" : [ {
    "source_table_name" : "tb2",
    "source_row_num" : 2434882,
    "target_table_name" : "tb2",
    "target_row_num" : 2434882,
    "difference_row_num" : 0,
    "status" : 2
  }, {
    "source_table_name" : "tb1",
    "source_row_num" : 1,
    "target_table_name" : "tb1",
    "target_row_num" : 1,
    "difference_row_num" : 0,
    "status" : 2
  } ]
}

Status code: 400

Bad Request

{
  "error_code" : "DRS.M00202",
  "error_msg" : "The value of jobId is invalid."
}

Status Code

Status Code	Description
200	OK
400	Bad Request

Error Code

For details, see Error Code.

Parent topic: Public API Management

Previous topic: Querying the Row Comparison Overview

Next topic: Querying the Value Comparison Overview

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel