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

Four Stars

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

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

Moderator

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

Hello,

What's your query in tBigQueryInput component?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Talend Cloud Developer Series – Deploying First Job to Cloud

This video will show you how to run a job in Studio and then publish that job to Talend Cloud

Watch Now

Talend Cloud Developer Series – Fetching Studio License

This video will help someone new to using Talend Studio get started by connecting to Talend Cloud and fetching the Studio License

Watch Now

Talend Cloud Developer Series - Introduction

The Talend Cloud Developer Series was created to give you a solid foundational understanding of Talend’s Cloud Integration Platform

Watch Now