[jira] [Commented] (SPARK-36816) Introduce a config variable for the incrementalCollects row batch size
[
https://issues.apache.org/jira/browse/SPARK-36816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17420578#comment-17420578
]
Ole commented on SPARK-36816:
-
I am running a Thrift Server {{/spark/sbin/start-thriftserver.sh}} with
{{--conf spark.sql.thriftServer.incrementalCollect=true}} to prevent
OutOfMemory Exceptions. Querying data results in batched result sets (as
intended) with log messages like this:
{code:bash}
21/09/27 08:25:33 INFO SparkExecuteStatementOperation: Returning result set
with 1000 rows from offsets [932000, 933000) with
50f346c0-02d4-40a2-a73c-30d326d2aae{code}
I'd like to be able to configure the value of {{1000 rows }}to be able to
adjust that value to our server capacity. Result would look like this:
{code:java}
21/09/27 08:25:33 INFO SparkExecuteStatementOperation: Returning result set
with 1 rows from offsets [932000, 942000) with
50f346c0-02d4-40a2-a73c-30d326d2aae{code}
> Introduce a config variable for the incrementalCollects row batch size
> --
>
> Key: SPARK-36816
> URL: https://issues.apache.org/jira/browse/SPARK-36816
> Project: Spark
> Issue Type: Improvement
> Components: SQL
>Affects Versions: 3.1.2
>Reporter: Ole
>Priority: Minor
>
> After enabling *_spark.sql.thriftServer.incrementalCollects_* Thrift will
> execute queries in batches (as intended). Unfortunately the batch size cannot
> be configured as it seems to be hardcoded
> [here|https://github.com/apache/spark/blob/6699f76fe2afa7f154b4ba424f3fe048fcee46df/sql/hive-thriftserver/src/main/java/org/apache/hive/service/cli/thrift/ThriftCLIServiceClient.java#L404].
> It would be useful to configure that value to be able to adjust it to your
> environment.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Updated] (SPARK-36816) Introduce a config variable for the incrementalCollects row batch size
[ https://issues.apache.org/jira/browse/SPARK-36816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ole updated SPARK-36816: Description: After enabling *_spark.sql.thriftServer.incrementalCollects_* Thrift will execute queries in batches (as intended). Unfortunately the batch size cannot be configured as it seems to be hardcoded [here|https://github.com/apache/spark/blob/6699f76fe2afa7f154b4ba424f3fe048fcee46df/sql/hive-thriftserver/src/main/java/org/apache/hive/service/cli/thrift/ThriftCLIServiceClient.java#L404]. It would be useful to configure that value to be able to adjust it to your environment. was: After enabling *_spark.sql.thriftServer.incrementalCollects_* Thrift will execute queries in batches (as intended). Unfortunately the batch size cannot be configured as it seems to be hardcoded [here|[https://github.com/apache/spark/blob/6699f76fe2afa7f154b4ba424f3fe048fcee46df/sql/hive-thriftserver/src/main/java/org/apache/hive/service/cli/thrift/ThriftCLIServiceClient.java#L404]]. It would be useful to configure that value to be able to adjust it to your environment. edit: the link does not work - https://github.com/apache/spark/blob/6699f76fe2afa7f154b4ba424f3fe048fcee46df/sql/hive-thriftserver/src/main/java/org/apache/hive/service/cli/thrift/ThriftCLIServiceClient.java#L404 > Introduce a config variable for the incrementalCollects row batch size > -- > > Key: SPARK-36816 > URL: https://issues.apache.org/jira/browse/SPARK-36816 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 3.1.2 >Reporter: Ole >Priority: Minor > > After enabling *_spark.sql.thriftServer.incrementalCollects_* Thrift will > execute queries in batches (as intended). Unfortunately the batch size cannot > be configured as it seems to be hardcoded > [here|https://github.com/apache/spark/blob/6699f76fe2afa7f154b4ba424f3fe048fcee46df/sql/hive-thriftserver/src/main/java/org/apache/hive/service/cli/thrift/ThriftCLIServiceClient.java#L404]. > It would be useful to configure that value to be able to adjust it to your > environment. > -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Updated] (SPARK-36816) Introduce a config variable for the incrementalCollects row batch size
[ https://issues.apache.org/jira/browse/SPARK-36816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ole updated SPARK-36816: Description: After enabling *_spark.sql.thriftServer.incrementalCollects_* Thrift will execute queries in batches (as intended). Unfortunately the batch size cannot be configured as it seems to be hardcoded [here|[https://github.com/apache/spark/blob/6699f76fe2afa7f154b4ba424f3fe048fcee46df/sql/hive-thriftserver/src/main/java/org/apache/hive/service/cli/thrift/ThriftCLIServiceClient.java#L404]]. It would be useful to configure that value to be able to adjust it to your environment. edit: the link does not work - https://github.com/apache/spark/blob/6699f76fe2afa7f154b4ba424f3fe048fcee46df/sql/hive-thriftserver/src/main/java/org/apache/hive/service/cli/thrift/ThriftCLIServiceClient.java#L404 was: After enabling *_spark.sql.thriftServer.incrementalCollects_* Thrift will execute queries in batches (as intended). Unfortunately the batch size cannot be configured as it seems to be hardcoded [here|[https://github.com/apache/spark/blob/6699f76fe2afa7f154b4ba424f3fe048fcee46df/sql/hive-thriftserver/src/main/java/org/apache/hive/service/cli/thrift/ThriftCLIServiceClient.java#L404]]. It would be useful to configure that value to be able to adjust it to your environment. > Introduce a config variable for the incrementalCollects row batch size > -- > > Key: SPARK-36816 > URL: https://issues.apache.org/jira/browse/SPARK-36816 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 3.1.2 >Reporter: Ole >Priority: Minor > > After enabling *_spark.sql.thriftServer.incrementalCollects_* Thrift will > execute queries in batches (as intended). Unfortunately the batch size cannot > be configured as it seems to be hardcoded > [here|[https://github.com/apache/spark/blob/6699f76fe2afa7f154b4ba424f3fe048fcee46df/sql/hive-thriftserver/src/main/java/org/apache/hive/service/cli/thrift/ThriftCLIServiceClient.java#L404]]. > It would be useful to configure that value to be able to adjust it to your > environment. > edit: the link does not work - > https://github.com/apache/spark/blob/6699f76fe2afa7f154b4ba424f3fe048fcee46df/sql/hive-thriftserver/src/main/java/org/apache/hive/service/cli/thrift/ThriftCLIServiceClient.java#L404 > -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Created] (SPARK-36816) Introduce a config variable for the incrementalCollects row batch size
Ole created SPARK-36816: --- Summary: Introduce a config variable for the incrementalCollects row batch size Key: SPARK-36816 URL: https://issues.apache.org/jira/browse/SPARK-36816 Project: Spark Issue Type: Improvement Components: SQL Affects Versions: 3.1.2 Reporter: Ole After enabling *_spark.sql.thriftServer.incrementalCollects_* Thrift will execute queries in batches (as intended). Unfortunately the batch size cannot be configured as it seems to be hardcoded [here|[https://github.com/apache/spark/blob/6699f76fe2afa7f154b4ba424f3fe048fcee46df/sql/hive-thriftserver/src/main/java/org/apache/hive/service/cli/thrift/ThriftCLIServiceClient.java#L404]]. It would be useful to configure that value to be able to adjust it to your environment. -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
