phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xinyi Yan (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-5179) empower/add more DateType related functions
Date Thu, 07 Mar 2019 08:03:00 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-5179?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Xinyi Yan updated PHOENIX-5179:
-------------------------------
    Description: 
In order to have a better user experience, we could offer a few useful syntactic sugar
functions for customers, especially for e-commerce users. They use the date range to fetch
last a few days/months expressions, GMV, unique buyers a lot. Many internal tools have very
good date wraps on top of it, such as 

1. DATE_RANGE

 
{code:java}
select * from table where DATE_RANGE(date, '2019-03-01') 
# date is equal or greater than the date.
select * from table where DATE_RANGE(date,'', '2019-03-01') 
# date is equal or less than the date.
select * from table where DATE_RANGE(date,'2018-05-12', '2019-03-01') 
# in range select
select * from table where DATE_RANGE(date,'2018-05-12', '2019-03-01', 'PST') 
# timezone option{code}
 2. DATE_INTERVAL

 
{code:java}
SELECT * from table where DATE_INTERVAL(time, '-7d')
# last 7 days
SELECT * from table where DATE_INTERVAL(time, '-1w')
# last week
SELECT * from table where DATE_INTERVAL(time, '-1m')
# last month{code}
3.DATE_ADD
{code:java}
select * from table where DATE_RANGE(date, '2019-03-01', 
         DATE_ADD('2019-03-01', '7d')) {code}
 

 

 

 

  was:
In order to have a better user experience, we could offer a few useful syntactic surge
functions for customers, especially for e-commerce users. They use the date range to fetch
last a few days/months expressions, GMV, unique buyers a lot. Many internal tools have very
good date wraps on top of it, such as 

1. DATE_RANGE

 
{code:java}
select * from table where DATE_RANGE(date, '2019-03-01') 
# date is equal or greater than the date.
select * from table where DATE_RANGE(date,'', '2019-03-01') 
# date is equal or less than the date.
select * from table where DATE_RANGE(date,'2018-05-12', '2019-03-01') 
# in range select
select * from table where DATE_RANGE(date,'2018-05-12', '2019-03-01', 'PST') 
# timezone option{code}
 2. DATE_INTERVAL

 
{code:java}
SELECT * from table where DATE_INTERVAL(time, '-7d')
# last 7 days
SELECT * from table where DATE_INTERVAL(time, '-1w')
# last week
SELECT * from table where DATE_INTERVAL(time, '-1m')
# last month{code}
3.DATE_ADD
{code:java}
select * from table where DATE_RANGE(date, '2019-03-01', 
         DATE_ADD('2019-03-01', '7d')) {code}
 

 

 

 


> empower/add more DateType related functions
> -------------------------------------------
>
>                 Key: PHOENIX-5179
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5179
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: Xinyi Yan
>            Priority: Minor
>
> In order to have a better user experience, we could offer a few useful syntactic sugar
functions for customers, especially for e-commerce users. They use the date range to fetch
last a few days/months expressions, GMV, unique buyers a lot. Many internal tools have very
good date wraps on top of it, such as 
> 1. DATE_RANGE
>  
> {code:java}
> select * from table where DATE_RANGE(date, '2019-03-01') 
> # date is equal or greater than the date.
> select * from table where DATE_RANGE(date,'', '2019-03-01') 
> # date is equal or less than the date.
> select * from table where DATE_RANGE(date,'2018-05-12', '2019-03-01') 
> # in range select
> select * from table where DATE_RANGE(date,'2018-05-12', '2019-03-01', 'PST') 
> # timezone option{code}
>  2. DATE_INTERVAL
>  
> {code:java}
> SELECT * from table where DATE_INTERVAL(time, '-7d')
> # last 7 days
> SELECT * from table where DATE_INTERVAL(time, '-1w')
> # last week
> SELECT * from table where DATE_INTERVAL(time, '-1m')
> # last month{code}
> 3.DATE_ADD
> {code:java}
> select * from table where DATE_RANGE(date, '2019-03-01', 
>          DATE_ADD('2019-03-01', '7d')) {code}
>  
>  
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message