Details
-
Bug
-
Status: Patch Available
-
Minor
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
These two should be equivalent:
0: jdbc:phoenix:localhost> select count(B.COLB) from test;
+----------------+
| COUNT(B.COLB) |
+----------------+
| 10054 |
+----------------+
1 row selected (9.446 seconds)
0: jdbc:phoenix:localhost> select count(B.COLB) from test where B.COLB is not null;
+----------------+
| COUNT(B.COLB) |
+----------------+
| 10054 |
+----------------+
1 row selected (0.028 seconds)
Clearly the plain COUNT is doing unnecessary work.