I'm doing a job in datastage and when I insert the exact ODBC query from the current timestamp, it always passes me to null when writing to the table.
I have already used CURRENT_TIMESTAMP , (CURRENT_TIMESTAMP) , '#CURRENT_TIMESTAMP#' , etc. ..
Follow the query.
(INSERT INTO dev_dw.compress_log VALUES ('#ORIGIN_TABLE#' , '#DESTINATION_TABLE#', '#CONDITION#' , CURRENT_TIMESTAMP )).
Can anyone help me?
I created a parquet table in hive, while running the job I can not insert current_timestamp in the table I created.
INSERT INTO dev_dw.compress_log VALUES ('#ORIGIN_TABLE#' ,
'#DESTINATION_TABLE#', '#CONDITION#' , CURRENT_TIMESTAMP )