phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (PHOENIX-2272) Unable to run count(1), count(*) or select explicit columns queries on a table with a secondary index
Date Thu, 03 May 2018 17:18:00 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-2272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

James Taylor resolved PHOENIX-2272.
-----------------------------------
    Resolution: Cannot Reproduce

> Unable to run count(1), count(*) or select explicit columns queries on a table with a
secondary index
> -----------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-2272
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2272
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.5.1
>         Environment: HBase1.0, CDH5.4.5
>            Reporter: Kumar Palaniappan
>            Priority: Major
>              Labels: verify
>             Fix For: 4.14.0
>
>
> Unable to run select count(1) from table_name or select count(*) from table_name or select
"id1" from table_name when there is a secondary index on a column in that table. It returns
0 records.
> But select * from table_name works. 
> select count(*) from r3.ads;
> +------------------------------------------+
> |                 COUNT(1)                 |
> +------------------------------------------+
> | 0                                        |
> +------------------------------------------+
> 1 row selected (0.104 seconds)
> 0: jdbc:phoenix:labs-**********> select count(1) from r3.ads;
> +------------------------------------------+
> |                 COUNT(1)                 |
> +------------------------------------------+
> | 0                                        |
> +------------------------------------------+
> select count(distinct("cstId")) from r3.ads;
> +------------------------------------------+
> |         DISTINCT_COUNT("cstId")          |
> +------------------------------------------+
> | 0                                        |
> +------------------------------------------+
> 1 row selected (0.114 seconds)
>  jdbc:phoenix:labs-**********> select /*+ NO_INDEX */count(1) from r3.ads;
> +------------------------------------------+
> |                 COUNT(1)                 |
> +------------------------------------------+
> | 1617732                                  |
> +------------------------------------------+
> 1 row selected (2.007 seconds)
> If I force with a hint NO_INDEX works.
> Is that related to somewhat this one? https://issues.apache.org/jira/browse/PHOENIX-1203



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message