blob: cbaef425d79c67bb2561cc47aa38b754b9b9c92d [file] [log] [blame]
-- EXTRACT in predicate
select count(*) from imp_t1 where EXTRACT(year from CONVERT_FROM(c_timestamp, 'TIMESTAMP_IMPALA')) <> '2014';