Mailing-List: contact hive-user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hive-user@hadoop.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=rocketmail.com;
  h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
  b=KhaTK8wyan2+HR4RX2HtS7kOemo572ActZjsYiN31ANOv5Jt4aolyiM9KFbGaniG+/5QAyMtwCScIeUcYJlgdjYy02YtC1Epm7ECDI3FWKFvGZAjr43chouLXyRAXlDcqoNxT1EGDJFdIrGOFw9PFJt6SgkvnUdWMMszklq5xdY=;
Message-ID: <156120.57842.qm@web30204.mail.mud.yahoo.com>
References: <c1012be40911030522t50f1336bw89abbd7ce61663c6@mail.gmail.com>
Date: Tue, 3 Nov 2009 08:54:58 -0800 (PST)
From: Eric Arenas <earenas@rocketmail.com>
Subject: Re: Problem regarding external table
To: hive-user@hadoop.apache.org
In-Reply-To: <c1012be40911030522t50f1336bw89abbd7ce61663c6@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1251031174-1257267298=:57842"

--0-1251031174-1257267298=:57842
Content-Type: text/plain; charset=us-ascii

Hi Mohan,

Can you please paste your create table statement?

Also, have you checked that the target directory has data files that you want to load?

regards,
 Eric Arenas


________________________________
From: Mohan Agarwal <mohan.agarwal25@gmail.com>
To: hive-user@hadoop.apache.org
Sent: Tue, November 3, 2009 5:22:38 AM
Subject: Problem regarding external table

Hi,
    I am using hive over hadoop-0.19.0 , I have created a external table pointing its loaction at certain specified directory, and I have  also copied the data file (macthing the table structure) using hadoop dfs -put command to that specified directory , but when I am printing the data of external table it is shows nothing. Even the count(1) on the external table is giving 0.
    Please help me solve this problem.

Thanking You
Mohan Agarwal
--0-1251031174-1257267298=:57842
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt">Hi Mohan,<br><br>Can you please paste your create table statement?<br><br>Also, have you checked that the target directory has data files that you want to load?<br><br>regards,<br>&nbsp;Eric Arenas<div><br></div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Mohan Agarwal &lt;mohan.agarwal25@gmail.com&gt;<br><b><span style="font-weight: bold;">To:</span></b> hive-user@hadoop.apache.org<br><b><span style="font-weight: bold;">Sent:</span></b> Tue, November 3, 2009 5:22:38 AM<br><b><span style="font-weight: bold;">Subject:</span></b> Problem regarding external table<br></font><br>
<meta http-equiv="x-dns-prefetch-control" content="off">Hi,<br>&nbsp;&nbsp;&nbsp; I am using hive over hadoop-0.19.0 , I have created a external table pointing its loaction at certain specified directory, and I have&nbsp; also copied the data file (macthing the table structure) using hadoop dfs -put command to that specified directory , but when I am printing the data of external table it is shows nothing. Even the count(1) on the external table is giving 0.<br>
&nbsp;&nbsp;&nbsp; Please help me solve this problem.<br><br>Thanking You<br>Mohan Agarwal<br>&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; <br>
<meta http-equiv="x-dns-prefetch-control" content="on"></div></div>
<!-- cg5.c1.mail.mud.yahoo.com compressed/chunked Tue Nov  3 08:48:26 PST 2009 -->
</div></body></html>
--0-1251031174-1257267298=:57842--