Sounds like there are a number of issues with Hive metastore on Postgres. There have been a number of reports on this.
HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com *Disclaimer:* Use it at your own risk. Any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on this email's technical content is explicitly disclaimed. The author will in no case be liable for any monetary damages arising from such loss, damage or destruction. On 26 August 2016 at 16:43, Stephen Sprague <sprag...@gmail.com> wrote: > thanks Gopal. you're right our metastore is using Postgres. very > interesting you were able to intuit that! > > lemme give your suggestions a try and i'll post back. > > thanks! > Stephen > > On Fri, Aug 26, 2016 at 8:32 AM, Gopal Vijayaraghavan <gop...@apache.org> > wrote: > >> > NULL::character%20varying) >> ... >> > i want to say this is somehow related to a java version (we're using 8) >> >but i'm not sure. >> >> The "character varying" looks like a lot like a Postgres issue to me >> (though character varying could be the real term for varchar in another >> DB). >> >> The hive-metastore.log should have the real backtrace. >> >> You can try doing >> >> set hive.metastore.uris=; >> set hive.metastore.try.direct.sql=false; >> >> >> (i.e switch to embedded metastore + disable direct sql, in Hive CLI - >> provided you have all the password stuff for the metastore in the regular >> hive-site.xml) >> >> https://github.com/apache/hive/blob/master/metastore/src/jav >> a/org/apache/ha >> doop/hive/metastore/MetaStoreDirectSql.java#L887 >> <https://github.com/apache/hive/blob/master/metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java#L887> >> >> >> Cheers, >> Gopal >> >> >> >
