Sign in
apache
/
hive
/
6b095edc31a9baa0ae805e2b5aea88101284d84b
/
.
/
ql
/
src
/
test
/
queries
/
clientpositive
/
date_timestamp_prec.q
blob: c7c8e0be5e35cf3c07fa5ce81b17330b127e47c3 [
file
] [
log
] [
blame
]
--!
qt
:
dataset
:
src
create table mytable
(
i integer
,
d date
);
insert overwrite table mytable
select
1
,
cast
(
'2011-01-01'
as
date
)
from
src tablesample
(
1
rows
);
select
i
,
coalesce
(
d
,
cast
(
d
as
timestamp
))
from
mytable
;
drop table mytable
;