Time part of timestamp datatype
4 views
Skip to first unread message
Srushti Vaidya
Jul 26, 2017, 10:08:39 AM7/26/17
to HIVE Community
Hi
I have a table which has just a time column..i have defined the column as timestamp.
While loading the data the source file just has time and not dat so i just want the time part of timestamp data type.
For example
Create table example(a int, b timestamp)
Fron table source insert into exame select a,b as "00:00:00"
I have a table which has just a time column..i have defined the column as timestamp.
While loading the data the source file just has time and not dat so i just want the time part of timestamp data type.
For example
Create table example(a int, b timestamp)
Fron table source insert into exame select a,b as "00:00:00"
Can somebody help me how to write this query?
Reply all
Reply to author
Forward
0 new messages