KX Community

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

Home Forums kdb Insights [Enterprise]Query Error

  • [Enterprise]Query Error

    Posted by soo on December 5, 2023 at 12:00 am

    Hello, I’m soo.
    I want to move data from my s3 to kdb and do query.
    S3 and kdb are connected using the access key, and the pipe line was executed and deployed successfully.
    But in the process of inquiring the data, a timeout keeps occurring.
    Can you help me with what caused the error and how to fix it?

    The data I used is Kaggle’s train data.

    https://www.kaggle.com/competitions/ashrae-energy-prediction/data?select=train.csv
    (Additionally Query progresses well when kx’s weather data is stored in my s3 and moved it)

    Thank you.

     

     

    soo replied 9 months ago 2 Members · 3 Replies
  • 3 Replies
  • gyorokpeter-kx

    Member
    December 5, 2023 at 12:00 am

    Can you please paste in the query you are executing and any relevant logs?

    What is the size of the data? If your query is trying to fetch too much data, it may result in processes hitting the memory limit and crashing, resulting in the query timing out.

  • soo

    Member
    December 11, 2023 at 12:00 am

    Data’s size is  4 x 1048576(Include Data Schema)

    This error occurred when you pressed Get Data in the query.(Amount of data selected: 4 x 2302)

    Error: Querying database using (Get Data) raised – Request timed out,

  • gyorokpeter-kx

    Member
    December 11, 2023 at 12:00 am

    It would be helpful to see all the relevant logs including those of RC, DAPs and aggregator.

Log in to reply.