Six Stars

Time part of date reset to 00:00:00.000000 in Big data spark job

I am using talend Bigdata platform 6.3

TsqlIssue.jpg

 

I have written a sql query using Tsql component. But the thing is that I am getting time part of the date reset to 00:00:00.000000

For ex: in the output file , I am getting the following date 

01-07-2017 00:00:00.000000

This can be an issue with the hive context of Tsql component . 

if you have any ideas around this. pls reply.

Tags (3)
1 REPLY
Community Manager

Re: Time part of date reset to 00:00:00.000000 in Big data spark job

Hi TomG
Can you upload a screenshot to show the schema and query? I will consult our developers and see if they can help to answer this.

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business