@Kiddo you either need to get the md5 of all the records or  you could collect it for the concatenated form of all the column names in a table.   e.g. select md5(concat(col1,col2)) from table1;   or. select md5(concat(*)) from (SELECT collect_list(column_name) as col_name from information_schema.columns where table_schema='db1' and table_name='table1')e;   Hope this answers your question.   ... View more