[ 
https://issues.apache.org/jira/browse/TAJO-762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14009038#comment-14009038
 ] 

ASF GitHub Bot commented on TAJO-762:
-------------------------------------

Github user hyunsik commented on the pull request:

    https://github.com/apache/tajo/pull/16#issuecomment-44211915
  
    In my machine, the newly included unit tests are failed as following. Could 
you check this?
    
    My machine information is as follows:
    * Mac 10.8.5
    * SUN JDK 1.7.0_51
    * There is no TZ shell environment variable by default.
    
    ```
    2014-05-27 04:08:55,294 INFO: org.apache.tajo.master.TajoAsyncDispatcher 
(stop(122)) - AsyncDispatcher stopped:querymaster_1401131062215
    2014-05-27 04:08:55,294 INFO: 
org.apache.tajo.master.querymaster.QueryMaster (stop(159)) - QueryMaster stop
    2014-05-27 04:08:55,294 INFO: 
org.apache.tajo.worker.TajoWorkerClientService (stop(109)) - 
TajoWorkerClientService stopping
    2014-05-27 04:08:55,295 INFO: org.apache.tajo.rpc.NettyServerBase 
(shutdown(128)) - Rpc (QueryMasterClientProtocol) listened on 
0:0:0:0:0:0:0:0:33396) shutdown
    2014-05-27 04:08:55,295 INFO: 
org.apache.tajo.worker.TajoWorkerClientService (stop(113)) - 
TajoWorkerClientService stopped
    2014-05-27 04:08:55,296 INFO: org.apache.tajo.worker.TajoWorker (stop(334)) 
- TajoWorker main thread exiting
    
    Results :
    
    Failed tests:   
testDateTimeNow(org.apache.tajo.engine.function.TestDateTimeFunctions): select 
current_date(); expected:<2014-05-2[7]> but was:<2014-05-2[6]>
      
testTimeValueKeyword(org.apache.tajo.engine.function.TestDateTimeFunctions): 
select current_date; expected:<2014-05-2[7]> but was:<2014-05-2[6]>
    
    Tests run: 754, Failures: 2, Errors: 0, Skipped: 0
    ```


> Implements current date/time function
> -------------------------------------
>
>                 Key: TAJO-762
>                 URL: https://issues.apache.org/jira/browse/TAJO-762
>             Project: Tajo
>          Issue Type: Sub-task
>            Reporter: Hyoungjun Kim
>            Assignee: Hyoungjun Kim
>            Priority: Trivial
>         Attachments: TAJO-762.patch
>
>
> There is several functions or keywords to get current date/time value.
> - current_timestamp: Returns the current timestamp in the TIMESTAMP type.
> - current_date: Returns the current time in the DATE type.
> - current_time: Returns the current time in the TIME type.
> - now(): Returns the current timestamp in the TIMESTAMP type.
> {noformat}
> babokim=# select current_timestamp, current_date, current_time, now();
>               now              |    date    |       timetz       |            
>   now
> -------------------------------+------------+--------------------+-------------------------------
>  2014-05-13 21:22:39.566864+09 | 2014-05-13 | 21:22:39.566864+09 | 2014-05-13 
> 21:22:39.566864+09
> (1 row)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to