Phoenix sqlline cannot display all columns of table on terminal

Question

Use phoenix sqlline to connect the hbase. On SecureCRT terminal I can only see three columns of table which has more than 10 columns. I would like to display all columns of the table to test if data is ok. Is there any configuration should be set?

0: jdbc:phoenix:10.35.66.72:2181:/hbase> select * from WL.MSGCENTER_PUSHMESSAGE;
+--------------+---------+---------------------------------------------------------------------------------------------------------------------------------------------+
|    PLANID    | BATCHID |                                                                                                                                                 |
+--------------+---------+---------------------------------------------------------------------------------------------------------------------------------------------+
| 520          | 1       | C285995F-AB23-4CF0-A9A4-F29175E9CD36                                                                                                           |
+--------------+---------+---------------------------------------------------------------------------------------------------------------------------------------------+

1 row selected (0.805 seconds)

score 28 · Accepted Answer · answered May 21 '16 at 20:49

28

You can change the output format from horizontal to vertical

!outputformat vertical

answered May 21 '16 at 20:49

userxxx

726
9
18

1

Agreed, this is very useful and should be the accepted answer. It serializes the table, which is often what a JSON API would do. – Hendrik F Oct 24 '16 at 15:17

score 5 · Answer 2 · answered Feb 01 '16 at 07:29

5

Try setting the terminal width before starting sqlline

stty cols 200

answered Feb 01 '16 at 07:29

kliew

2,687
1
11
25

score 1 · Answer 3 · answered Sep 10 '15 at 06:40

Sqlline is not smart enough to adjust column width. Make the terminal wider and you might see the data.
Ideally, i would recommend you to use squirrel-sql or db-visualizer to connect to Phoenix. They are much better tool to query Phoenix.

Have a look at this: http://search-hadoop.com/m/9UY0h2sGBoSz1Mta1

Phoenix sqlline cannot display all columns of table on terminal

3 Answers3