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 B3FED200CF3 for ; Tue, 15 Aug 2017 00:08:50 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id B2715165938; Mon, 14 Aug 2017 22:08:50 +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 F11021658C4 for ; Tue, 15 Aug 2017 00:08:49 +0200 (CEST) Received: (qmail 56845 invoked by uid 500); 14 Aug 2017 22:08:47 -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 56836 invoked by uid 99); 14 Aug 2017 22:08:47 -0000 Received: from mail-relay.apache.org (HELO mail-relay.apache.org) (140.211.11.15) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 Aug 2017 22:08:47 +0000 Received: from [10.45.0.84] (70-89-66-137-ca.sfba.hfc.comcastbusiness.net [70.89.66.137]) by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id 847C51A0019 for ; Mon, 14 Aug 2017 22:08:44 +0000 (UTC) User-Agent: Microsoft-MacOutlook/f.24.1.170721 Date: Mon, 14 Aug 2017 15:08:39 -0700 Subject: Re: Long time compiling query/explain..... From: Gopal Vijayaraghavan To: "user@hive.apache.org" Message-ID: <12E6C746-AD76-4E6C-90F6-CB9240569E61@hortonworks.com> Thread-Topic: Long time compiling query/explain..... References: In-Reply-To: Mime-version: 1.0 Content-type: text/plain; charset="UTF-8" Content-transfer-encoding: quoted-printable archived-at: Mon, 14 Aug 2017 22:08:50 -0000 > Running Hive 2.2 w/ LLAP enabled (tried the same thing in Hive 2.3 w/ LLA= P), queries working but when we submit queries like the following (via our a= utomated test framework), they just seem to hang with Parsing Command....Oth= er queries seem to work fine.... Any idea on what's going on or how to debug= ?=C2=A0 I have debug log set and all we're seeing in the HiveServer2 logs are:=20 Get a jstack - like 20 jstacks 1s apart. I think this be similar to the parenthesis parsing bug fixed in 2.3.0. https://issues.apache.org/jira/browse/HIVE-16074 Also getting a dummy table schema would help me run explain on my own build= s. =20 Cheers, Gopal