08-07-2017 05:13 PM
I have an issue with sqoop, i have a staging table which is a copy from prod, so i did a sqoop from the staging table, after that, i did an incremental append from the prod to sqoop the missing ones, it says completed and shows the correct last value, but in hive i dont see the new ones.
Is it boz it remembers they are from different databases? i use the same target-dir
08-07-2017 10:37 PM - edited 08-07-2017 10:40 PM
Does your hive table location points to the that same target-dir ? if so then perform the REFRESH command.
since you you had addedd new data files into the HDFS data directory for the table.
try the below command and fire the hive command once again .
Let me know if that helps ?