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 B23C7EA29 for ; Mon, 25 Feb 2013 15:35:01 +0000 (UTC) Received: (qmail 35394 invoked by uid 500); 25 Feb 2013 15:35:00 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 35186 invoked by uid 500); 25 Feb 2013 15:34:59 -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 35171 invoked by uid 99); 25 Feb 2013 15:34:59 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 25 Feb 2013 15:34:59 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of cyrilbogus@gmail.com designates 209.85.212.53 as permitted sender) Received: from [209.85.212.53] (HELO mail-vb0-f53.google.com) (209.85.212.53) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 25 Feb 2013 15:34:51 +0000 Received: by mail-vb0-f53.google.com with SMTP id fj18so1723278vbb.26 for ; Mon, 25 Feb 2013 07:34:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=oTP+WemT46464v27SHSTAsBP6qM/OnanBRHHTqjlcIM=; b=OoMdDdjQsoeq2mTkHJ/tOaJOeb0Ax+qpWMZcDwo3ayChs8O3eVy1g9YgYkQBr/praz xPQXoJz6lahm6pXkfXK2c1faDZSAtesQE68uEOTBAUsUZR8qFMKqzXiP3hhjdgJId7EX vNP2vdwFhZ+hyJaQTiDnL9vcr/9YfOjJdclkAsDvDKmhHcNLvLvJnGJQdA5pSZGIQ0mR wIz7L/mdcwRChXD/6bdsW4l2Sa+zAc/1dPP0I569SsnApGiUIgKP5phabp8NU/YXZgv1 uzMsZxBCqY5ECKmY64P1hCowUmZfs0Wts2kPEW+rLOFPvNUR44JxPsFU478DzjlDrb48 injw== MIME-Version: 1.0 X-Received: by 10.58.143.116 with SMTP id sd20mr10308070veb.39.1361806470002; Mon, 25 Feb 2013 07:34:30 -0800 (PST) Received: by 10.58.246.42 with HTTP; Mon, 25 Feb 2013 07:34:29 -0800 (PST) In-Reply-To: References: Date: Mon, 25 Feb 2013 10:34:29 -0500 Message-ID: Subject: Re: Hive queries From: Cyril Bogus To: user@hive.apache.org Content-Type: multipart/alternative; boundary=047d7b6dc6cee5b9c104d68e46cc X-Virus-Checked: Checked by ClamAV on apache.org --047d7b6dc6cee5b9c104d68e46cc Content-Type: text/plain; charset=ISO-8859-1 I do not get any errors. It is only when I run hive and try to query the tables I imported. Let's say I want to only get numeric tuples for a given table. I cannot find the table (show tables; is empty) unless I go in the hive home folder and run hive again. I would expect the state of hive to be the same everywhere I call it. But so far it is not the case. On Mon, Feb 25, 2013 at 10:22 AM, Nitin Pawar wrote: > any errors you see ? > > > On Mon, Feb 25, 2013 at 8:48 PM, Cyril Bogus wrote: > >> Hi everyone, >> >> My setup is Hadoop 1.0.4, Hive 0.9.0, Sqoop 1.4.2-hadoop 1.0.0 >> Mahout 0.7 >> >> I have imported tables from a remote database directly into Hive using >> Sqoop. >> >> Somehow when I try to run Sqoop from Hadoop, the content >> >> Hive is giving me trouble in bookkeeping of where the imported tables are >> located. I have a Single Node setup. >> >> Thank you for any answer and you can ask question if I was not specific >> enough about my issue. >> >> Cyril >> > > > > -- > Nitin Pawar > --047d7b6dc6cee5b9c104d68e46cc Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
I do not get any errors.
It is only when I run h= ive and try to query the tables I imported. Let's say I want to only ge= t numeric tuples for a given table. I cannot find the table (show tables; i= s empty) unless I go in the hive home folder and run hive again. I would ex= pect the state of hive to be the same everywhere I call it.
But so far it is not the case.


On Mon, Feb 25, 2013 at 10:22 AM, N= itin Pawar <nitinpawar432@gmail.com> wrote:
any errors you see ?=A0


On Mon, Feb 25, 2013 at 8:48 PM, Cyril Bogus <cyrilbogus@gmail.com= > wrote:
Hi everyone,

=
My setup is Hadoop 1.0.4, Hive 0.9.0, Sqoop 1.4.2-hadoop 1.0.0
Mahout 0.7

I have imported tables from a remote da= tabase directly into Hive using Sqoop.

Somehow when I try to run Sqoop from Hadoop, the conten= t

Hive is giving me trouble in bookkeeping of wher= e the imported tables are located. I have a Single Node setup.

Thank you for any answer and you can ask question if I = was not specific enough about my issue.
=

Cyril



--
Nitin Pawar

--047d7b6dc6cee5b9c104d68e46cc--