madlib-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fmcquillan99 <...@git.apache.org>
Subject [GitHub] madlib issue #234: Create lower case column name in encode_categorical_varia...
Date Fri, 16 Feb 2018 23:53:55 GMT
Github user fmcquillan99 commented on the issue:

    https://github.com/apache/madlib/pull/234
  
    Similarly
    ```
    DROP TABLE IF EXISTS abalone_out, abalone_out_dictionary;
    SELECT madlib.encode_categorical_variables (
            'abalone',                   -- Source table
            'abalone_out',               -- Output table
            'height::TEXT'               -- Categorical columns
            );
    SELECT * FROM abalone_out ORDER BY id;
    ```
    produces
    ```
    -[ RECORD 1 ]------+------
    id                 | 1
    sex                | M
    length             | 0.455
    diameter           | 0.365
    height             | 0.095
    rings              | 15
    height::TEXT_0.08  | 0
    height::TEXT_0.085 | 0
    height::TEXT_0.09  | 0
    height::TEXT_0.095 | 1
    height::TEXT_0.1   | 0
    height::TEXT_0.11  | 0
    height::TEXT_0.125 | 0
    height::TEXT_0.13  | 0
    height::TEXT_0.135 | 0
    height::TEXT_0.14  | 0
    height::TEXT_0.145 | 0
    height::TEXT_0.15  | 0
    -[ RECORD 2 ]------+------
    id                 | 2
    sex                | M
    length             | 0.35
    diameter           | 0.265
    height             | 0.09
    rings              | 7
    height::TEXT_0.08  | 0
    height::TEXT_0.085 | 0
    height::TEXT_0.09  | 1
    height::TEXT_0.095 | 0
    height::TEXT_0.1   | 0
    height::TEXT_0.11  | 0
    height::TEXT_0.125 | 0
    height::TEXT_0.13  | 0
    height::TEXT_0.135 | 0
    height::TEXT_0.14  | 0
    height::TEXT_0.145 | 0
    height::TEXT_0.15  | 0
    etc
    ```
    which does not seem to be PostgreSQL standard



---

Mime
View raw message