From user-return-5814-apmail-drill-user-archive=drill.apache.org@drill.apache.org Mon May 9 19:33:43 2016 Return-Path: X-Original-To: apmail-drill-user-archive@www.apache.org Delivered-To: apmail-drill-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id AEF93198B6 for ; Mon, 9 May 2016 19:33:43 +0000 (UTC) Received: (qmail 86769 invoked by uid 500); 9 May 2016 19:33:38 -0000 Delivered-To: apmail-drill-user-archive@drill.apache.org Received: (qmail 86708 invoked by uid 500); 9 May 2016 19:33:38 -0000 Mailing-List: contact user-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@drill.apache.org Delivered-To: mailing list user@drill.apache.org Delivered-To: moderator for user@drill.apache.org Received: (qmail 77958 invoked by uid 99); 9 May 2016 19:31:38 -0000 X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.279 X-Spam-Level: * X-Spam-Status: No, score=1.279 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=zscaler-com.20150623.gappssmtp.com DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zscaler-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=RRpYKlayrOh+mSVipJggev0YI7gDUn+ITKIF8gXL7BY=; b=F2xDW1hYL9Kfb/ljUWJRbJ1fsleHFznB92ZLf+vNJbPViDuZJX086Y19jJxUWaSKcx bz7rJeY8Y0xT6MJ0XKn+TGC59vhIqnnX/cHakxaPItGdyp5zxv/kvHejKLIHQo/rPoIJ 4yBfopbpBbpjmuL8Bp11SDu3OK4AyfAHlOYZqQy+BqU8iq3777vcdFWartqqHCIqFf2c pz46GfHN+8aNhBI7BecukPY8mhOgHhjmACnNf0VuTrhEzjfEu554ugPnQr9MFayt8erd Msr9ROQj/NVSTxWgkBF9YzSj+R8zQiW53GKmwq/Ng2Hu5f7ujkA/ehirGtHWb5X+sedC dwKg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=RRpYKlayrOh+mSVipJggev0YI7gDUn+ITKIF8gXL7BY=; b=Q5U1USWTbvDoD9zlKE6nuTPXt2tS4aVGF4pwNAWX4IxDGm6FVnrIC4TLzojjMnGMqB nF9dWuiBahASGIdWSMihi74A4zMaTN815f08h9vPT0xhkGm40sQ6hWwKz7QM1tyoiTVL tzeqpLAh4Qb/JfTFtKDEieqv76KpX01ml8AYynQRQYABfIIFo3sM4Z6Q98PRe6PXFHyg ZbNj16Pgqkv4PbpLv+LjSglyMsNw1dAUY+irkPybCdFxLskIbrm/QDVZi8LpYmZ595Od PfjVWPhrkZLhwafDKLA1eqgoqrx40tV2v8r9upnBjBYG7AkWaRsGo9GcnCuDVMbgfTY0 DBRQ== X-Gm-Message-State: AOPr4FVWLrLH6b/4CkKrFYM6wqAWelOwmyXownLItfyfz0r8Ew/n+SGD31lyd8VdZ6z1pYV8pEy9eR7m77T3du7U X-Received: by 10.28.7.197 with SMTP id 188mr13454344wmh.101.1462822296673; Mon, 09 May 2016 12:31:36 -0700 (PDT) MIME-Version: 1.0 From: Subbu Srinivasan Date: Mon, 9 May 2016 12:30:57 -0700 Message-ID: Subject: Queries and Timeout To: user@drill.apache.org Content-Type: multipart/alternative; boundary=001a114422c25d063905326ddb9c --001a114422c25d063905326ddb9c Content-Type: text/plain; charset=UTF-8 What is the best way to implement queries that are long running? If queries take a long time I get this error. I understand that setting query timeouts are not yet supported in the JDBC interface. I get this error even if I run the query from the drill console (and !set timeout -1) Error: SYSTEM ERROR: ConnectTimeoutException: connection timed out: -- Pardon me for typos or if I do not start with a hi or address you by name. Want to make sure my carpel tunnel syndrome does not get worse. Subbu --001a114422c25d063905326ddb9c--