Does anyone have any thoughts on how to solve the following issue?
I have a data table with timestamp column part of the PK and a date dimension table with timestamp field as the PK. In joining the two tables I get the following error. The funny part is that when running the query again and again I get different min/maxStamp and once in a while the query executes. I tried with both PQS and thick client.
Error while executing SQL "select t.*, s.* from TRUCK.T_SIM_03 as s INNER JOIN TRUCK.DIM_DATE_TIME as t on s.EVENT_DATE_TIME = t.EVENT_DATE_TIME limit 100": Remote driver error: IllegalArgumentException: Timestamp cannot be negative. minStamp:8780528765093431859, maxStamp:-3008216813838049331
Hello, I just bumped into the same error. Did you find a solution/explanation to this ?