Endpoint Errors

Summary uses the same components as Streaming, so any Summary errors should also refer to Streaming.

Issue: Summary Data not Created

Check Summary Sources API Values

API: https://docs.hydrolix.io/reference/list-summary-sources

Check:

  • parent_table - The name of the parent table in Streaming ingest for the incoming data
  • subtype – Must be called “summary”
  • table – the target “project.tablename”
  • transform – the name of the transform to use to ingest the table
  • type – must be “pull”
  • service – Must be “summary-peer”

Check Stream-Peer Logs and Stream-Peer-Turbine Logs

API: System Health

Check
Carefully read the exeption you get back in the "turbine" container and the stream-peer, kafka-peer, kinesis-peer container.

  • Datetime format for primary timestamp.
  • Check the SQL.

Review transform and edit accordingly.

https://docs.hydrolix.io/docs/transforms-and-write-schema

https://docs.hydrolix.io/docs/timestamp-data-types

https://docs.hydrolix.io/docs/summary-tables-aggregation

Check the Transform

API: https://docs.hydrolix.io/reference/list-transforms

  • Ensure the output columns for the parent table match the incoming data.
  • Check the transform SQL outputs the expected values to the summary transform.