Spark - extracting single value from DataFrame

Question

I have a Spark DataFrame query that is guaranteed to return single column with single Int value. What is the best way to extract this value as Int from the resulting DataFrame?

Answer 1

I will suggest you to use head()

df.head().getInt(0)

You can also use first()

df.first().getInt(0)