Differences in exceptions in "tika_1_6" vs. "tika_1_8_SNAPSHOT"
File Extension | Number of Files | Number of Exceptions in A | Number of Exceptions in B | Number of Differences A to B | Percent Exceptions in A | Percent Exceptions in B |
ppt
| 11884
| 456
| 256
| -200
| 3.84 %
| 2.15 %
|
xls
| 7868
| 154
| 65
| -89
| 1.96 %
| 0.83 %
|
pdf
| 52020
| 56
| 20
| -36
| 0.11 %
| 0.04 %
|
unk
| 879
| 0
| 11
| 11
| 0.00 %
| 1.25 %
|
doc
| 16156
| 218
| 215
| -3
| 1.35 %
| 1.33 %
|
pps
| 160
| 5
| 3
| -2
| 3.12 %
| 1.87 %
|
txt
| 27671
| 4
| 3
| -1
| 0.01 %
| 0.01 %
|
select extensions_total.FILE_EXTENSION as 'File Extension', NUM_FILES as 'Number of Files', ifNull(NUM_CAUGHT_EXCEPTIONS_A, 0) as 'Number of Exceptions in A', ifNull(NUM_CAUGHT_EXCEPTIONS_B, 0) as 'Number of Exceptions in B', (ifNull(NUM_CAUGHT_EXCEPTIONS_B, 0) - ifNull(NUM_CAUGHT_EXCEPTIONS_A, 0)) as 'Number of Differences A to B', printf("%.2f %%", (100.0*ifNull(exceptions_A.NUM_CAUGHT_EXCEPTIONS_A, 0)/NUM_FILES)) as 'Percent Exceptions in A', printf("%.2f %% ", (100.0*ifNull(exceptions_B.NUM_CAUGHT_EXCEPTIONS_B, 0)/NUM_FILES)) as 'Percent Exceptions in B' from extensions_total left join exceptions_A on extensions_total.file_extension =exceptions_A.file_extension left join exceptions_B on extensions_total.[file_extension] =exceptions_B.file_extension where (ifNull(NUM_CAUGHT_EXCEPTIONS_B, 0) - ifNull(NUM_CAUGHT_EXCEPTIONS_A, 0)) <> 0 order by abs(ifNull(NUM_CAUGHT_EXCEPTIONS_B, 0) - ifNull(NUM_CAUGHT_EXCEPTIONS_A, 0)) desc;