--! qt:dataset:src | |
set hive.fetch.task.conversion=more; | |
drop table date_4; | |
create table date_4 (d date); | |
alter table date_4 set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'; | |
-- Test date literal syntax | |
insert overwrite table date_4 | |
select date '2011-01-01' from src tablesample (1 rows); | |
select d, date '2011-01-01' from date_4 limit 1; | |
drop table date_4; |