Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id E9E60200B72 for ; Fri, 26 Aug 2016 17:32:54 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id E8C1A160AB6; Fri, 26 Aug 2016 15:32:54 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 32F12160A94 for ; Fri, 26 Aug 2016 17:32:54 +0200 (CEST) Received: (qmail 66861 invoked by uid 500); 26 Aug 2016 15:32:53 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 66852 invoked by uid 99); 26 Aug 2016 15:32:53 -0000 Received: from mail-relay.apache.org (HELO mail-relay.apache.org) (140.211.11.15) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Aug 2016 15:32:53 +0000 Received: from [192.168.2.108] (adsl-71-145-210-73.dsl.austtx.sbcglobal.net [71.145.210.73]) by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id 55D691A0118 for ; Fri, 26 Aug 2016 15:32:52 +0000 (UTC) User-Agent: Microsoft-MacOutlook/14.5.9.151119 Date: Fri, 26 Aug 2016 08:32:48 -0700 Subject: Re: hive 2.1.0 + drop view From: Gopal Vijayaraghavan Sender: Gopal Vijayaraghavan To: "user@hive.apache.org" Message-ID: Thread-Topic: hive 2.1.0 + drop view References: In-Reply-To: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit archived-at: Fri, 26 Aug 2016 15:32:55 -0000 > 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/java/org/apache/ha doop/hive/metastore/MetaStoreDirectSql.java#L887 Cheers, Gopal