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.  

2 replies

null
    • Daniel_Chitlaru
    • 10 mths ago
    • Reported - view

    Did you create an ETL with a Vertica source and Vertica target?
    Or is this Direct Query?
     

    • quantenabler
    • 10 mths ago
    • Reported - view

    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. 
     

Content aside

  • Status Answered
  • 10 mths agoLast active
  • 2Replies
  • 51Views
  • 2 Following