[
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)