I'm using Amazon EMR.
I have some log data in s3, all in the same bucket, but under different subdirectories
like:

```
"s3://bucketname/2014/08/01/abc/file1.bz"
"s3://bucketname/2014/08/01/abc/file2.bz"
"s3://bucketname/2014/08/01/xyz/file1.bz"
"s3://bucketname/2014/08/01/xyz/file3.bz"

```

I'm using :

```
Set hive.mapred.supports.subdirectories=true;
Set mapred.input.dir.recursive=true;

```

When trying to load all data from "s3://bucketname/2014/08/":

```
CREATE EXTERNAL TABLE table1(id string, at string, 
          custom struct<param1:string, param2:string>)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
LOCATION 's3://bucketname/2014/08/';

```

In return I get:

```
OK
Time taken: 0.169 seconds

```

When trying to query the table:

```
SELECT * FROM table1 LIMIT 10;

```

I get:

```
Failed with exception java.io.IOException:java.io.IOException: Not a file: s3://bucketname/2014/08/01

```

Does anyone has an idea on how to solev this?