cancel
Showing results for 
Search instead for 
Did you mean: 

[Enterprise]Query Error

soo
New Contributor II

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_0-1701739067892.png

 

3 REPLIES 3

gyorokpeter-kx
Contributor
Contributor

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
New Contributor II

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
Contributor
Contributor

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