Support Questions

Find answers, ask questions, and share your expertise

Data visible in hive table but not in impala for data files inside subdirectories


I created an external hive table pointing to directory


LOCATION '/user/hive/warehouse/logs'

Inside logs directory I have multiple subfolders as follows:




I have also used the config:


set hive.mapred.supports.subdirectories=true;
set mapred.input.dir.recursive=true;

Using the 'hive' cli I am able to query the data and see the results


But when I perform query using Impala I see no results. Do i need to provide some configuration here




Because you defined a new the table from outside of impala , you need to refresh hive metadata in impala.


fire this command in the impala-shell or Hue


You should be able to query the table

New Contributor

Reading directories recursively isn't supported by Impala, only Hive. There is a closed JIRA asking for this to be added.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.