You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Lavrenty Eskin <la...@NetCracker.com> on 2015/03/11 13:17:11 UTC

!columns doesn't show DATA_TYPE, TYPE_NAME, COLUMN_SIZE

!columns
doesn't show DATA_TYPE, TYPE_NAME, COLUMN_SIZE

0: jdbc:phoenix:db268,db269,db270:2181:/hbase> !columns la1014.mh
+------------------------------------------+------------------------------------------+------------------------------------------+-------------------------------------+
|                TABLE_CAT                 |               TABLE_SCHEM                |                TABLE_NAME                |               COLUMN_NAME           |
+------------------------------------------+------------------------------------------+------------------------------------------+-------------------------------------+
| null                                     | LA1014                                   | MH                                       | METRICID                            |
| null                                     | LA1014                                   | MH                                       | REGDATE                             |
| null                                     | LA1014                                   | MH                                       | VAL                                 |
+------------------------------------------+------------------------------------------+------------------------------------------+-------------------------------------+



________________________________
The information transmitted herein is intended only for the person or entity to which it is addressed and may contain confidential, proprietary and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

RE: !columns doesn't show DATA_TYPE, TYPE_NAME, COLUMN_SIZE

Posted by Lavrenty Eskin <la...@NetCracker.com>.
That works, thank you so much.

From: Sergey Belousov [mailto:sergey.belousov@gmail.com]
Sent: Wednesday, March 11, 2015 3:41 PM
To: user@phoenix.apache.org
Subject: Re: !columns doesn't show DATA_TYPE, TYPE_NAME, COLUMN_SIZE

Does show to me.
It may be the case that it does not fit in the terminal window
try
!set incremental false
!columns la1014.mh<http://la1014.mh/>

On Wed, Mar 11, 2015 at 8:17 AM, Lavrenty Eskin <la...@netcracker.com>> wrote:
!columns
doesn't show DATA_TYPE, TYPE_NAME, COLUMN_SIZE

0: jdbc:phoenix:db268,db269,db270:2181:/hbase> !columns la1014.mh<http://la1014.mh>
+------------------------------------------+------------------------------------------+------------------------------------------+-------------------------------------+
|                TABLE_CAT                 |               TABLE_SCHEM                |                TABLE_NAME                |               COLUMN_NAME           |
+------------------------------------------+------------------------------------------+------------------------------------------+-------------------------------------+
| null                                     | LA1014                                   | MH                                       | METRICID                            |
| null                                     | LA1014                                   | MH                                       | REGDATE                             |
| null                                     | LA1014                                   | MH                                       | VAL                                 |
+------------------------------------------+------------------------------------------+------------------------------------------+-------------------------------------+



________________________________
The information transmitted herein is intended only for the person or entity to which it is addressed and may contain confidential, proprietary and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.




________________________________
The information transmitted herein is intended only for the person or entity to which it is addressed and may contain confidential, proprietary and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

Re: !columns doesn't show DATA_TYPE, TYPE_NAME, COLUMN_SIZE

Posted by Sergey Belousov <se...@gmail.com>.
Does show to me.
It may be the case that it does not fit in the terminal window
try
!set incremental false
!columns la1014.mh

On Wed, Mar 11, 2015 at 8:17 AM, Lavrenty Eskin <
lavrenty.eskin@netcracker.com> wrote:

>  !columns
>
> doesn't show DATA_TYPE, TYPE_NAME, COLUMN_SIZE
>
>
>
> 0: jdbc:phoenix:db268,db269,db270:2181:/hbase> !columns la1014.mh
>
>
> +------------------------------------------+------------------------------------------+------------------------------------------+-------------------------------------+
>
> |                TABLE_CAT                 |
> TABLE_SCHEM                |                TABLE_NAME
> |               COLUMN_NAME           |
>
>
> +------------------------------------------+------------------------------------------+------------------------------------------+-------------------------------------+
>
> | null                                     | LA1014
>                               | MH                                       |
> METRICID                            |
>
> | null                                     |
> LA1014                                   | MH
>                  | REGDATE                             |
>
> | null                                     |
> LA1014                                   | MH
>                               | VAL                                 |
>
>
> +------------------------------------------+------------------------------------------+------------------------------------------+-------------------------------------+
>
>
>
>  ------------------------------
> The information transmitted herein is intended only for the person or
> entity to which it is addressed and may contain confidential, proprietary
> and/or privileged material. Any review, retransmission, dissemination or
> other use of, or taking of any action in reliance upon, this information by
> persons or entities other than the intended recipient is prohibited. If you
> received this in error, please contact the sender and delete the material
> from any computer.
>
>