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"
<[email protected] <mailto:[email protected]>> כתב:
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>
