MD5 value of a table

Hi @Kiddo 

Could you check whether the below link helps your query?

https://community.cloudera.com/t5/Support-Questions/Hive-Do-we-have-checksum-in-hive/td-p/104490
https://community.cloudera.com/t5/Support-Questions/Hive-Can-t-get-the-md5-value/m-p/117696
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF

If you are happy with the reply, mark it Accept as Solution

@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.