KX Community

Find answers, ask questions, and connect with our KX Community around the world.
KX Community Guidelines

Home Forums kdb Insights Query does not return row count from trade pipeline

  • Query does not return row count from trade pipeline

    Posted by Manu on January 3, 2025 at 5:19 am

    I am trialling kdb+ and I have deployed trade pipeline but the query:
    SELECT COUNT(*) from trade

    results in 0 rows

    The trade pipeline is RUNNING in Healthy status.

    What am I missing ?

    Manu replied 1 day, 11 hours ago 2 Members · 2 Replies
  • 2 Replies
  • k2q

    Member
    January 3, 2025 at 1:04 pm

    Just try this one.

    select count i from trade
    

    Refer q4m3: https://code.kx.com/q4m3/9_Queries_q-sql/#9133-basic-queries

    • Manu

      Member
      January 3, 2025 at 1:13 pm

      Thanks mate, I’ve got it. I realised that I hadn’t run the ‘quick test’ before deploying. But I recreated the pipeline this time quick testing. All went well.
      Thanks for responding anyways.

Log in to reply.