You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by GitBox <gi...@apache.org> on 2021/03/01 02:23:04 UTC
[GitHub] [iotdb] qiaojialin opened a new issue #2747: Too many paths in one query! Currently allowed max deduplicated path number is 28, this query contains 29 deduplicated path.
qiaojialin opened a new issue #2747:
URL: https://github.com/apache/iotdb/issues/2747
From 0.11.0:
This is due to that currently allocated memory for the query is occupied by other query instances, the left memory could only support a query with 28 series.
You could enlarge the memory allocated for read in write_read_schema_free_memory_proportion=4:3:1:2
Or decrease the fetch_size in each query, the default is 10000.
We calculate the memory usage for a query by : number of series in this query * fetch_size
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] qiaojialin edited a comment on issue #2747: Too many paths in one query! Currently allowed max deduplicated path number is 28, this query contains 29 deduplicated path.
Posted by GitBox <gi...@apache.org>.
qiaojialin edited a comment on issue #2747:
URL: https://github.com/apache/iotdb/issues/2747#issuecomment-787605215
fetch_size controls how many rows are returned from the server each time.
For example:
If your SQL is: SELECT S11,S14 FROM root.6.438,root.3.435 WHERE time = 1601895100000 fill (TEXT[PREVIOUS])
You could set fetch_size to 1.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] HTHou closed issue #2747: Too many paths in one query! Currently allowed max deduplicated path number is 28, this query contains 29 deduplicated path.
Posted by GitBox <gi...@apache.org>.
HTHou closed issue #2747:
URL: https://github.com/apache/iotdb/issues/2747
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] JackieTien97 commented on issue #2747: Too many paths in one query! Currently allowed max deduplicated path number is 28, this query contains 29 deduplicated path.
Posted by GitBox <gi...@apache.org>.
JackieTien97 commented on issue #2747:
URL: https://github.com/apache/iotdb/issues/2747#issuecomment-787608249
If you use the session pool, you can't set the fetchSize alone for each query. So you can change the default fetchSize 10000 to 1000 while constructing the session pool.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] qiaojialin commented on issue #2747: Too many paths in one query! Currently allowed max deduplicated path number is 28, this query contains 29 deduplicated path.
Posted by GitBox <gi...@apache.org>.
qiaojialin commented on issue #2747:
URL: https://github.com/apache/iotdb/issues/2747#issuecomment-787605215
fetch_size controls how many rows are return from the server each time.
For example:
If your SQL is: SELECT S11,S14 FROM root.6.438,root.3.435 WHERE time = 1601895100000 fill (TEXT[PREVIOUS])
You could set fetch_size to 1.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] HTHou closed issue #2747: Too many paths in one query! Currently allowed max deduplicated path number is 28, this query contains 29 deduplicated path.
Posted by GitBox <gi...@apache.org>.
HTHou closed issue #2747:
URL: https://github.com/apache/iotdb/issues/2747
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org