I just reinstalled and tested this again. Same outcome, so I think there is an issue with the latest Sandbox build. I am using the Fusion version. It appears that perhaps the file is partitioned into multiple parts and HCatalog is only importing/using one of those parts (stocks_symbols that begin with “A”).
The file itself is correct, but when moved into HCatalog its truncated and so the select on symbol_name IBM fails. And of course the SELECT count(*) returns less rows than is shown.