Yeah, operator "-" does not seem to be supported, however, you can use "datediff" function:
In [9]: select datediff(CAST('2000-02-01 12:34:34' AS TIMESTAMP), CAST('2000-01-01 00:00:00' AS TIMESTAMP)) Out[9]: +----------------------------------------------------------------------------------------------------------------------+ | datediff(CAST(CAST(2000-02-01 12:34:34 AS TIMESTAMP) AS DATE), CAST(CAST(2000-01-01 00:00:00 AS TIMESTAMP) AS DATE)) | +----------------------------------------------------------------------------------------------------------------------+ | 31 | +----------------------------------------------------------------------------------------------------------------------+ In [10]: select datediff('2000-02-01 12:34:34', '2000-01-01 00:00:00') Out[10]: +--------------------------------------------------------------------------------+ | datediff(CAST(2000-02-01 12:34:34 AS DATE), CAST(2000-01-01 00:00:00 AS DATE)) | +--------------------------------------------------------------------------------+ | 31 | +--------------------------------------------------------------------------------+ In [11]: select datediff(timestamp '2000-02-01 12:34:34', timestamp '2000-01-01 00:00:00') Out[11]: +--------------------------------------------------------------------------------------------------------------+ | datediff(CAST(TIMESTAMP('2000-02-01 12:34:34.0') AS DATE), CAST(TIMESTAMP('2000-01-01 00:00:00.0') AS DATE)) | +--------------------------------------------------------------------------------------------------------------+ | 31 | +--------------------------------------------------------------------------------------------------------------+ On Fri, Oct 12, 2018 at 7:01 AM Paras Agarwal <paras.agar...@datametica.com> wrote: > Hello Spark Community, > > Currently in hive we can do operations on Timestamp Like : > CAST('2000-01-01 12:34:34' AS TIMESTAMP) - CAST('2000-01-01 00:00:00' AS > TIMESTAMP) > > Seems its not supporting in spark. > Is there any way available. > > Kindly provide some insight on this. > > > Paras > 9130006036 > -- John