Reply
Highlighted
Explorer
Posts: 116
Registered: ‎09-14-2016

Externa table timestamp type

HI,

 

Our data come in, for time it is stored as bigint, we have to convert to timestamp, doing it in the view/query seems slow, so we are thinking create a new table to store as timestamp, my question is that if it is external it will be stored as string, so eventually it still does the conversion on the fly (during query), thus it will NOT help, unless we store as internal table?

 

 

Thanks

Shannon

Announcements