Query - select count(1) from dbname.personal_data_rc tablesample(1000 rows);
Output - 7000
Can you help me understand why if I have TABLESAMPLE set to 1000 rows, it is giving me more rows? Is there any other property that must be used with CombineHiveInputFormat/HiveInputFormat or is it an issue with CombineHiveInputFormat/HiveInputFormat only?
If it's not the above case, then what could be the reason for this behaviour?