L. C. Hsieh created SPARK-34703:
-----------------------------------

             Summary: Fix pyspark test when using sort_values on Pandas
                 Key: SPARK-34703
                 URL: https://issues.apache.org/jira/browse/SPARK-34703
             Project: Spark
          Issue Type: Bug
          Components: PySpark
    Affects Versions: 2.4.7
            Reporter: L. C. Hsieh
            Assignee: L. C. Hsieh


Three PySpark tests are currently failed in Jenkins: test_column_order, 
test_complex_groupby, test_udf_with_key.

{code}
======================================================================          
                                                                                
                                                                       
ERROR: test_column_order (pyspark.sql.tests.GroupedMapPandasUDFTests)           
                                                                                
                                                                       
----------------------------------------------------------------------
Traceback (most recent call last):                                              
                                   
  File "/spark/python/pyspark/sql/tests.py", line 5996, in test_column_order    
                                                                                
                                                                       
    expected = pd_result.sort_values(['id', 'v']).reset_index(drop=True)        
                                   
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/frame.py", line 
4711, in sort_values                    
    for x in by]                                       
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/generic.py", line 
1702, in _get_label_or_level_values
    self._check_label_or_level_ambiguity(key, axis=axis)
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/generic.py", line 
1656, in _check_label_or_level_ambiguity
    raise ValueError(msg)                                                       
                                   
ValueError: 'id' is both an index level and a column label, which is ambiguous.
                                                         
======================================================================
ERROR: test_complex_groupby (pyspark.sql.tests.GroupedMapPandasUDFTests)
----------------------------------------------------------------------
Traceback (most recent call last):                      
  File "/spark/python/pyspark/sql/tests.py", line 5765, in test_complex_groupby
    expected = expected.sort_values(['id', 'v']).reset_index(drop=True)
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/frame.py", line 
4711, in sort_values
    for x in by]                                                                
                                   
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/generic.py", line 
1702, in _get_label_or_level_values                                             
                                                                          
    self._check_label_or_level_ambiguity(key, axis=axis)                        
                                                                                
                                                                       
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/generic.py", line 
1656, in _check_label_or_level_ambiguity                                        
                                                                          
    raise ValueError(msg)                                                       
                                                                                
                                                                       
ValueError: 'id' is both an index level and a column label, which is ambiguous. 
                                                                                
                                                                       
                                                                                
                                                                                
                                                                       
======================================================================          
                                   
ERROR: test_udf_with_key (pyspark.sql.tests.GroupedMapPandasUDFTests)           
                                                                                
                                                                       
----------------------------------------------------------------------          
                                   
Traceback (most recent call last):                                              
                                                                                
                                                                       
  File "/spark/python/pyspark/sql/tests.py", line 5922, in test_udf_with_key
    .sort_values(['id', 'v']).reset_index(drop=True)                            
                                                                                
                                                                       
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/frame.py", line 
4711, in sort_values                                                            
                                                                            
    for x in by]                                                                
                                                                                
                                                                       
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/generic.py", line 
1702, in _get_label_or_level_values   
    self._check_label_or_level_ambiguity(key, axis=axis)                        
                                                                                
                                                                       
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/generic.py", line 
1656, in _check_label_or_level_ambiguity                                        
                                                                          
    raise ValueError(msg)                                                       
                                                                                
                                                                       
ValueError: 'id' is both an index level and a column label, which is ambiguous. 
  
{code}




--
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

Reply via email to