[
https://issues.apache.org/jira/browse/PHOENIX-2438?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-2438:
----------------------------------
Labels: verify (was: )
> 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.8.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
(v6.3.4#6332)
