hive时间转为星期几

方式一：from_unixtime(unix_timestamp(‘20140112’,‘yyyyMMdd’),‘u’)
方拾二：select date_format(‘2016-12-01’ ,‘u’);
方式三：select pmod(datediff(your_date,‘1900-01-07’),7) + 1 as WeekDay from your_table
方式四：SELECT current_date AS Date,
CASE date_format(current_date,‘u’)
WHEN 1 THEN ‘Mon’
WHEN 2 THEN ‘Tues’
WHEN 3 THEN ‘Wed’
WHEN 4 THEN ‘Thu’
WHEN 5 THEN ‘Fri’
WHEN 6 THEN ‘Sat’
WHEN 7 THEN ‘Sun’
END AS day_of_week