blob: 6a9b44de8a0f489bf231e638c5c1167743482cc2 [file] [log] [blame]
--! 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;