You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@phoenix.apache.org by "Lars Hofhansl (Jira)" <ji...@apache.org> on 2021/03/23 04:06:00 UTC

[jira] [Commented] (PHOENIX-6425) SELECT count(cf.*) or count(cf.cq) fail with a parse exception

    [ https://issues.apache.org/jira/browse/PHOENIX-6425?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17306739#comment-17306739 ] 

Lars Hofhansl commented on PHOENIX-6425:
----------------------------------------

SELECT COUNT(cf.cq) also throws an exception and that syntax is sometimes needed to disambiguate a column reference, so it's needed.

> SELECT count(cf.*) or count(cf.cq) fail with a parse exception
> --------------------------------------------------------------
>
>                 Key: PHOENIX-6425
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6425
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Lars Hofhansl
>            Priority: Major
>
> It's not SQL standard, so we can certainly decide not to support it.
> I do feel that if SELECT CF.* FROM ... works, then SELECT COUNT(CF.*) FROM ... should work too.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)