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 547D3921B for ; Thu, 2 Aug 2012 20:00:23 +0000 (UTC) Received: (qmail 19039 invoked by uid 500); 2 Aug 2012 20:00:22 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 18939 invoked by uid 500); 2 Aug 2012 20:00:22 -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 18931 invoked by uid 99); 2 Aug 2012 20:00:21 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Aug 2012 20:00:21 +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 comptechgeeky@gmail.com designates 209.85.212.48 as permitted sender) Received: from [209.85.212.48] (HELO mail-vb0-f48.google.com) (209.85.212.48) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Aug 2012 20:00:15 +0000 Received: by vbjk17 with SMTP id k17so10404663vbj.35 for ; Thu, 02 Aug 2012 12:59:54 -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=nqZ/LvyeEXF4McJNFxBcs+ikbklZQvozSHRUDXLVCEA=; b=ikyD4Z+d0V0PeP3QM04e2vcHK0l8kSe3rrr6KtUZa2jcJZctzyFtPLkSLkb75/tydx r9gbQ0YoqS0wY2zEdVxxU7D6MCS6leGzald4KKHlpXyUc0AyG+Zqyl7KohZkyiJOB4sd zvuPyY1pBU0wRkzzgRmDVJwyLgUYiYiCKQ1FuFBz4FOY0MRPo6j9APj+HyYxGmauNhQF jcDS1B4gzEd3RlExlx7YQa7lFVv8IxxsVZY2eahw33vFE50ZYCOQCA5Xzd/IrNx0c1No v2SHXhi/7gkBsIhUBngSvBt6zJXxEai/eRlK6KBI7NR3gKw+Uoxhm36R6CdKpiUuAII1 MJGA== MIME-Version: 1.0 Received: by 10.58.169.16 with SMTP id aa16mr10370083vec.33.1343937594635; Thu, 02 Aug 2012 12:59:54 -0700 (PDT) Received: by 10.58.181.164 with HTTP; Thu, 2 Aug 2012 12:59:54 -0700 (PDT) In-Reply-To: References:

Date: Thu, 2 Aug 2012 12:59:54 -0700 Message-ID: Subject: Re: schema of hive database From: Techy Teck To: user@hive.apache.org Content-Type: multipart/alternative; boundary=047d7b6d7becedb6ab04c64ddac5 --047d7b6d7becedb6ab04c64ddac5 Content-Type: text/plain; charset=ISO-8859-1 And I got this error too- FAILED: Parse Error: line 1:19 mismatched input 'table1' expecting EOF On Thu, Aug 2, 2012 at 12:44 PM, Techy Teck wrote: > What format you used? I tried like this and it doesn't works for me- > > *describe formatted table1* > > I am running Hive 0.6. Anything else I need to do before running this > query? > > > > > On Thu, Aug 2, 2012 at 12:13 PM, Igor Tatarinov wrote: > >> Try >> describe formatted >> >> igor >> decide.com >> >> On Thu, Aug 2, 2012 at 12:04 PM, Anson Abraham wrote: >> >>> is there a way to derive information (schema) off a hive table? >>> >>> doing a describe only shows the clolumn w/ types. >>> >>> But i want to know if a table is like this: >>> >>> ROW FORMAT DELIMITED >>> >>> FIELDS TERMINATED BY '\t' >>> >>> COLLECTION ITEMS TERMINATED BY '\002' >>> >>> MAP KEYS TERMINATED BY '\003' >>> >>> STORED AS INPUTFORMAT 'com.hadoop.mapred.DeprecatedLzoTextInputFormat' >>> OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'; >>> >>> >>> >>> Or like this: >>> >>> ROW FORMAT DELIMITED >>> >>> FIELDS TERMINATED BY '\t' >>> >>> STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' >>> OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'; >>> >>> >>> where can i find that info? >>> >>> >>> Thanks in advance. >>> >>> >> > --047d7b6d7becedb6ab04c64ddac5 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

And I got this error too-

FAILED: Parse Error: line 1:19 mismatche= d input 'table1' expecting EOF

On Thu, Aug 2, 2012 at 12:44 PM, Techy Teck <comptechgeeky@gmail.com> wrote:

What format you used? I tried like this and = it doesn't works for me-

describe formatted table= 1

I am running Hive 0.6. Anything else I need to do befor= e running this query?

On Th= u, Aug 2, 2012 at 12:13 PM, Igor Tatarinov <igor@decide.com> w= rote:

Try=
describe formatted <table>

igor

decide.com

On Thu, Aug 2, 2012 at 12:04 PM, Anson Abraham <anson.abraham@gma= il.com> wrote:

is there a way to derive information (schema= ) off a hive table?

doing a describe only shows the clol= umn w/ types.

But i want to know if a table is like this:
<= br>

ROW FORMAT =A0 DELIMITED

=A0 =A0 FIELDS TERMINATED BY '\t'

=A0 =A0 COLLECTION ITEMS TERMINATED BY '\002'

=A0 =A0 MAP KEYS TERMINATED BY '\003'=A0

=A0 STORED AS INPUTFORMAT 'com.hadoop.mapred.DeprecatedLzoTextInputF= ormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyText= OutputFormat';

Or like this:

ROW FORMAT =A0 DELIMITED

=A0 =A0 FIELDS TERMINATED BY '\t'

=A0 STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat&= #39; OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutput= Format';

where can i find that info?

Thanks in advance.

--047d7b6d7becedb6ab04c64ddac5--