https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-change-the-timstamp-type-to-string-with-the-below/m-p/199804#M71475 <P>Here is the solution for that</P><P>WHEN a1.Col1 = '1' THEN "b1.col2" Else CAST ('' as timestamp) END as Col3 . It will work </P> Tue, 21 Nov 2017 15:21:32 GMT lsundar19 2017-11-21T15:21:32Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-change-the-timstamp-type-to-string-with-the-below/m-p/199803#M71474 <P>How to change the timstamp type to string with the condition of </P><P>my query has CASE condition like. " WHEN a1.Col1 = '1' THEN "b1.col2" Else "" END as Col3" </P><P> here Col1 is timestamp and Col3 is String, So when i run the query, got this error .. ""Argument type mismatch '""': The expressions after THEN should have the same type: "timestamp" is expected but "string" is found"". I expect to here, if the condition failed i need to store "" (empty) value. Please help on this. Thanks in advance. </P> Mon, 20 Nov 2017 23:02:23 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-change-the-timstamp-type-to-string-with-the-below/m-p/199803#M71474 lsundar19 2017-11-20T23:02:23Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-change-the-timstamp-type-to-string-with-the-below/m-p/199804#M71475 <P>Here is the solution for that</P><P>WHEN a1.Col1 = '1' THEN "b1.col2" Else CAST ('' as timestamp) END as Col3 . It will work </P> Tue, 21 Nov 2017 15:21:32 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-change-the-timstamp-type-to-string-with-the-below/m-p/199804#M71475 lsundar19 2017-11-21T15:21:32Z