phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Heather <james.heat...@mendeley.com>
Subject Re: table descriptions gone awry
Date Thu, 03 Sep 2015 14:59:58 GMT
I'm doing it in a terminal window on Linux.

But you're absolutely right: it's being rather harshly silently 
truncated if the columns don't fit! That seems odd to me. But making the 
terminal window full screen means I can see it all.

Thanks!

James

On 03/09/15 15:52, Naor David wrote:
>
> Are you using sqlline via putty?
> If so, consider stretching it's window wider so the whole description 
> would fit in (and stretch it before running sqlline)
>
> Also, consider using SQuireL client for better view of your data...
>
> Regards,
> David
>
> בתאריך 3 בספט׳ 2015 16:21,‏ "James Heather" 
> <james.heather@mendeley.com <mailto:james.heather@mendeley.com>> כתב:
>
>     Eek. Any idea what's wrong here, or how to fix it?
>
>     Notice that the number of rows returned does increase when I add a
>     table, so I think the information is there, just not being
>     returned/displayed for some reason.
>
>     0: jdbc:phoenix:172.31.30.216> !describe performance_100000000
>     +------------------------------------------+----------------------------------+
>     |                TABLE_CAT                 |  TABLE_SCHEM        |
>     +------------------------------------------+----------------------------------+
>     |                                          |                 |
>     |                                          |                 |
>     |                                          |                 |
>     |                                          |                 |
>     |                                          |                 |
>     |                                          |                 |
>     |                                          |                 |
>     +------------------------------------------+----------------------------------+
>     0: jdbc:phoenix:172.31.30.216> !tables
>     +------------------------------------------+----------------------------------+
>     |                TABLE_CAT                 |  TABLE_SCHEM        |
>     +------------------------------------------+----------------------------------+
>     |                                          | SYSTEM                |
>     |                                          | SYSTEM                |
>     |                                          | SYSTEM                |
>     |                                          |                 |
>     |                                          |                 |
>     |                                          |                 |
>     |                                          |                 |
>     +------------------------------------------+----------------------------------+
>     0: jdbc:phoenix:172.31.30.216> create table test (id bigint(20)
>     primary key, data bigint(20));
>     No rows affected (0.864 seconds)
>     0: jdbc:phoenix:172.31.30.216> !tables
>     +------------------------------------------+----------------------------------+
>     |                TABLE_CAT                 |  TABLE_SCHEM        |
>     +------------------------------------------+----------------------------------+
>     |                                          | SYSTEM                |
>     |                                          | SYSTEM                |
>     |                                          | SYSTEM                |
>     |                                          |                 |
>     |                                          |                 |
>     |                                          |                 |
>     |                                          |                 |
>     |                                          |                 |
>     +------------------------------------------+----------------------------------+
>     0: jdbc:phoenix:172.31.30.216> !describe test
>     +------------------------------------------+----------------------------------+
>     |                TABLE_CAT                 |  TABLE_SCHEM        |
>     +------------------------------------------+----------------------------------+
>     |                                          |                 |
>     |                                          |                 |
>     +------------------------------------------+----------------------------------+
>     0: jdbc:phoenix:172.31.30.216>
>


Mime
View raw message