-Re: Creating external table poiting to s3 folder with files not loading data
It is more likely related to your SerDe and the underlying data not
matching up to it and than being related to the table being external
On Tue, Dec 11, 2012 at 6:05 AM, Fernando Andrés Doglio Turissini
<[EMAIL PROTECTED]> wrote:
> Long subject, I know.. let me explain a bit more about the problem:
> I'm trying to load a file into a hive table (this is on an EMR instance) for
> that I create an external table, and I set the location to the folder on an
> s3 bucket, where the file resides.
> The problem is that even though the table is created correctly, when I do a
> "select * from table" it returns nothing. I'm not seeing errors on the logs
> either, so I don't know what can be happening....
> Also, probably important: I'm using a custom SerDe that I did not
> write...but I do have the code for it.
> I'm quite new to hive, so I appreciate any kind of pointers you can throw at
> Fernando Doglio