Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
shameer1
Contributor

How to read timestamp data from hive table in Talend

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

Labels (2)
1 Solution

Accepted Solutions
manodwhb
Champion II

@shameer ,select the date datatype with below format.

 

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

View solution in original post

1 Reply
manodwhb
Champion II

@shameer ,select the date datatype with below format.

 

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