I have a case where I want to dump data daily under
I thought of making this an external table on Hive so that I can just keep dumping data daily.
In my external table definition , I specified the location as /user/sampd/test.
But when I try to run a query on the table , I get an exception .
Failed with exception java.io.IOException:java.io.IOException: Not a file:<hdfs path to the folder>.
This is inspite of setting mapred.input.dir.recursive=true;
Is this a supported feature in Hive ? Any alternatives ?