Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Already on GitHub? Sign in to your account

Measurements in chartevents where error = 1 #154

Open
tompollard opened this Issue Nov 21, 2016 · 1 comment

Comments

Projects
None yet
1 participant
Owner

tompollard commented Nov 21, 2016

Our understanding is that a value of 1 in the error column of chartevents indicates an erroneous measurement. There are several scripts in the code repo that don't exclude these measurements, but which probably should.

Owner

tompollard commented Nov 23, 2016

The following clause is not good, because it excludes rows where the error field is NULL.

FROM chartevents
WHERE error != 1

Instead we can do:

FROM chartevents
WHERE error IS DISTINCT FROM 1

@tompollard tompollard added a commit that referenced this issue Nov 23, 2016

@tompollard tompollard exclude error = 1. ref #154 401132f
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment