I am facing few issues with hive. Please provide your inputs. Thanks.   I have an hive external table (staging) in text format which points to the location where sqoop imports the file. I have another hive internal table (final) in parquet format with date level partitioning. then load data into final table using  Insert into table final partition (date) select col1, col2,...dtCol  from staging.   oozie job:  step1 - sqoop to hive external table location step2  - load to final table using insert SQL above     1. I noticed that sometimes though oozie job runs successfully and files are available in external table path, select * from staging returns 0 results. If I drop and create the table again, then it is returning data.  Any idea why? Do I need to run something to refresh the table after files are placed everytime?  This happens randomly, not every time.   2.  I am seeing above issue with final table also. I can see partition folder created and file in it but select * is not returning any values. If I give show partitions, it is displaying none. This is also happening sometimes. If I drop, create and run the job again, it works. But I can do this as for internal table, all data will deleted if I drop the table.      3. if I run the rerun job more than once, I see one than one file under the partition folder in hdfs. Files names are like below. If I do select * from final, it it only returning data from first file. Wont hive return duplicate records? How I can add more data/file to the existing partition?    00000_0 00000_0_copy_1 00000_0_copy_2     ... View more