In testing, I have come across two strange occurrences, neither of which I have since reproduced. Both happened after doing a bulk import.
1) A summary query began to return an incorrect results for the counts. Selecting the full set of data show the correct records, i.e. select gender,count(*) from data group by gender where state='ME' returned like 1 for male, but select * from data where state='ME' and gender='male' return like 150. After deleting a bogus record (that wasn't male nor ME), the queries started to return the correct results.
2) After importing a large data set (20m by 200), running a simple query that should have taken a couple seconds, pegged 50+ cores and didn't return after letting it sit for 20 minutes. After restarting the infinidb service, executing the same exact query again took 5 seconds.
The two of these combined make me think there is some step I might be missing while doing an import.
1) Should the server be shutdown or restarted after doing an import?
2) Is there some "clear cache" or "sync up" command that needs to be called after doing an import?
The sequence I have been following while testing is to drop the tables and database, create a new database and tables, create the import job, import data using bulk loader.