hive date datatype with 6 digit nano seconds

Extremely few systems work with that level of precision.  A rubidium vapor frequency standard would not be good enough(it is almost good enough)  you would need a cesium beam frequency standard  A temperature compensated crystal oscillator you get about  1.1 x 10^-8   A line frequency clock would be entirely and completely unusable (line frequency is very stable over the LONG period but all over the place in the short time period.

when dealing with this accuracy of time everything has to be taken into account i.e.
National bureau of standards publishes monthly statistics of the previous month's delays and other pertinent data. You can't use the internet since you have no idea of what path was taken each and every time you do a measurement.

I dealt with 500hz ground wave standards and the distance between the transmitter and the receivers antennas where known.
We would get the data of the transmitters delay, the cable delay and the antenna delay and the gps position of the antenna (transmitted) .. Since our receiving antenna was fixed we could work out the distance and we already knew the specific antennas delay, transmission feed delay and the receivers delay.

Getting time to 10^-9 is a difficult and expensive process gps time isn't sufficient as it is on the order of 40 nanoseconds 95% of the time.  

Note computers don't use temperature controlled crystal oscillators

Various operating systems and languages time accuracy https://en.wikipedia.org/wiki/System_time

I want output like this what hive function can get me this?
basically with 6 digits ex.

10-Jun-15 11.45.23.564567 AM

Select allOpen in new window

hive hadoop
or Teradata date function that can get me this kind of output is what i am looking for

In Teradata, you can use timestamp(6) datatype to get 6 digits after seconds.

https://forgetcode.com/teradata/1352-difference-between-timestamp-0-and-timestamp-6