Sandeep Singh created SPARK-41837: ------------------------------------- Summary: DataFrame.createDataFrame datatype conversion error Key: SPARK-41837 URL: https://issues.apache.org/jira/browse/SPARK-41837 Project: Spark Issue Type: Sub-task Components: Connect Affects Versions: 3.4.0 Reporter: Sandeep Singh
{code:java} ********************************************************************** File "/Users/s.singh/personal/spark-oss/python/pyspark/sql/connect/functions.py", line 1117, in pyspark.sql.connect.functions.array Failed example: df.select(array('age', 'age').alias("arr")).collect() Expected: [Row(arr=[2, 2]), Row(arr=[5, 5])] Got: [Row(arr=array([2, 2])), Row(arr=array([5, 5]))] ********************************************************************** File "/Users/s.singh/personal/spark-oss/python/pyspark/sql/connect/functions.py", line 1119, in pyspark.sql.connect.functions.array Failed example: df.select(array([df.age, df.age]).alias("arr")).collect() Expected: [Row(arr=[2, 2]), Row(arr=[5, 5])] Got: [Row(arr=array([2, 2])), Row(arr=array([5, 5]))] ********************************************************************** File "/Users/s.singh/personal/spark-oss/python/pyspark/sql/connect/functions.py", line 1124, in pyspark.sql.connect.functions.array_distinct Failed example: df.select(array_distinct(df.data)).collect() Expected: [Row(array_distinct(data)=[1, 2, 3]), Row(array_distinct(data)=[4, 5])] Got: [Row(array_distinct(data)=array([1, 2, 3])), Row(array_distinct(data)=array([4, 5]))] ********************************************************************** File "/Users/s.singh/personal/spark-oss/python/pyspark/sql/connect/functions.py", line 1135, in pyspark.sql.connect.functions.array_except Failed example: df.select(array_except(df.c1, df.c2)).collect() Expected: [Row(array_except(c1, c2)=['b'])] Got: [Row(array_except(c1, c2)=array(['b'], dtype=object))] ********************************************************************** File "/Users/s.singh/personal/spark-oss/python/pyspark/sql/connect/functions.py", line 1142, in pyspark.sql.connect.functions.array_intersect Failed example: df.select(array_intersect(df.c1, df.c2)).collect() Expected: [Row(array_intersect(c1, c2)=['a', 'c'])] Got: [Row(array_intersect(c1, c2)=array(['a', 'c'], dtype=object))] ********************************************************************** File "/Users/s.singh/personal/spark-oss/python/pyspark/sql/connect/functions.py", line 1180, in pyspark.sql.connect.functions.array_remove Failed example: df.select(array_remove(df.data, 1)).collect() Expected: [Row(array_remove(data, 1)=[2, 3]), Row(array_remove(data, 1)=[])] Got: [Row(array_remove(data, 1)=array([2, 3])), Row(array_remove(data, 1)=array([], dtype=int64))] ********************************************************************** File "/Users/s.singh/personal/spark-oss/python/pyspark/sql/connect/functions.py", line 1187, in pyspark.sql.connect.functions.array_repeat Failed example: df.select(array_repeat(df.data, 3).alias('r')).collect() Expected: [Row(r=['ab', 'ab', 'ab'])] Got: [Row(r=array(['ab', 'ab', 'ab'], dtype=object))] ********************************************************************** File "/Users/s.singh/personal/spark-oss/python/pyspark/sql/connect/functions.py", line 1204, in pyspark.sql.connect.functions.array_sort Failed example: df.select(array_sort(df.data).alias('r')).collect() Expected: [Row(r=[1, 2, 3, None]), Row(r=[1]), Row(r=[])] Got: [Row(r=array([ 1., 2., 3., nan])), Row(r=array([1])), Row(r=array([], dtype=int64))] ********************************************************************** File "/Users/s.singh/personal/spark-oss/python/pyspark/sql/connect/functions.py", line 1207, in pyspark.sql.connect.functions.array_sort Failed example: df.select(array_sort( "data", lambda x, y: when(x.isNull() | y.isNull(), lit(0)).otherwise(length(y) - length(x)) ).alias("r")).collect() Expected: [Row(r=['foobar', 'foo', None, 'bar']), Row(r=['foo']), Row(r=[])] Got: [Row(r=array(['foobar', 'foo', None, 'bar'], dtype=object)), Row(r=array(['foo'], dtype=object)), Row(r=array([], dtype=object))] ********************************************************************** File "/Users/s.singh/personal/spark-oss/python/pyspark/sql/connect/functions.py", line 1209, in pyspark.sql.connect.functions.array_union Failed example: df.select(array_union(df.c1, df.c2)).collect() Expected: [Row(array_union(c1, c2)=['b', 'a', 'c', 'd', 'f'])] Got: [Row(array_union(c1, c2)=array(['b', 'a', 'c', 'd', 'f'], dtype=object))]{code} -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org