How to read timestamp data from hive table in Talend

shameer1 — Sat, 16 Nov 2024 05:49:08 GMT

In my hive table, I have a column with datatype as timestamp. And some sample data as below

2019-04-12 15:52:51.962.

But I don't see any timestamp datatype in talend. Only see Date datatype. How can I read this data in Talend by treating the column value as a timestamp datatype and not a string datatype.

Thanks

Shameer

Re: How to read timestamp data from hive table in Talend

manodwhb — Thu, 16 May 2019 11:32:56 GMT

@shameer ,select the date datatype with below format.

yyyy-MM-dd HH:mm:ss.SSS

topic Re: How to read timestamp data from hive table in Talend in Talend Studio

How to read timestamp data from hive table in Talend

Re: How to read timestamp data from hive table in Talend