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 18C61200B91 for ; Thu, 29 Sep 2016 19:22:25 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 179D9160AE8; Thu, 29 Sep 2016 17:22:25 +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 68EBC160AEE for ; Thu, 29 Sep 2016 19:22:23 +0200 (CEST) Received: (qmail 56795 invoked by uid 500); 29 Sep 2016 17:22:22 -0000 Mailing-List: contact commits-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 commits@hawq.incubator.apache.org Received: (qmail 56692 invoked by uid 99); 29 Sep 2016 17:22:22 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Sep 2016 17:22:22 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 2B09B1A0C4B for ; Thu, 29 Sep 2016 17:22:22 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -6.219 X-Spam-Level: X-Spam-Status: No, score=-6.219 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-2.999] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id M-8IBwnDldzM for ; Thu, 29 Sep 2016 17:22:20 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with SMTP id C1E805FE15 for ; Thu, 29 Sep 2016 17:22:17 +0000 (UTC) Received: (qmail 51455 invoked by uid 99); 29 Sep 2016 17:22:16 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Sep 2016 17:22:16 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 23B28EEE22; Thu, 29 Sep 2016 17:22:16 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit From: yozie@apache.org To: commits@hawq.incubator.apache.org Date: Thu, 29 Sep 2016 17:22:39 -0000 Message-Id: In-Reply-To: References: X-Mailer: ASF-Git Admin Mailer Subject: [25/50] [abbrv] incubator-hawq-docs git commit: clarify client load tools windows/rhel discussion archived-at: Thu, 29 Sep 2016 17:22:25 -0000 clarify client load tools windows/rhel discussion - install HAWQ to get RHEL tools - clarify windows loader download location Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/commit/1d78599e Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/1d78599e Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/1d78599e Branch: refs/heads/master Commit: 1d78599eafd1f68dc5245354e855364c2fec403f Parents: 1661c62 Author: Lisa Owen Authored: Mon Sep 19 14:43:33 2016 -0700 Committer: Lisa Owen Committed: Mon Sep 19 14:43:33 2016 -0700 ---------------------------------------------------------------------- datamgmt/load/client-loadtools.html.md.erb | 58 +++++++++++--------- .../cli/admin_utilities/gpfdist.html.md.erb | 2 +- 2 files changed, 34 insertions(+), 26 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/1d78599e/datamgmt/load/client-loadtools.html.md.erb ---------------------------------------------------------------------- diff --git a/datamgmt/load/client-loadtools.html.md.erb b/datamgmt/load/client-loadtools.html.md.erb index 6b8deff..7ad9ee2 100644 --- a/datamgmt/load/client-loadtools.html.md.erb +++ b/datamgmt/load/client-loadtools.html.md.erb @@ -6,26 +6,38 @@ HAWQ supports data loading from Red Hat Enterprise Linux 5, 6, and 7 and Windows This topic presents the instructions to install the HAWQ Load Tools on your client machine. It also includes the information necessary to configure HAWQ databases to accept remote client connections. ## RHEL Load Tools -### Running the RHEL Installer -1. Download the `greenplum-loaders-4.3.x.x-build-n-RHEL5.zip` installer package from [Pivotal Network](https://network.pivotal.io/products/pivotal-gpdb). Make note of the directory to which the file was downloaded. +The RHEL Load Tools are provided in the HAWQ installation package. + + +### Installing the RHEL Loader + +1. Download the `hdb-2.0.1.0-nnnnn.tar.gz` installer package from [Pivotal Network](https://network.pivotal.io/products/pivotal-hdb). Make note of the directory to which the file was downloaded. -2. Unzip the run the installer. `sudo` privileges are required if you plan to accept the default install location of `/usr/local/greenplum-loaders-4.3.x.x-build-n`. +2. Refer to the HAWQ command line install instructions to set up your HDB repository and install the HAWQ binary. - ``` shell - $ unzip greenplum-loaders-4.3.x.x-build-n-RHEL5-x86_64.zip - $ /bin/bash greenplum-loaders-4.3.x.x-build-n-RHEL5-x86_64.bin - ``` - - The installer will prompt you to accept the license agreement and to provide an installation path. Enter an absolute path if you choose not to accept the default install location. +### About the RHEL Loader Installation + +The files/directories of interest in a HAWQ RHEL Load Tools installation include: + +`bin/` — data loading command-line tools (`gpfdist` and `hawq load`) +`greenplum_path.sh0` — environment set up file + +### Configuring the RHEL Load Environment + +A `greenplum_path.sh` file is located in the HAWQ base install directory following installation. Source `greenplum_path.sh` before running the HAWQ RHEL Load Tools to set up your HAWQ environment: + +``` shell +$ . /usr/local/hawq/greenplum_path.sh +``` ## Windows Load Tools ### Installing Python 2.5 -The HAWQ Load Tools for Windows requires that the 32-bit version of Python 2.5 be installed on your machine. +The HAWQ Load Tools for Windows requires that the 32-bit version of Python 2.5 be installed on your system. -**Note**: The 64-bit version of Python is not compatible with the HAWQ Load Tools for Windows. +**Note**: The 64-bit version of Python is **not** compatible with the HAWQ Load Tools for Windows. 1. Download the [Python 2.5 installer for Windows](https://www.python.org/downloads/). Make note of the directory to which it was downloaded. @@ -38,7 +50,7 @@ The HAWQ Load Tools for Windows requires that the 32-bit version of Python 2.5 b ### Running the Windows Installer -1. Download the `greenplum-loaders-4.3.x.x-build-n-WinXP-x86_32.msi` installer package from [Pivotal Network](https://network.pivotal.io/products/pivotal-gpdb). Make note of the directory to which it was downloaded. +1. Download the `greenplum-loaders-4.3.x.x-build-n-WinXP-x86_32.msi` installer package from [Pivotal Network](https://network.pivotal.io/products/pivotal-hdb). Make note of the directory to which it was downloaded. 2. Double-click the `greenplum-loaders-4.3.x.x-build-n-WinXP-x86_32.msi` file to launch the installer. 3. Click **Next** on the **Welcome** screen. @@ -49,27 +61,23 @@ The HAWQ Load Tools for Windows requires that the 32-bit version of Python 2.5 b 8. Click **Finish** to exit the installer. -## About the Loader Installation -Your HAWQ Load Tools installation includes the following files and directories: - -`bin` — data loading command-line tools (`gpfdist` and `gpload`) -`ext` — external dependent components (python) -`lib` - data loading library files -`greenplum_loaders_path.[sh | bat]` — environment set up file - +### About the Windows Loader Installation +Your HAWQ Windows Load Tools installation includes the following files and directories: +`bin/` — data loading command-line tools (`gpfdist` and `gpload`) +`lib/` — data loading library files +`greenplum_loaders_path.bat` — environment set up file -## Configuring the Load Environment -?? NEED TO VERIFY RHEL/WIN HAVE SAME env varb NAMES ?? +### Configuring the Windows Load Environment -A `greenplum_loaders_path.[sh | bat]` file is provided in your load tools base install directory following installation. This file sets the following environment variables: +A `greenplum_loaders_path.bat` file is provided in your load tools base install directory following installation. This file sets the following environment variables: - `GPHOME_LOADERS` - base directory of loader installation - `PATH` - adds the loader and component program directories -- *`LIBRARY_PATH`* (OS-specific name) - adds the loader and component library directories +- `PYTHONPATH` - adds component library directories -Source `greenplum_loaders.sh` or execute `greenplum_loaders.bat` to set up your HAWQ environment before running the HAWQ Load Tools. +Execute `greenplum_loaders_path.bat` to set up your HAWQ environment before running the HAWQ Windows Load Tools. ## Enabling Remote Client Connections http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/1d78599e/reference/cli/admin_utilities/gpfdist.html.md.erb ---------------------------------------------------------------------- diff --git a/reference/cli/admin_utilities/gpfdist.html.md.erb b/reference/cli/admin_utilities/gpfdist.html.md.erb index b6f7a35..1683ddb 100644 --- a/reference/cli/admin_utilities/gpfdist.html.md.erb +++ b/reference/cli/admin_utilities/gpfdist.html.md.erb @@ -31,7 +31,7 @@ For readable external tables, if load files are compressed using `gzip` or `bzip **Note:** Currently, readable external tables do not support compression on Windows platforms, and writable external tables do not support compression on any platforms. -Most likely, you will want to run `gpfdist` on your ETL machines rather than the hosts where HAWQ is installed. To install `gpfdist` on another host, simply copy the utility over to that host and add `gpfdist` to your `$PATH`. +To run `gpfdist` on your ETL machines, refer to [Client-Based HAWQ Load Tools](../../../datamgmt/load/client-loadtools.html) for more information. **Note:** When using IPv6, always enclose the numeric IP address in brackets.