Files with more attachments in "tika_1_6" than in "tika_1_8_SNAPSHOT"
FILE_EXTENSION | COUNT |
ppt
| 4
|
doc
| 1
|
SELECT FILE_EXTENSION, count(1) as COUNT from comparisons where NUM_ATTACHMENTS_A > NUM_ATTACHMENTS_B and JSON_EX_A is null and JSON_EX_B is null and SORT_STACK_TRACE_A is null and SORT_STACK_TRACE_B is null group by FILE_EXTENSION order by COUNT desc;