[
https://issues.apache.org/jira/browse/PHOENIX-6651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17686698#comment-17686698
]
Istvan Toth commented on PHOENIX-6651:
--------------------------------------
I can repro it with the latest pqs and sqlline.
This is strange, because this does work with the python PQS client and Hue,
which also uses PQS.
We'd have to dig deeper to see if the problem is in Avatica or 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: 5.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)
