Return-Path: 
 <user-return-4213-apmail-hadoop-hdfs-user-archive=hadoop.apache.org@hadoop.apache.org>
X-Original-To: apmail-hadoop-hdfs-user-archive@minotaur.apache.org
Delivered-To: apmail-hadoop-hdfs-user-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id D168AD479
	for <apmail-hadoop-hdfs-user-archive@minotaur.apache.org>;
 Tue, 15 Jan 2013 21:19:57 +0000 (UTC)
Received: (qmail 81268 invoked by uid 500); 15 Jan 2013 21:19:53 -0000
Delivered-To: apmail-hadoop-hdfs-user-archive@hadoop.apache.org
Received: (qmail 81140 invoked by uid 500); 15 Jan 2013 21:19:52 -0000
Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hadoop.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hadoop.apache.org>
List-Post: <mailto:user@hadoop.apache.org>
List-Id: <user.hadoop.apache.org>
Reply-To: user@hadoop.apache.org
Delivered-To: mailing list user@hadoop.apache.org
Received: (qmail 81133 invoked by uid 99); 15 Jan 2013 21:19:52 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Jan 2013 21:19:52 +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 (athena.apache.org: domain of monkey2code@gmail.com
 designates 209.85.212.42 as permitted sender)
Received: from [209.85.212.42] (HELO mail-vb0-f42.google.com) (209.85.212.42)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Jan 2013 21:19:46 +0000
Received: by mail-vb0-f42.google.com with SMTP id fa15so631164vbb.15
        for <user@hadoop.apache.org>; Tue, 15 Jan 2013 13:19:25 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:date:message-id:subject:from:to:content-type;
        bh=eH5XIQtW35NptyWxj0+iwAQAByK1F3hoioETyCtYL9E=;
        b=o9c0rRBuQYxfaeiukFb1uo0GE7CJSi5Ec4LK+Vk8+OYlI4shMM2YVxfroP9UTGdTeV
         B9yI6hfjJbOMbmHENquhLXvzcfv01HDxcLbVQeXol04skM20fpRZlwBHST8r/kBCJlO/
         4Y97lWXYAVaGhKlSavjhPBHC6OV+ssQUZMZP95FDZHUeL208qmdnXOwogg1cVIUpPL7+
         GfiGr7BT9ii2dIGxpCbKdkZdlnVMj7MFcUDGq8AEe+hivPVU0EOYBOvL6m/RlNQGkyiC
         4zJtPsmrQGAT0l1Bo6i0i1WSITSACcJUe9wCVfbNeqKcgN5gtZM34o7sRi0OOliRcxAK
         ZPQA==
MIME-Version: 1.0
Received: by 10.52.175.163 with SMTP id cb3mr92878336vdc.76.1358284765327;
 Tue, 15 Jan 2013 13:19:25 -0800 (PST)
Received: by 10.58.40.6 with HTTP; Tue, 15 Jan 2013 13:19:25 -0800 (PST)
Date: Tue, 15 Jan 2013 16:19:25 -0500
Message-ID: 
 <CAEtYGOLj=uzjZFMys1Sp7=4DAk_4e_eTVdSbEnOcaH5QvN-Big@mail.gmail.com>
Subject: (hive) Table loading with NULL values
From: Monkey2Code <monkey2code@gmail.com>
To: user@hadoop.apache.org
Content-Type: multipart/alternative; boundary=bcaec517a9c2f0f17004d35a50a0
X-Virus-Checked: Checked by ClamAV on apache.org

--bcaec517a9c2f0f17004d35a50a0
Content-Type: text/plain; charset=ISO-8859-1

Hi ,
I have created a table a below
--use case 2 to test basics
DROP TABLE USER_DATA4;

CREATE  TABLE USER_dATA4
(
userid INT,
  movieid INT,
  rating INT,
  unixtime int
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;

--loading data into user_table

LOAD DATA LOCAL INPATH '/home/cloudera/ml-1m/ratings.dat'
OVERWRITE INTO TABLE USER_DATA4;

and trying to load below data

1::1193::5::978300760
1::661::3::978302109
1::914::3::978301968
1::3408::4::978300275
1::2355::5::978824291
1::1197::3::978302268
1::1287::5::978302039
================
this is probably due to delimiter specified., can someone tell how can I
overcome this  and load data with different delimiters


Thanks

--bcaec517a9c2f0f17004d35a50a0
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div><div><div>Hi ,<br></div>I have created a table a=
 below <br>--use case 2 to test basics <br>DROP TABLE USER_DATA4;<br><br>CR=
EATE=A0 TABLE USER_dATA4<br>(<br>userid INT,<br>=A0 movieid INT,<br>=A0 rat=
ing INT,<br>

=A0 unixtime int<br>)<br>ROW FORMAT DELIMITED <br>FIELDS TERMINATED BY &#39=
;\t&#39;<br>STORED AS TEXTFILE;<br><br>--loading data into user_table<br><b=
r>LOAD DATA LOCAL INPATH &#39;/home/cloudera/ml-1m/ratings.dat&#39;<br>OVER=
WRITE INTO TABLE USER_DATA4;<br>

<br></div>and trying to load below data<br><br>1::1193::5::978300760<br>1::=
661::3::978302109<br>1::914::3::978301968<br>1::3408::4::978300275<br>1::23=
55::5::978824291<br>1::1197::3::978302268<br>1::1287::5::978302039<br>
</div>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<br></div><div>this i=
s probably due to delimiter specified., can someone tell how can I overcome=
 this=A0 and load data with different delimiters <br><br><br></div><div>Tha=
nks<br></div>
</div>

--bcaec517a9c2f0f17004d35a50a0--