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, Charles On 14 August 2014 17:49, Roberto Congiu <roberto.con...@openx.com> wrote: > 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: > >> 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. I >> solved this by putting the SerDe JAR in /usr/lib/hive/lib. >> >> Now, however, when I try to query the data I get: >> >> Failed with exception >> java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: >> java.lang.ClassCastException: org.json.JSONObject cannot be cast to >> [Ljava.lang.Object; >> >> (The serde is the json serde provided by Apache) >> >> Can anyone suggest why it was working before, but no longer is? >> >> Thanks, >> Charles >> > > > > -- > ---------------------------------------------------------- > Good judgement comes with experience. > Experience comes with bad judgement. > ---------------------------------------------------------- > Roberto Congiu - Data Engineer - OpenX > tel: +1 626 466 1141 >
