[jira] [Commented] (SPARK-41298) Getting Count on data frame is giving the performance issue

["Ramakrishna (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-41298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17644164#comment-17644164 ] 

Ramakrishna commented on SPARK-41298:
-------------------------------------

Can some one please check behavior and update me asap.

> Getting Count on data frame is giving the performance issue
> -----------------------------------------------------------
>
>                 Key: SPARK-41298
>                 URL: https://issues.apache.org/jira/browse/SPARK-41298
>             Project: Spark
>          Issue Type: Bug
>          Components: Spark Core
>    Affects Versions: 2.4.4
>            Reporter: Ramakrishna
>            Priority: Major
>
> We are invoking  below query on Teradata 
> 1) Dataframe<Row> df = spark.format("jdbc"). . . load();
> 2) int count = df.count();
> When we executed the df.count spark internally issuing the below query on teradata which is wasting the lot of CPU on teradata and DBAs are making noise by seeing this query.
>  
> Query : SELECT 1 FROM (<ONE_MILLION_ROWS_TABLE>)SPARK_SUB_TAB
> Response:
> 1
> 1
> 1
> 1
> 1
> ..
> 1
>  
> Is this expected behavior from spark or is it bug.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org