Search for answers here or ask a question
0

can pyramid model maintain timestamps with microsecond precision?

i want to down sample a vertica source table via pyramid model "query" to a vertica target table but my microsecond precision timestamps are getting chopped to precision in seconds.

i do not need time intelligence applied.  

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Did you create an ETL with a Vertica source and Vertica target?
    Or is this Direct Query?
     

    Like
  • The former. There is associated down sampling to have the resulting dataset most responsive.
    I converted the time stamp to a formatted string, but that feels like a hack and requires converting back to timestamp when querying. 
     

    Like
Like Follow
  • 2 wk agoLast active
  • 2Replies
  • 30Views
  • 2 Following