From user-return-693-apmail-trafodion-user-archive=trafodion.apache.org@trafodion.incubator.apache.org Sun Sep 18 16:33:11 2016 Return-Path: X-Original-To: apmail-trafodion-user-archive@minotaur.apache.org Delivered-To: apmail-trafodion-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 596C519D09 for ; Sun, 18 Sep 2016 16:33:11 +0000 (UTC) Received: (qmail 50957 invoked by uid 500); 18 Sep 2016 16:33:11 -0000 Delivered-To: apmail-trafodion-user-archive@trafodion.apache.org Received: (qmail 50916 invoked by uid 500); 18 Sep 2016 16:33:11 -0000 Mailing-List: contact user-help@trafodion.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@trafodion.incubator.apache.org Delivered-To: mailing list user@trafodion.incubator.apache.org Received: (qmail 50906 invoked by uid 99); 18 Sep 2016 16:33:11 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 18 Sep 2016 16:33:11 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id A5152C0518 for ; Sun, 18 Sep 2016 16:33:10 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.577 X-Spam-Level: * X-Spam-Status: No, score=1.577 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=2.397] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=splicemachine.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id TqntoU485TqG for ; Sun, 18 Sep 2016 16:33:09 +0000 (UTC) Received: from mail-it0-f42.google.com (mail-it0-f42.google.com [209.85.214.42]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 9C0BC5F46F for ; Sun, 18 Sep 2016 16:33:09 +0000 (UTC) Received: by mail-it0-f42.google.com with SMTP id n143so52428869ita.1 for ; Sun, 18 Sep 2016 09:33:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=splicemachine.com; s=google; h=from:content-transfer-encoding:subject:message-id:date:to :mime-version; bh=9MpRl5ZncZg22Cs2tIqR/YrpssMrPuqq+PNwbIuFdTM=; b=BWJV++7fLfCiJuKuQqxoHpcIZutW3cwDZ4UfLWgG+FClxdqjOfcVKu3dwxAobLGwOS TYDjZcD5/POh7YZ6H1Fm4t9L6oM75OEemnMFAPJTpKUDvyez67yKicZLjZbFOID6Vadr o/Dj443w4J2wMVumoGaD+1WueCgyhrMAHbfK0= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:from:content-transfer-encoding:subject :message-id:date:to:mime-version; bh=9MpRl5ZncZg22Cs2tIqR/YrpssMrPuqq+PNwbIuFdTM=; b=hiqxBE7O1j8LsQUEUMibKbkaqD2V3s15573MN8QPdp5GpBi3zElYD3yYXJbiNJ0ipL p50ZuCzqGU55ENoW+fdNXmS0EEv1r88Mlk9VII7jADwhIU1s1MJbvctQutoQVJsR5Tii nAbtjqtKaBA1MrmaI+p4SXU6mBBzG7NPl/pUB2P5lrG5kwT/aw1ZtCRSZB5cMm6AwfZO 0VTtEgxRd+mkhCVsxcKlAHJSi9n8NS0LCJC35m3G2mYNcOady6C1W4IdI0qTI9UCsPgJ Jv+6wzPXzW93kt/1LUdKiW5iaUqsKALhXHtdPj9ztlfTiniaJNNKrX/+wN02gCl0nwIh j5qg== X-Gm-Message-State: AE9vXwNuBsl+YyXHqLIl/Q5wgzyOIoJx8boMTUdl3sPkt9OcyVV2AfmO/kT6uJU+dJXrZg== X-Received: by 10.36.254.197 with SMTP id w188mr6991329ith.6.1474216382988; Sun, 18 Sep 2016 09:33:02 -0700 (PDT) Received: from [10.0.15.12] (24-182-191-30.dhcp.stls.mo.charter.com. [24.182.191.30]) by smtp.gmail.com with ESMTPSA id m206sm6724955ita.13.2016.09.18.09.33.02 for (version=TLS1 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Sun, 18 Sep 2016 09:33:02 -0700 (PDT) From: Aaron Molitor Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Subject: View of currently running statements Message-Id: Date: Sun, 18 Sep 2016 11:33:03 -0500 To: user@trafodion.incubator.apache.org Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\)) X-Mailer: Apple Mail (2.3124) Hi all, I mn quite new to Trafodion and just trying to understand what = information is available (and where it is) when I am running statements.=20= I am running a simplified workflow based on the TPC-H benchmark. The = flow is to: - create tables - bulk load data - count tables - create indexes - analyze/collect statistics - run the 22 TPC-H queries I am currently on the count tables step. The system got an rpc timeout = exception at the client (trafci), and after dcscheck showed that the dcs = master was down. Two questions: Should I increase the rpc timeout for hbase? If so, how far is = reasonable? How can I see what is running, and how it is progressing (sql statements = in general, specifically count(*) and load statements)? Here is the environment description: 9 nodes all are: Dell R420 - 2 x E5-2430v2 2.5GHz (6C 12T) - 64GB RAM - 4x1TB SATA Running=20 - CDH 5.4.10 (ZooKeeper, HDFS, HBase, YARN Hive) - Trafidion 2.0.1 (binary installer) Thanks,=20 Aaron