You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2016/01/23 03:31:39 UTC
[jira] [Commented] (PHOENIX-2438) select * from table returns
fraction of rows
[ https://issues.apache.org/jira/browse/PHOENIX-2438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15113488#comment-15113488 ]
James Taylor commented on PHOENIX-2438:
---------------------------------------
Please provide a way to reproduce this, [~srinivaspraveen]
> 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
> 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)