-Re: Creating external table poiting to s3 folder with files not loading data
Mark Grover 2012-12-14, 09:05
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