[
https://issues.apache.org/jira/browse/PHOENIX-6651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17825212#comment-17825212
]
Istvan Toth commented on PHOENIX-6651:
--------------------------------------
That would point to the bug being in Avatica and not Sqlline.
> !primarykeys cannot list t
> --------------------------
>
> Key: PHOENIX-6651
> URL: https://issues.apache.org/jira/browse/PHOENIX-6651
> Project: Phoenix
> Issue Type: Bug
> Components: queryserver
> Affects Versions: queryserver-6.0.0
> Reporter: YangLei
> Priority: Major
>
> Hi experts.
> when I ran !primarykeys in the cmd line of sqlline-thin.py, it listed no
> information of the table.
> while it did list primary key infomation in the cmd line of sqlline.py.
> Is this expected or a bug, or some configuration issue? Could you help to
> check?
> 0: jdbc:phoenix:thin:url=http://localhost:876> !primarykeys FN2.GROUPCHATINFO
> +------------+--------------+-------------+--------------+----------+----------+
> | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME | KEY_SEQ | PK_NAME
> |
> +------------+--------------+-------------+--------------+----------+----------+
> +------------+--------------+-------------+--------------+----------+----------+
>
> +
> 0: jdbc:phoenix:> !primarykeys FN2.GROUPCHATINFO
> +------------+--------------+----------------+--------------+----------+----------+--------------+------------+------------+--------------+----------+------+
> | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME | KEY_SEQ |
> PK_NAME | ASC_OR_DESC | DATA_TYPE | TYPE_NAME | COLUMN_SIZE | TYPE_ID |
> VIEW |
> +------------+--------------+----------------+--------------+----------+----------+--------------+------------+------------+--------------+----------+------+
> | | FN2 | GROUPCHATINFO | CHATID | 1 |
> | A | 12 | VARCHAR | null | 12 |
> |
> +------------+--------------+----------------+--------------+----------+----------+--------------+------------+------------+--------------+----------+------+
> 0: jdbc:phoenix:>
>
> Thanks
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
