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.

Sign up for GitHub

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

Jump to bottom

feat: expression for creating timestamp from component fields #386

Closed
wesm opened this issue Jul 9, 2015 · 3 comments · Fixed by #3425
Closed

feat: expression for creating timestamp from component fields #386

wesm opened this issue Jul 9, 2015 · 3 comments · Fixed by #3425
Labels
feature Features or general enhancements onboarding Issues that can be addressed by someone less familiar with ibis ux User experience related issues
Milestone
3.0.0

Comments

@wesm
Copy link
Member

wesm commented Jul 9, 2015

This may need to be implemented in Impala or as an add-on UDF

as_timestamp(int year, int month, int day)
as_timestamp(int year, int month, int day, int hours, int minutes, int seconds, int milliseconds, int microseconds)
@wesm wesm added the feature Features or general enhancements label Jul 9, 2015
@wesm wesm added this to the 0.4 milestone Jul 9, 2015
@wesm wesm modified the milestones: 0.4, 0.5 Jul 16, 2015
@wesm wesm modified the milestones: 0.7, 0.5 Aug 24, 2015
@cpcloud cpcloud modified the milestones: 0.11, Future Jun 13, 2017
@saulshanabrook
Copy link
Contributor

Just noting that this would be useful in order to represent something similar to Vega's datetime function, which we need when compiling vega expression to ibis.

@datapythonista datapythonista removed this from the Future milestone Nov 13, 2020
@cpcloud
Copy link
Member

cpcloud commented Dec 6, 2021

Not impala specific, and in fact would need to be implemented in at least one other backend.

@cpcloud cpcloud added ux User experience related issues onboarding Issues that can be addressed by someone less familiar with ibis labels Dec 6, 2021
@cpcloud cpcloud changed the title UDF for creating timestamp or iso8601 datetime strings from component fields feat: UDF for creating timestamp or iso8601 datetime strings from component fields Dec 6, 2021
@cpcloud cpcloud changed the title feat: UDF for creating timestamp or iso8601 datetime strings from component fields feat: expression for creating timestamp or iso8601 datetime strings from component fields Dec 6, 2021
@cpcloud
Copy link
Member

cpcloud commented Dec 6, 2021

First thing to do would be to see if this already exists.

@cpcloud cpcloud mentioned this issue Dec 7, 2021
Closed
@cpcloud cpcloud changed the title feat: expression for creating timestamp or iso8601 datetime strings from component fields feat: expression for creating timestamp from component fields Feb 2, 2022
saulpw added a commit to saulpw/ibis that referenced this issue Feb 4, 2022
@saulpw
feat(date): add ibis.date(y,m,d) functionality
8869e78 
ref: ibis-project#386
saulpw added a commit to saulpw/ibis that referenced this issue Feb 8, 2022
@saulpw
feat(date): add ibis.date(y,m,d) functionality
f2fc2c9 
ref: ibis-project#386
saulpw added a commit to saulpw/ibis that referenced this issue Feb 9, 2022
@saulpw
feat(date): add ibis.date(y,m,d) functionality
dd0cb95 
ref: ibis-project#386
saulpw added a commit to saulpw/ibis that referenced this issue Feb 9, 2022
@saulpw
feat(date): add ibis.date(y,m,d) functionality
7733aeb 
ref: ibis-project#386
saulpw added a commit to saulpw/ibis that referenced this issue Feb 28, 2022
@saulpw
feat(date): add ibis.date(y,m,d) functionality
4dea771 
ref: ibis-project#386
saulpw added a commit to saulpw/ibis that referenced this issue Feb 28, 2022
@saulpw
feat(date): add ibis.date(y,m,d) functionality
f68d10b 
ref: ibis-project#386
saulpw added a commit to saulpw/ibis that referenced this issue Mar 9, 2022
@saulpw
feat(date): add ibis.date(y,m,d) functionality
2d9a128 
ref: ibis-project#386
saulpw added a commit to saulpw/ibis that referenced this issue Mar 9, 2022
@saulpw
feat(date): add ibis.date(y,m,d) functionality
ebeb8d7 
ref: ibis-project#386
@cpcloud cpcloud added this to the 3.0.0 milestone Mar 11, 2022
saulpw added a commit to saulpw/ibis that referenced this issue Mar 16, 2022
@saulpw
feat(date): add ibis.date(y,m,d) functionality
13b1b64 
ref: ibis-project#386
saulpw added a commit to saulpw/ibis that referenced this issue Mar 16, 2022
@saulpw
feat(date): add ibis.date(y,m,d) functionality
9650c9e 
ref: ibis-project#386
saulpw added a commit to saulpw/ibis that referenced this issue Mar 23, 2022
@saulpw
feat(date): add ibis.date(y,m,d) functionality
e4da05b 
ref: ibis-project#386
saulpw added a commit to saulpw/ibis that referenced this issue Mar 23, 2022
@saulpw
feat(date): add ibis.date(y,m,d) functionality
f7517fc 
ref: ibis-project#386
@cpcloud cpcloud mentioned this issue Mar 23, 2022
Merged
saulpw added a commit to saulpw/ibis that referenced this issue Mar 23, 2022
@saulpw
feat(date): add ibis.date(y,m,d) functionality
57f9999 
ref: ibis-project#386

feat(datetime): add ibis.time(y,m,d,h,m,s) functionality
saulpw added a commit to saulpw/ibis that referenced this issue Mar 23, 2022
@saulpw
feat(date): add ibis.date(y,m,d) functionality
55886c6 
ref: ibis-project#386

feat(datetime): add ibis.time(y,m,d,h,m,s) functionality
saulpw added a commit to saulpw/ibis that referenced this issue Mar 23, 2022
@saulpw
feat(date): add ibis.date(y,m,d) functionality
ee2b001 
ref: ibis-project#386

feat(datetime): add ibis.time(y,m,d,h,m,s) functionality
saulpw added a commit to saulpw/ibis that referenced this issue Mar 24, 2022
@saulpw
feat(date): add ibis.date(y,m,d) functionality
27b846d 
ref: ibis-project#386

feat(datetime): add ibis.time(y,m,d,h,m,s) functionality
cpcloud pushed a commit that referenced this issue Mar 25, 2022
@saulpw @cpcloud
feat(date): add ibis.date(y,m,d) functionality
26892b6 
ref: #386

feat(datetime): add ibis.time(y,m,d,h,m,s) functionality
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
feature Features or general enhancements onboarding Issues that can be addressed by someone less familiar with ibis ux User experience related issues
Projects
None yet
Milestone
3.0.0
Development

Successfully merging a pull request may close this issue.

Pw22 date from ymd saulpw/ibis
4 participants
@wesm @cpcloud @saulshanabrook @datapythonista