Github user fmcquillan99 commented on the issue:

    https://github.com/apache/madlib/pull/291
  
    Where did we land on the boolean casting issue?   Testing on Greenplum 5, I 
see:
    
    ```
    (psycopg2.ProgrammingError) plpy.SPIError: ARRAY types boolean and text 
cannot be matched
    CONTEXT:  Traceback (most recent call last):
      PL/Python function "cols2vec", line 23, in <module>
        return cols2vec_obj.cols2vec(**globals())
      PL/Python function "cols2vec", line 363, in cols2vec
    PL/Python function "cols2vec"
     [SQL: "SELECT madlib.cols2vec(\n    'golf',\n    'cols2vec_result',\n    
'windy, class'\n);"]
    ```
    
    ```
    (psycopg2.ProgrammingError) plpy.SPIError: ARRAY types integer and boolean 
cannot be matched
    CONTEXT:  Traceback (most recent call last):
      PL/Python function "cols2vec", line 23, in <module>
        return cols2vec_obj.cols2vec(**globals())
      PL/Python function "cols2vec", line 363, in cols2vec
    PL/Python function "cols2vec"
     [SQL: "SELECT madlib.cols2vec(\n    'golf',\n    'cols2vec_result',\n    
'temperature, windy'\n);"]
    ```


---

Reply via email to