Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-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 612D0179EB for ; Tue, 16 Feb 2016 07:01:54 +0000 (UTC) Received: (qmail 67340 invoked by uid 500); 16 Feb 2016 07:01:53 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 67264 invoked by uid 500); 16 Feb 2016 07:01:52 -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 67254 invoked by uid 99); 16 Feb 2016 07:01:52 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Feb 2016 07:01:52 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 79C231804DA for ; Tue, 16 Feb 2016 07:01:52 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.429 X-Spam-Level: * X-Spam-Status: No, score=1.429 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, 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: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id JfBdXmwIgf78 for ; Tue, 16 Feb 2016 07:01:51 +0000 (UTC) Received: from mail-yk0-f170.google.com (mail-yk0-f170.google.com [209.85.160.170]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 4DA735FAD9 for ; Tue, 16 Feb 2016 07:01:51 +0000 (UTC) Received: by mail-yk0-f170.google.com with SMTP id z13so69431210ykd.0 for ; Mon, 15 Feb 2016 23:01:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=jW0tcZDLcIcpYMqRwwKmfWN9w2J5HjzolDhGRiguV/s=; b=e4wNIGKr22L15wzov5tOtFJpPcJo6dbuW5qNX80BfSgZibIAN0zBuXXrlrxRYytAG4 XCT6mvfnbRfL6hyx0tLDhE+l07F4ZftKTYpTWvPHFZp8NeRQlhkY+OySwH9f1FSzGWPi KpFgxk8196XaV/XnbMVk4fhY5MKymxVGqSSEIfvgRKFpVbIDUQK9W0prgv03i1d/Fxv+ 8yob/FIBDBy8wQmYqBO4HSS4aLvl2UuSvoNDuj0IjUSAG2z3yjtvjzhpqS4O5xkz3gt/ yGldS+IE6wYjrQzZ/mqZB9wpop2eX02/BTFOWJ+kXp2wuEfjZ2hou93JnY6hQJdtm/mL hpHw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=jW0tcZDLcIcpYMqRwwKmfWN9w2J5HjzolDhGRiguV/s=; b=jLDehHIfet5GY9x01ev0D9W9gZbO+386ReMR4AdZ4ev2iEfc5TouhzwJ7FrYVfjM+E jKMdMFz1BcJhBj7iB85FhW++S5nv/ALjftv+glAQ7nicOa8JNAGaGbfpCxN5bbRneshO ERbrBxILEk/+PpmpCKgRooGfUSPWzOUyxng1zSBX+wO1OHS0pw7+5KgIcd5nfhTmDOrI eAyR4M/wAoBxaCy3rzoTffhMu5cIs9/NvHvP7wxWuXNSFc4evFiGtb2oz4tZ0e+0sbCB Erf/3hDzV6QqZ4pQtYdUyHvzG8zyhH/vAPwGRlloVZHQXH5i8s2g41NI3q5FSFfxTQhC OznA== X-Gm-Message-State: AG10YOSyCRu82CVb/r1WrOpvHyVKrM/gahHCr1SfIbjk+eTEwYv1zi05Z0aqQ/B2nLmeMIu2AtLU3Fo7nMPXHQ== MIME-Version: 1.0 X-Received: by 10.37.25.212 with SMTP id 203mr11284507ybz.163.1455606110802; Mon, 15 Feb 2016 23:01:50 -0800 (PST) Received: by 10.37.97.151 with HTTP; Mon, 15 Feb 2016 23:01:50 -0800 (PST) In-Reply-To: <09A1BDA8-EAB5-4991-AE43-A755EA7AFFD5@gmail.com> References: <3038E6F0-C311-459F-90A3-2B101A75EA2C@gmail.com> <09A1BDA8-EAB5-4991-AE43-A755EA7AFFD5@gmail.com> Date: Tue, 16 Feb 2016 15:01:50 +0800 Message-ID: Subject: Re: Is it ok to build an entire ETL/ELT data flow using HIVE queries? From: Heng Chen To: user@hive.apache.org Content-Type: multipart/alternative; boundary=001a113dc0c22adcba052bddb53a --001a113dc0c22adcba052bddb53a Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable My company do ETL data flow using HIVE + Pig, it is OK now. 2016-02-16 14:55 GMT+08:00 J=C3=B6rn Franke : > Why should it not be ok if you do not miss any functionality? You can use > oozie + hive queries to have more sophisticated logging and scheduling. D= o > not forget to do proper capacity/queue management. > > > On 16 Feb 2016, at 07:19, Ramasubramanian < > ramasubramanian.narayanan@gmail.com> wrote: > > > > Hi, > > > > Is it ok to build an entire ETL/ELT data flow using HIVE queries? > > > > Data is stored in HIVE. We have transactional and reference data. We > need to build a small warehouse. > > > > Need suggestion on alternatives too. > > > > Regards, > > Rams > --001a113dc0c22adcba052bddb53a Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
My company do ETL data flow using HIVE + Pig, =C2=A0 it is= OK now.



=
2016-02-16 14:55 GMT+08:00 J=C3=B6rn Franke <jornfranke@gmail.com>:
Why= should it not be ok if you do not miss any functionality? You can use oozi= e + hive queries to have more sophisticated logging and scheduling. Do not = forget to do proper capacity/queue management.

> On 16 Feb 2016, at 07:19, Ramasubramanian <ramasubramanian.narayanan@gmail.com> = wrote:
>
> Hi,
>
> Is it ok to build an entire ETL/ELT data flow using HIVE queries?
>
> Data is stored in HIVE. We have transactional and reference data. We n= eed to build a small warehouse.
>
> Need suggestion on alternatives too.
>
> Regards,
> Rams

--001a113dc0c22adcba052bddb53a--