You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@madlib.apache.org by "Frank McQuillan (JIRA)" <ji...@apache.org> on 2017/12/12 21:23:00 UTC
[jira] [Updated] (MADLIB-1186) Correlation query fails with
international chars in column name
[ https://issues.apache.org/jira/browse/MADLIB-1186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Frank McQuillan updated MADLIB-1186:
------------------------------------
Priority: Minor (was: Major)
> Correlation query fails with international chars in column name
> ---------------------------------------------------------------
>
> Key: MADLIB-1186
> URL: https://issues.apache.org/jira/browse/MADLIB-1186
> Project: Apache MADlib
> Issue Type: Bug
> Components: Module: Inferential Statistics
> Reporter: Nandish Jayaram
> Assignee: ssoni
> Priority: Minor
> Fix For: v1.13
>
>
> We tried running the correlation module in MADlib, on a table that had
> international characters for schema, and column name of one of the
> independent variables. It resulted in the following error:
> {code}
> select
> madlib.correlation(
> '"nåmespace"."dt_gOlf"',
> '"__madlib_temp_26728701_1513000192_9340672___πøA"',
> 'id, temperature, "Humidity"');
> psql:/tmp/build/60928da1/madlib_testsuite/tests/Correlation/sql_CorrelationInternationalCharOutputTestCase/test_correlation_international_char.sql:12: ERROR: spiexceptions.SyntaxError: syntax error at or near ""Humidity""
> LINE 10: ...rature, avg_temperature),coalesce("Humidity", avg_"Humidity"...
> ^
> QUERY:
> CREATE TEMP TABLE __madlib_temp_43456465_1513000195_75531635__ AS
> SELECT
> count(*) AS tot_cnt,
> mean,
> madlib.correlation_agg(x, mean) as cor_mat
> FROM
> (
> SELECT ARRAY[ coalesce(id, avg_id),coalesce(temperature, avg_temperature),coalesce("Humidity", avg_"Humidity") ] AS x,
> ARRAY [ avg_id,avg_temperature,avg_"Humidity" ] AS mean
> FROM "nåmespace"."dt_gOlf",
> (
> SELECT avg(id) AS avg_id,avg(temperature) AS avg_temperature,avg("Humidity") AS avg_"Humidity"
> FROM "nåmespace"."dt_gOlf"
> )sub1
> ) sub2
> GROUP BY mean
> CONTEXT: Traceback (most recent call last):
> PL/Python function "correlation", line 23, in <module>
> return correlation.correlation(**globals())
> PL/Python function "correlation", line 71, in correlation
> PL/Python function "correlation", line 205, in _populate_output_table
> PL/Python function "correlation"
> select * from "__madlib_temp_26728701_1513000192_9340672___πøA" order by column_position;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)