You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Badam Srinivas Praveen (JIRA)" <ji...@apache.org> on 2015/11/20 19:01:10 UTC
[jira] [Created] (PHOENIX-2438) select * from table returns
fraction of rows
Badam Srinivas Praveen created PHOENIX-2438:
-----------------------------------------------
Summary: 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
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)