I am using tBigQueryInput component to access a table from goolgeBigQuery which has a column called timestamp and the datatype is timestamp.Data stored in bigquery is like this 2017-08-10 15:23:53.369 UTC.But i get error as "Unparseable date: "1444885211.564"".In the input component,if i keep the date pattern as "yyyy-MM-dd", the i get some date values like this 1451-01-11,1447-06-14,1450-12-09.
Can you please tell where i am doing wrong in accessing the timestamp values.
What's your query in tBigQueryInput component?
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.