I created an external hive table pointing to directory
Inside logs directory I have multiple subfolders as follows:
I have also used the config:
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
Reading directories recursively isn't supported by Impala, only Hive. There is a closed JIRA asking for this to be added.