Facing weird problem.
HIVE external table 1 - when querying it shows 30 records with some conditions.
Another table also created in HIVE (table2), trying to insert the records from hive table 1 - it missed the records. Only 10 records got loaded.
The difference in the tables are - data type and re-positioning of columns which is maintained for further use.
Attaching the HIVE select table 1 and insert into command for hive table 2