Support Questions
Find answers, ask questions, and share your expertise

Insert into HIVE - Partially Loaded the records

Highlighted

Insert into HIVE - Partially Loaded the records

New Contributor

Hi,

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

 

 

Don't have an account?