Upgrading from Hive 1 or Hive 2 to Hive 3 may result in missing statistics. In Hive 3, these missing statistics, when detected by the CBO, could cause datasets to be disregarded. You need to fix these statistics after upgrading.
Run ANALYZE on the tables to fix the statistics.
ANALYZE TABLE credit_card_01.cc_acct COMPUTE STATISTICS;