Skip to content
New issue

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

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for upper and lower bounds on datetimes #506

Open
FishmanL opened this issue Nov 22, 2022 · 2 comments
Open

Add support for upper and lower bounds on datetimes #506

FishmanL opened this issue Nov 22, 2022 · 2 comments

Comments

@FishmanL
Copy link
Contributor

Specifically, so I can do things like
select avg(end_date-start_date) from table

@joshua-oss
Copy link
Contributor

This is possible. For scenarios like the above, though, adding a column like "duration" can often have better utility, since you can bound the sensitivity more tightly. For example, the view exposed to SmartNoise could have a column that is computed as end_date - start_date, and the bounds could be set by the data curator to be reasonably tight based on domain expertise or some previous analysis on similar data that can provide a reasonable (e.g.) 1.5X IQR to remove outliers.

@FishmanL
Copy link
Contributor Author

Yep, was planning to first-pass it with duration -- just trying to allow for more complicated things with datetimes than I might think of in advance (overall product is a wrapper around arbitrary queries)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants