Re: SerDe errors

2014-08-17 Thread Charles Robertson
Hi Roberto, This got solved with the help from another user - the e-mails don't seem to have made it to the user list. There was a problem with the json serde which means it didn't seem to like deserialising an object nested inside the main object. Changing to the Amazon serde fixed it. Thanks, C

Re: SerDe errors

2014-08-14 Thread Roberto Congiu
Can you provide the CREATE statement used to create the table and a sample of the json that's causing the error ? It sounds like you have a field declared as bigint on the schema, but it's actually an object. On Wed, Aug 13, 2014 at 5:05 AM, Charles Robertson < charles.robert...@gmail.com> wrote:

SerDe errors

2014-08-13 Thread Charles Robertson
Hi all, I have a Hive table which relies on a JSON SerDe to read the underlying files. When I ran the create script I specified the SerDe and it all went fine and the data was visible in the views above the table. When I tried to query the table directly, though, I received a ClassNotFound error.