I am facing an error while trying to write a CTE query in hive. Even though a column is defined with "Date", system is takin the input as "string". My query: WITH i_part AS (select i_part, CONCAT(i_suplr,i_suplr_loc_suff), case when q_rel_suplr_shp_2<>0 then d_rel_suplr_2 case ........................................ then .... //* case and then clauses case ........................................ then .... . . . else '9999-12-31' end as d_rel_issd from pchiers where l_kdo='N' and q_rel_suplr_shp_1 <> 0 and l_rel_curr='Y' and i_recvg_loc NOT IN ('04199','01299')) select * from i_part group by i_part; Error NOTE : data type of "d_rel_issd" in question, it is defined as "Date" datatype.
... View more
