Return-Path: X-Original-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-mapreduce-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 B65C617701 for ; Fri, 1 May 2015 05:06:05 +0000 (UTC) Received: (qmail 77431 invoked by uid 500); 1 May 2015 05:05:59 -0000 Delivered-To: apmail-hadoop-mapreduce-user-archive@hadoop.apache.org Received: (qmail 77305 invoked by uid 500); 1 May 2015 05:05:59 -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 77295 invoked by uid 99); 1 May 2015 05:05:59 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 May 2015 05:05:59 +0000 X-ASF-Spam-Status: No, hits=2.4 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: message received from 54.76.25.247 which is an MX secondary for user@hadoop.apache.org) Received: from [54.76.25.247] (HELO mx1-eu-west.apache.org) (54.76.25.247) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 May 2015 05:05:30 +0000 Received: from mail-ig0-f169.google.com (mail-ig0-f169.google.com [209.85.213.169]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id EEB4B2D194 for ; Fri, 1 May 2015 05:03:36 +0000 (UTC) Received: by igblo3 with SMTP id lo3so31370019igb.0 for ; Thu, 30 Apr 2015 22:02:45 -0700 (PDT) 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=Gtzzibeg3yPuV/lz3RZ9BQHBDf406rERmNfISaD1OqY=; b=LaxLoL3s+dtMu4NlTee/aPdM1AAN2xFKgKxV0+8knkclZuQl3ZMOFjtM6eiuIy/59J /m6+yydN3aIFJ1uruEEUj286ba4pbt7R8DyTGy9YW9jIilZPFNBgR5fsuNXnwb/TH4aO E6utsjvm68d2L7worEqB3aalqPQtw8E19DS5mRlJ+xsSCcReM5f4wn5GSSCz3g6uiqtS M0yz3qAFHVw0nObGc9/Qrsb7Vf6mNonUUfyjf1P9lFc0n1eucdjTOj7Mh3oO4a0MSiga R7DEm0qUpnYpdjoHPz8gHHSKcmzl+jg895Epw9lWjK2oJrKKpymeZr+N7v5rV69RlFI0 +78Q== MIME-Version: 1.0 X-Received: by 10.107.165.206 with SMTP id o197mr10109908ioe.56.1430456565371; Thu, 30 Apr 2015 22:02:45 -0700 (PDT) Received: by 10.64.86.227 with HTTP; Thu, 30 Apr 2015 22:02:45 -0700 (PDT) In-Reply-To: References: Date: Fri, 1 May 2015 10:32:45 +0530 Message-ID: Subject: Re: parque table From: Nitin Pawar To: user@hadoop.apache.org Content-Type: multipart/alternative; boundary=001a11415074721c3e0514fe1f1d X-Virus-Checked: Checked by ClamAV on apache.org --001a11415074721c3e0514fe1f1d Content-Type: text/plain; charset=UTF-8 You loaded a gz file in a table stored as text file either define compression format or uncompress the file and load it On Fri, May 1, 2015 at 9:17 AM, Kumar Jayapal wrote: > Created table CREATE TABLE raw (line STRING) PARTITIONED BY (FISCAL_YEAR > smallint, FISCAL_PERIOD smallint) > STORED AS TEXTFILE; > > and loaded it with data. > > LOAD DATA LOCAL INPATH '/tmp/weblogs/20090603-access.log.gz' INTO TABLE > raw; > > I have to load it to parque table > > when I say select * from raw it shows all null values. > > > NULLNULLNULLNULLNULLNULLNULLNULL > NULLNULLNULLNULLNULLNULLNULLNULL > NULLNULLNULLNULLNULLNULLNULLNULL > NULLNULLNULLNULLNULLNULLNULLNULL > Why is not show showing the actual data in file. will it show once I load > it to parque table? > > Please let me know if I am doing anything wrong. > > > Thanks > jay > > -- Nitin Pawar --001a11415074721c3e0514fe1f1d Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
You loaded a gz file in a table stored as text file
ei= ther define compression format or uncompress the file and load it=C2=A0

On Fri, M= ay 1, 2015 at 9:17 AM, Kumar Jayapal <kjayapal17@gmail.com> wrote:
Created t= able =C2=A0CREATE TABLE raw (line STRING)=C2= =A0PARTITIONED BY (FISCAL_YEAR =C2=A0smallint, FIS= CAL_PERIOD smallint)
STORED AS= =C2=A0TEXTFILE;

and loaded it with d= ata.

LOAD DATA LOCAL INPATH=C2=A0= '/tmp/weblogs/20090603-access.log.gz'= =C2=A0INTO TABLE r= aw;

I have to load it to parque table
<= br>
when I say select * from raw it shows= all null values.

<= code style=3D"line-height:20px;font-size:14px;white-space:nowrap;font-famil= y:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier= ,monospace!important;border-radius:0px!important;border:0px!important;float= :none!important;margin:0px!important;outline:0px!important;overflow:visible= !important;padding:0px!important;vertical-align:baseline!important;width:au= to!important;min-height:inherit!important;color:black!important;background:= none!important">=

NULLNULLNULLNULLNULLNULLNULLNULL

NUL= LNULLNULLNULLNULLNULLNULLNULL

NULLNULLNULLNULLNULLNULLNULLNULL

NULLNULLNULLNULLNULLNULLNULLNUL= L
Why is not= show showing the actual data in file. will it show once I load it to parqu= e table?

=
Please let me know if I am doing anything wrong.


Thanks
jay=C2=A0




--
Nitin Pawar
--001a11415074721c3e0514fe1f1d--