Junk values displayed when using tBigQueryinput to access a timestamp column from a table present in googleBigQuery

Anonymous — Sat, 16 Nov 2024 08:31:50 GMT

Hi All,

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.

Thanks,

Rajaneesh

Re: Junk values displayed when using tBigQueryinput to access a timestamp column from a table present in googleBigQuery

Anonymous — Fri, 23 Mar 2018 03:46:50 GMT

Hello,

What's your query in tBigQueryInput component?

Best regards

Sabrina

topic Junk values displayed when using tBigQueryinput to access a timestamp column from a table present in googleBigQuery in Talend Studio

Junk values displayed when using tBigQueryinput to access a timestamp column from a table present in googleBigQuery

Re: Junk values displayed when using tBigQueryinput to access a timestamp column from a table present in googleBigQuery