finding length of string in spark SQL

Question

Hi,
I am trying to find length of string in spark sql, I tried LENGTH, length, LEN, len, char_length functions but all fail with error - ParseException: '
mismatched input \'len\' expecting (line 9, pos 9). I have imported - from pyspark.sql.functions import * in my script.
What is the actual function and what I am missing?

Answer

the problem is probably somewhere else as "length" is indeed a spark sql function

[https://spark.apache.org/docs/latest/api/sql/#length ]()

can you please post the whole SQL statement you're trying to execute?

Answer

Length is indeed a valid method, and the correct latest documentation link is here:
https://spark.apache.org/docs/latest/api/python/reference/api/pyspark.sql.functions.length.html

Please provide a code snippet to resolve your question.

finding length of string in spark SQL

Contenuto pertinente