Return-Path: X-Original-To: apmail-hadoop-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-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 BF8B39844 for ; Mon, 24 Sep 2012 10:23:59 +0000 (UTC) Received: (qmail 26626 invoked by uid 500); 24 Sep 2012 10:23:55 -0000 Delivered-To: apmail-hadoop-user-archive@hadoop.apache.org Received: (qmail 26311 invoked by uid 500); 24 Sep 2012 10:23:49 -0000 Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hadoop.apache.org Delivered-To: mailing list user@hadoop.apache.org Received: (qmail 26291 invoked by uid 99); 24 Sep 2012 10:23:48 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 24 Sep 2012 10:23:48 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of toxiufeng@gmail.com designates 74.125.82.176 as permitted sender) Received: from [74.125.82.176] (HELO mail-we0-f176.google.com) (74.125.82.176) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 24 Sep 2012 10:23:40 +0000 Received: by weyz53 with SMTP id z53so2750688wey.35 for ; Mon, 24 Sep 2012 03:23:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:sender:in-reply-to:references:from:date :x-google-sender-auth:message-id:subject:to:content-type; bh=WMokxA5lGBeY6MHJGh9JTIQGvs+pkP7qoTTsNEhIZCk=; b=REmwcnIJdGUJzCdq0RsHfLUFSnsz/pgINQQv6NknoxW7F2Q0pBCAKY6g3TtzrVZpYd GnCs0vSEIntYm+b1gIxIT4BUHZIXKxuHVlN5kYaFfRhGyIF0ZJPqa5HvALBkrNVVeAqS lZiOp+mwBZWfjyqm1iok4bWhrkPBAdlI1xV0t0ir48N1CQfZeUd1PZTJckKW+0Ynld4H qnmqW5ao/OIeSvmRRGPxnBLINurxhaaDZx/9o/5f0DjAWWYD2lTysFPv750gMiQkkNIJ NtnRhpvlJyPgtsgTaPIxH5EubjaMojSCftfIcUa58SvHNbQIg7G3CeSHqPgxOY3Uo3+H KStA== Received: by 10.180.78.40 with SMTP id y8mr13396983wiw.7.1348482200690; Mon, 24 Sep 2012 03:23:20 -0700 (PDT) MIME-Version: 1.0 Sender: toxiufeng@gmail.com Received: by 10.194.17.39 with HTTP; Mon, 24 Sep 2012 03:22:40 -0700 (PDT) In-Reply-To: References: From: afancy Date: Mon, 24 Sep 2012 12:22:40 +0200 X-Google-Sender-Auth: jtHy3eNGK2eX7Mid2kqcRuXfHbs Message-ID: Subject: What does ROW__OFFSET__INSIDE__BLOCK FROM mean? To: user@hadoop.apache.org Content-Type: multipart/alternative; boundary=f46d043c80b48edebc04ca6ffaa6 --f46d043c80b48edebc04ca6ffaa6 Content-Type: text/plain; charset=ISO-8859-1 Hi, Could anybody explain me what ROW__OFFSET__INSIDE__BLOCK means? For example, I make the following query, and return two rows. But why does the column of ROW__OFFSET__INSIDE__BLOCK show 0? For my understanding from the name of column, it should return the line number of the records in the block files, but now both are 0. It is quite confusing. hive> SELECT `url`, INPUT__FILE__NAME,BLOCK__OFFSET__INSIDE__FILE, ROW__OFFSET__INSIDE__BLOCK FROM `testresult` WHERE url=' http://www.domain022.tl04/page035.html'; http://www.domain022.tl04/page035.html hdfs://xiliu-fedora:54310/user/hive/warehouse/testresult/testresults.csv 0 0 http://www.domain022.tl04/page035.html hdfs://xiliu-fedora:54310/user/hive/warehouse/testresult/testresults.csv 3200250 0 Time taken: 19.653 seconds hive> Regards, afancy --f46d043c80b48edebc04ca6ffaa6 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Hi,=A0

Could anybo= dy explain me what=A0ROW__OFFSET__INSIDE__BLOCK means?
For example, I mak= e the following query, and return two rows. But why does the column of=A0ROW__OFFSET__INSI= DE__BLOCK show 0?=A0
For my und= erstanding from the name of column, it should return the line number of the= records in the block files, but now both are 0. =A0It is quite confusing.<= /span>


hive>= SELECT =A0`url`, =A0INPUT__FILE__NAME,BLOCK__OFFSET__INSIDE__FILE, ROW__OF= FSET__INSIDE__BLOCK FROM `testresult` WHERE url=3D'http://www.domain022.tl04/= page035.html'; =A0 =A0 =A0
http://www.domai= n022.tl04/page035.html hdfs://xiliu-fedora:54310/user/hive/warehou= se/testresult/testresults.csv 0 0
http://www.domain022.tl04/page035.html= hdfs://xiliu-fedora:54310/= user/hive/warehouse/testresult/testresults.csv 3200250 0
Time taken: 19.653 seconds
hive>=A0
<= /div>


Regards,
afancy

--f46d043c80b48edebc04ca6ffaa6--