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)
