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 DE891200C3A for ; Fri, 3 Mar 2017 02:27:40 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id D9D41160B7A; Fri, 3 Mar 2017 01:27:40 +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 099B6160B6F for ; Fri, 3 Mar 2017 02:27:39 +0100 (CET) Received: (qmail 903 invoked by uid 500); 3 Mar 2017 01:27:39 -0000 Mailing-List: contact dev-help@hawq.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hawq.incubator.apache.org Delivered-To: mailing list dev@hawq.incubator.apache.org Received: (qmail 892 invoked by uid 99); 3 Mar 2017 01:27:39 -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; Fri, 03 Mar 2017 01:27:39 +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 BF0FDC2129 for ; Fri, 3 Mar 2017 01:27:38 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -1.869 X-Spam-Level: X-Spam-Status: No, score=-1.869 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=2, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, RP_MATCHES_RCVD=-0.001, SPF_NEUTRAL=0.652] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id h3UNruRBgqOb for ; Fri, 3 Mar 2017 01:27:37 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with SMTP id D4DBB5F257 for ; Fri, 3 Mar 2017 01:27:35 +0000 (UTC) Received: (qmail 877 invoked by uid 99); 3 Mar 2017 01:27:34 -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, 03 Mar 2017 01:27:34 +0000 Received: from mail-qk0-f172.google.com (mail-qk0-f172.google.com [209.85.220.172]) by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id 522291A02FC for ; Fri, 3 Mar 2017 01:27:34 +0000 (UTC) Received: by mail-qk0-f172.google.com with SMTP id n127so154203370qkf.0 for ; Thu, 02 Mar 2017 17:27:34 -0800 (PST) X-Gm-Message-State: AMke39m8C+VHeTwnbghQaTvSAzR2xIUcjOmT75XmvW0c7+C4hHVw3c2PxA9tUxyJ2z/gyi7CERgkXWVqEhYVwQTS X-Received: by 10.55.16.5 with SMTP id a5mr188739qkh.17.1488504453241; Thu, 02 Mar 2017 17:27:33 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Vineet Goel Date: Fri, 03 Mar 2017 01:27:22 +0000 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: hawq Ambari integration To: dev@hawq.incubator.apache.org Content-Type: multipart/alternative; boundary=001a1146f47e2ed4680549c97331 archived-at: Fri, 03 Mar 2017 01:27:41 -0000 --001a1146f47e2ed4680549c97331 Content-Type: text/plain; charset=UTF-8 Having worked with Ambari and knowing the complexities of this desired integration, I agree with Alex on his comments below. Users need some time to get used to exclusive HAWQ CLI or Ambari usage model, and avoid mix and match despite the fact that HAWQ CLI and Ambari have their advantages/disadvantages. -Vineet On Thu, Mar 2, 2017 at 5:17 PM Alexander Denissov wrote: > Ambari is designed as a tool to sit on top of individual service CLI tools > and provide consistent user experience. Ambari can also have wizards and > custom actions that go beyond service lifecycle management. It is assumed > by Ambari design that once Ambari is used to manage configurations, CLI > tools should not be used, otherwise changes will be out-of-sync or will be > overwritten by Ambari upon service restart. > > Having HAWQ CLI tools communicate back to Ambari is not desirable because: > - knowledge of Ambari REST APIs needs to be built into the tools > - Ambari APIs change outside of service release lifecycle > - complexity in error handling (what do you do if Ambari call failed ?) > - introduction of feedback loop and potential infinite cycle (Ambari calls > the tool, the tool calls Ambari back, etc) > > If customers want to do some extra automation they can decide how to tie > tools and Ambari, if they like, but I will say we should not have HAWQ CLI > tools call Ambari. > > -- > Thanks, > Alex Denissov > > On Thu, Mar 2, 2017 at 4:44 PM, Alex (Oleksandr) Diachenko < > odiachenko@pivotal.io> wrote: > > > Sure, > > > > Users can automate configuration changes via Ambari API, which provides > > unified access > > to all services in a cluster. It's very likely they need to configure > HAWQ, > > HDFS and YARN > > when working with configuration changes, so with Ambari API it would be > > easier to call one API > > rather than using all different CLI's. > > > > Regards, Alex. > > > > On Thu, Mar 2, 2017 at 4:39 PM, Lei Chang wrote: > > > > > I think there are some use cases we need What Jon proposed. > > > > > > For example, users installed hawq via Ambari, but they want to automate > > the > > > configuration changes, it would be convenient to have hawq CLI change > the > > > configurations. > > > > > > Cheers > > > Lei > > > > > > > > > > > > > > > > > > > > > > > > On Fri, Mar 3, 2017 at 8:36 AM, Alex (Oleksandr) Diachenko < > > > odiachenko@pivotal.io> wrote: > > > > > > > I see, that makes sense. > > > > But is there any action users cannot do via Ambari? > > > > > > > > Ranger is also a good example, there we are making assumption, > > > > users either use Ranger or HAWQ's authorization engine. > > > > > > > > The same logic might be extrapolated to HAWQ/Ambari - users might use > > > > either Ambari or HAWQ CLI, but not both at the same time. > > > > In that way, we can keep things simple. > > > > > > > > Regards, Alex. > > > > > > > > > > > > > > > > On Thu, Mar 2, 2017 at 4:28 PM, Jon Roberts > > wrote: > > > > > > > > > Right. Just like HAWQ will be operational without Ranger. > > > > > > > > > > We have the hawq CLI and will obviously continue to have it. Some > > > people > > > > > use Ambari while others don't. So just like with Ranger support, > > > > integrate > > > > > when possible but don't require it. > > > > > > > > > > > > > > > Jon > > > > > > > > > > On Thu, Mar 2, 2017 at 6:26 PM, Alex (Oleksandr) Diachenko < > > > > > odiachenko@pivotal.io> wrote: > > > > > > > > > > > Not really, because HAWQ should be operational even without > > Ambari(if > > > > > > that's the case). > > > > > > > > > > > > On Thu, Mar 2, 2017 at 4:21 PM, Jon Roberts > > > > > wrote: > > > > > > > > > > > > > If that is the case, should we remove the "hawq" CLI? > > > > > > > > > > > > > > Jon > > > > > > > > > > > > > > On Thu, Mar 2, 2017 at 6:12 PM, Alex (Oleksandr) Diachenko < > > > > > > > odiachenko@pivotal.io> wrote: > > > > > > > > > > > > > > > Hi Jon, > > > > > > > > > > > > > > > > I think it was designed that Ambari is supposed to be only > one > > > > source > > > > > > of > > > > > > > > true. > > > > > > > > The whole purpose of integration id to provide a > user-friendly > > > > > > interface > > > > > > > > and avoid manually editing/distributing config files > > > > > > > > or running CLI commands. > > > > > > > > The idea of coupling HAWQ master with Ambari doesn't seem to > be > > > > > clean. > > > > > > > > > > > > > > > > Regards, Alex. > > > > > > > > > > > > > > > > On Thu, Mar 2, 2017 at 4:05 PM, Jon Roberts < > > jroberts@pivotal.io > > > > > > > > > > wrote: > > > > > > > > > > > > > > > > > It would be handy if the "hawq config" also updated > Ambari's > > > > > database > > > > > > > so > > > > > > > > > that changes could be made in either place are retained > when > > > > > changes > > > > > > > are > > > > > > > > > made in either place. > > > > > > > > > > > > > > > > > > Register Ambari: > > > > > > > > > hawq ambari -u admin -w admin -h myhost -p 8080 > > > > > > > > > > > > > > > > > > "hawq config" could then raise INFO/WARN messages about > > > updating > > > > > > > Ambari. > > > > > > > > > > > > > > > > > > Example: > > > > > > > > > hawq config -c hawq_rm_stmt_vseg_memory -v 16gb > > > > > > > > > INFO: Updated Ambari with hawq_rm_stmt_vseg_memory=16gb > > > > > > > > > or > > > > > > > > > hawq config -c hawq_rm_stmt_vseg_memory -v 16gb > > > > > > > > > WARN: Failed to update Ambari with > > > hawq_rm_stmt_vseg_memory=16gb. > > > > > > > Please > > > > > > > > > update Ambari credentials manually to retain this > > configuration > > > > > > change > > > > > > > > > after a restart. > > > > > > > > > > > > > > > > > > The implementation would require interacting with the > Ambari > > > APIs > > > > > and > > > > > > > > also > > > > > > > > > storing the credentials in an encrypted file on the HAWQ > > > Master. > > > > > > > > > > > > > > > > > > Thoughts? > > > > > > > > > > > > > > > > > > > > > > > > > > > Jon Roberts > > > > > > > > > Principal Engineer | jroberts@pivotal.io | 615-426-8661 > <(615)%20426-8661> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --001a1146f47e2ed4680549c97331--