You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Hanish Bansal <ha...@gmail.com> on 2014/11/01 05:15:37 UTC
Re: Beeline client
Yeah beeline cli.
On Sat, Nov 1, 2014 at 12:37 AM, Vikas Parashar <pa...@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 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*
Re: Beeline client
Posted by Vikas Parashar <pa...@gmail.com>.
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 <sz...@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 <pa...@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.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 <pa...@gmail.com>
>>>> 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 <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 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*
>
Re: Beeline client
Posted by Hanish Bansal <ha...@gmail.com>.
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 <sz...@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 <pa...@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.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 <pa...@gmail.com>
>>> 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 <pa...@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 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*
Re: Beeline client
Posted by Szehon Ho <sz...@cloudera.com>.
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 <pa...@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.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 <pa...@gmail.com>
>> 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 <pa...@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 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*
>>
>
>
Re: Beeline client
Posted by Vikas Parashar <pa...@gmail.com>.
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 <pa...@gmail.com>
> 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 <pa...@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 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*
>
Re: Beeline client
Posted by Hanish Bansal <ha...@gmail.com>.
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 <pa...@gmail.com>
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 <pa...@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 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*
Re: Beeline client
Posted by Vikas Parashar <pa...@gmail.com>.
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 <pa...@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 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*
>