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-2438) select * from table returns fraction of rows
Date Thu, 03 May 2018 17:15:00 GMT

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

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

> select * from table returns fraction of rows
> --------------------------------------------
>
>                 Key: PHOENIX-2438
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2438
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.3.0
>         Environment: Development
>            Reporter: Badam Srinivas Praveen
>            Priority: Minor
>              Labels: verify
>             Fix For: 4.14.0
>
>   Original Estimate: 96h
>  Remaining Estimate: 96h
>
> Mismatch in number of rows while selecting table.
> select * from table fetches only 305 rows while select count(1) from table gives 52528
rows.
>  select count(1) from tbl_recipe;
> +------------------------------------------+
> |                 COUNT(1)                 |
> +------------------------------------------+
> | 52528                                    |
> +------------------------------------------+
> select * from tbl_recipe;
> +------------------------------------------+------------------------------------------+------------------------------------------+--------------------------+
> | 300528                                   | XLSiP700C600T31                        
 | EPI\XLSiP700C600T31.xml                  | 9                        |
> | 300532                                   | SSiGe-SiH4-C4gd2                       
 | EpiXP\SSiGe-SiH4-C4gd2.xml               | 9                        |
> | 300536                                   | SSiGe-SiH4-C09a8                       
 | Epi4\SSiGe-SiH4-C09a8.xml                | 9                        |
> | 300540                                   | Lrrr_3_65                              
 | SiCoNi\Lrrr_3_65.xml                     | 9                        |
> | 300545                                   | ZZHCLBAK10TORA                         
 | Epi4\ZZHCLBAK10TORA.xml                  | 9                        |
> | 300549                                   | GB_SiGe20_713                          
 | Epi4\GB_SiGe20_713.xml                   | 9                        |
> +------------------------------------------+------------------------------------------+------------------------------------------+--------------------------+
> 305 rows selected (4.611 seconds)



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

Mime
View raw message