[Enterprise]Query Error

Community Support
1

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.

 

2

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.

3

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,

4

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