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 <sze...@cloudera.com> 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 <para.vi...@gmail.com> > 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.agar...@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 <para.vi...@gmail.com> >>> wrote: >>> >>>> you can use shift+page up/down. >>>> >>>> On Sat, Nov 1, 2014 at 9:45 AM, Hanish Bansal < >>>> hanish.bansal.agar...@gmail.com> wrote: >>>> >>>>> Yeah beeline cli. >>>>> >>>>> On Sat, Nov 1, 2014 at 12:37 AM, Vikas Parashar <para.vi...@gmail.com> >>>>> wrote: >>>>> >>>>>> Are you using CLI ? >>>>>> >>>>>> On Sat, Nov 1, 2014 at 12:33 AM, Hanish Bansal < >>>>>> hanish.bansal.agar...@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*
