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

Ashutosh Chauhan commented on HIVE-14873:
-----------------------------------------

Patch looks good. 
Currently, it supports three aliases for this: dayofweek, dow and weekday. I 
looked around to see if there is any standard around it and seems different 
databases do different things. SQL Server supports weekday, dw but returns 
Tuesday instead of 3 for this. MySQL & Oracle supports it the way we have under 
alias dayofweek. Postgres supports dow but returns 0-based index. 
In wake of all this inconsistency, my suggestion will be to just support 
dayofweek and  avoid confusion.

> Add UDF for extraction of 'day of week'
> ---------------------------------------
>
>                 Key: HIVE-14873
>                 URL: https://issues.apache.org/jira/browse/HIVE-14873
>             Project: Hive
>          Issue Type: Bug
>          Components: Parser, UDF
>    Affects Versions: 2.1.0
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>         Attachments: HIVE-14873.01.patch, HIVE-14873.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to