Hive Table not found even table exist

If we get table not found in hive table even if you have drop and create before inserting data into table. you can fix with below two options

option1: set SYNC_DDL=1;  only if you are using impala
option2: create table with select statement