Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Phoenix sqlline cannot display all columns of table on terminal

Tags:

hbase

phoenix

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)

like image 535
Carl H Avatar asked Sep 08 '15 08:09

Carl H


2 Answers

You can change the output format from horizontal to vertical

!outputformat vertical
like image 178
userxxx Avatar answered Oct 02 '22 13:10

userxxx


Try setting the terminal width before starting sqlline

stty cols 200
like image 33
kliew Avatar answered Oct 02 '22 13:10

kliew