Re: Timestamp Difference/operations

2018-10-16 Thread Paras Agarwal
yee WHERE Date '1974-01-02' > CAST(CAST(CURRENT_DATE AS TIMESTAMP) + (??) AS DATE) Need to fill above ?? so that i can process. Thanks & Regards, Paras 9130006036 From: Srabasti Banerjee Sent: Tuesday, October 16, 2018 6:45:26 AM To: Paras Agarw

Re: Timestamp Difference/operations

2018-10-15 Thread Srabasti Banerjee
supported. Let me know if its possible, or any UDF available for the same. Thanks And Regards, Paras From: John Zhuge Sent: Friday, October 12, 2018 9:48:47 PM To: Paras Agarwal Cc: user; dev Subject: Re: Timestamp Difference/operations Yeah, operator "-" does not seem to b

Re: Timestamp Difference/operations

2018-10-14 Thread Paras Agarwal
:47 PM To: Paras Agarwal Cc: user; dev Subject: Re: Timestamp Difference/operations 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-0

Re: Timestamp Difference/operations

2018-10-12 Thread John Zhuge
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]: +-

Timestamp Difference/operations

2018-10-12 Thread Paras Agarwal
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