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 2AFB01016B for ; Tue, 4 Nov 2014 12:54:28 +0000 (UTC) Received: (qmail 91894 invoked by uid 500); 4 Nov 2014 12:54:25 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 91823 invoked by uid 500); 4 Nov 2014 12:54:25 -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 91813 invoked by uid 99); 4 Nov 2014 12:54:25 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Nov 2014 12:54:25 +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 (nike.apache.org: domain of para.vikas@gmail.com designates 209.85.192.45 as permitted sender) Received: from [209.85.192.45] (HELO mail-qg0-f45.google.com) (209.85.192.45) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Nov 2014 12:53:59 +0000 Received: by mail-qg0-f45.google.com with SMTP id z107so10363269qgd.18 for ; Tue, 04 Nov 2014 04:52:28 -0800 (PST) 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=REUD0D5HK957Jo+KCXJIlSk8qbsAy0VmlKhtuSdR3ms=; b=uwSIL1CLBe3f7sdcP4u3T4vRsDPPt+QBFU73mDv+v/1NxRH9kvLHW8VnLwR8BAL+Kx C96IOt/YIaTb5B0aJdbWNTYWEIg3B13JeoENthCUzOgPtT3zi4TrQL99Yz1VumvhNucg JdbLbprT9JEDbOKBcctbqrZ4Ee9CCeCRB1qsmy83nAfkI8MSlhaRyBGx3do3v98JFR05 /F8soFdnQI2xQyDQg4+Q3iKyCuSJfyxR4nN9HamYRDLePym3NBMJuAvT3vp15+fNXzPe NrOLRo8dV6bxuJcWclcNBebmCIyDAlrxvciMvOBfmH9nAkxQxafn/OA2O16IdNCDG++2 Npaw== MIME-Version: 1.0 X-Received: by 10.224.55.70 with SMTP id t6mr59538787qag.83.1415105548138; Tue, 04 Nov 2014 04:52:28 -0800 (PST) Received: by 10.140.30.68 with HTTP; Tue, 4 Nov 2014 04:52:28 -0800 (PST) In-Reply-To: References: Date: Tue, 4 Nov 2014 18:22:28 +0530 Message-ID: Subject: Re: Beeline client From: Vikas Parashar To: user@hive.apache.org Content-Type: multipart/alternative; boundary=047d7bd7568a843e80050707efac X-Virus-Checked: Checked by ClamAV on apache.org --047d7bd7568a843e80050707efac Content-Type: text/plain; charset=UTF-8 Thanks szehon to correct me, sorry, i didn't get the question properly. On Tue, Nov 4, 2014 at 6:10 PM, Hanish Bansal < hanish.bansal.agarwal@gmail.com> wrote: > Thanks all for response !! > > Szehon, yup I was facing issue mentioned in HIVE-6928. By using > --outputFormat=vertical it is showing proper result but not user friendly. > > For now it is fine for me. I ll have to wait for hive release 0.14.0 to > get proper result in tabular form. > > Once again Thanks Szehon !! :) > > On Tue, Nov 4, 2014 at 12:54 AM, Szehon Ho wrote: > >> Late reply, but I saw a similar issue as described in HIVE-6928, which is >> fixed. Not sure if its the same issue. You can also try >> --outputFormat=vertical as a workaround. >> >> Thanks >> Szehon >> >> On Sat, Nov 1, 2014 at 12:03 AM, Vikas Parashar >> wrote: >> >>> No Cli, will give you that access. this is all depends on your terminal. >>> If you will see mysql client then it will behave like same. But in my >>> terminal, it will print in next line. >>> >>> On Sat, Nov 1, 2014 at 11:40 AM, Hanish Bansal < >>> hanish.bansal.agarwal@gmail.com> wrote: >>> >>>> This can be used to move upward/download on beeline cli. >>>> >>>> The issue is I am not able to move on right side (in horizontal >>>> direction) to view the other columns. >>>> E.g. There are 30 columns in hive table "test" but when i run "select * >>>> from test",it is showing only 6-7 columns on beeline cli depending on >>>> length of column names. >>>> >>>> Probably this is an issue in beeline cli. >>>> >>>> If anyone know please let me know how to move right side on beeline cli >>>> ?? >>>> >>>> >>>> On Sat, Nov 1, 2014 at 10:07 AM, Vikas Parashar >>>> wrote: >>>> >>>>> you can use shift+page up/down. >>>>> >>>>> On Sat, Nov 1, 2014 at 9:45 AM, Hanish Bansal < >>>>> hanish.bansal.agarwal@gmail.com> wrote: >>>>> >>>>>> Yeah beeline cli. >>>>>> >>>>>> On Sat, Nov 1, 2014 at 12:37 AM, Vikas Parashar >>>>> > wrote: >>>>>> >>>>>>> Are you using CLI ? >>>>>>> >>>>>>> On Sat, Nov 1, 2014 at 12:33 AM, Hanish Bansal < >>>>>>> hanish.bansal.agarwal@gmail.com> wrote: >>>>>>> >>>>>>>> Hi, >>>>>>>> >>>>>>>> I am using Beeline client to connect to hiveserver2 on linux >>>>>>>> machine. >>>>>>>> >>>>>>>> In terminal when i run query: "select * from table"; It only show >>>>>>>> first few columns in case there is large no.of columns in table. >>>>>>>> >>>>>>>> There should be horizontal scroll on beeline if there is larger >>>>>>>> result but there is not any scroll now. >>>>>>>> >>>>>>>> So How to view all columns on beeline client?? >>>>>>>> >>>>>>>> -- >>>>>>>> *Thanks & Regards* >>>>>>>> *Hanish Bansal* >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> *Thanks & Regards* >>>>>> *Hanish Bansal* >>>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> *Thanks & Regards* >>>> *Hanish Bansal* >>>> >>> >>> >> > > > -- > *Thanks & Regards* > *Hanish Bansal* > --047d7bd7568a843e80050707efac Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thanks szehon to correct me,

sorry, i d= idn't get the question properly.
=
On Tue, Nov 4, 2014 at 6:10 PM, Hanish Bansa= l <hanish.bansal.agarwal@gmail.com> wrote:
=
Thanks all for re= sponse !!

Szehon, yup I was facing issue mentioned in HIVE-692= 8. By using --outputFormat=3Dvertical it is showing proper result but not u= ser friendly.

For now it is fine for me. I ll have to wait for hive= release 0.14.0 to get proper result in tabular form.

Once aga= in Thanks Szehon !! :)

On Tue, Nov 4, 2014 at 12:54 AM, Szehon Ho <szehon@clou= dera.com> wrote:
Late reply, but I saw a similar issue as described in HIVE-6928, w= hich is fixed.=C2=A0 Not sure if its the same issue.=C2=A0 You can also try= --outputFormat=3Dvertical as a workaround.

Thanks
=
Szehon

On Sat, Nov 1, = 2014 at 12:03 AM, Vikas Parashar <para.vikas@gmail.com> w= rote:
No Cli, will give = you that access. this is all depends on your terminal. If you will see mysq= l client then it will behave like same. But in my terminal, it will print i= n next line.

On Sat, Nov 1, 2014 at 11:40 AM, Hanish Bansal <h= anish.bansal.agarwal@gmail.com> wrote:
This can be used to move upwa= rd/download on beeline cli.

The issue is I am not able to move= on right side (in horizontal direction) to view the other columns.
E.g. There are 30 columns in hive table "test" but when i run = "select * from test",it is showing only 6-7 columns on beeline cl= i depending on length of column names.

Probably this is an iss= ue in beeline cli.

If anyone know please let me know how to mov= e right side on beeline cli ??


On Sat, Nov 1, 2014 at 10:07 AM,= Vikas Parashar <para.vikas@gmail.com> wrote:
you can use shift+page up/down.

On Sa= t, Nov 1, 2014 at 9:45 AM, Hanish Bansal <hanish.bansal.agar= wal@gmail.com> wrote:
Yeah beeline cli.

On Sat, Nov 1, 2014 at 12:37 AM, Vikas Para= shar <para.vikas@gmail.com> wrote:
Are you using CLI ?

On Sat, Nov 1, 2014 at 12:= 33 AM, Hanish Bansal <hanish.bansal.agarwal@gmail.com>= ; wrote:
Hi,

I am using Beeline client to connect to hiveserver2= on linux machine.

In terminal when=C2=A0 i run query: "s= elect * from table"; It only show first few columns in case there is l= arge no.of columns in table.

There should be horizontal s= croll on beeline if there is larger result but there is not any scroll now.=

So How to view all columns on beeline client??

--
Thanks & Regard= s
Hanish Bansal




--
Thanks & Regard= s
Hanish Bansal




--
Thanks & Regards
Hanish Bansal


--
Thanks & Regards
Ha= nish Bansal
--047d7bd7568a843e80050707efac--