AUTOMATIC VERIFICATION AND TRIAGE OF QUERY RESULTS

摘要

Techniques are provided for automatic verification of query results obtained from data formatted different from row-major format. Techniques are also provided for automatic triage of query results obtained from data formatted different from row-major format. In an embodiment, the query results may be obtained from querying data formatted in column-major format. In an embodiment, when the query results are determined to be incorrect, a cause of the error in the query results can be automatically identified.

主权项

1. A method comprising:
in response to receiving a query to be executed using first data organized in column-major format in a first data object, scanning a first row of the first data and scanning a second row of the first data; generating a first abbreviated representation of data contained in the first row of the first data and a second abbreviated representation of data contained in the second row of the first data; scanning second data organized in a different format from the column-major format in a second data object, wherein scanning the second data comprises scanning a third row of the second data that corresponds to the first row of the first data and scanning a fourth row of the second data that corresponds to the second row of the first data; generating a third abbreviated representation of data contained in the third row of the second data and a fourth abbreviated representation of data contained in the fourth row of the second data; when either the first abbreviated representation does not match the third abbreviated representation or the second abbreviated representation does not match the fourth abbreviated representation, providing an indication of an inaccuracy in query results corresponding to the query; when the first abbreviated representation matches the third abbreviated representation and the second abbreviated representation matches the fourth abbreviated representation, providing the query results.