[jira] [Commented] (HAWQ-133) core when use plpython udf

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HAWQ-133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15094662#comment-15094662 ] 

ASF GitHub Bot commented on HAWQ-133:
-------------------------------------

GitHub user gcaragea opened a pull request:

    https://github.com/apache/incubator-hawq/pull/261

    HAWQ-133. Remove MD Versioning code

    We will implement a simpler invalidation-based solution instead of versioning. This will be used by the Query Optimizer to manage Metadata Cache. 

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/gcaragea/incubator-hawq gcaragea-remove-mdversioning

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-hawq/pull/261.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #261
    
----
commit 0c320b5af1f508a5b9512a69701085f423b92245
Author: George Caragea <gc...@pivotal.io>
Date:   2016-01-12T19:33:36Z

    [HAWQ-333] Remove Metadata Versioning code

commit 792723139bec40cc8aa78abcb9599739f56402ed
Author: George Caragea <gc...@pivotal.io>
Date:   2016-01-12T19:43:39Z

    [HAWQ-333] Removed unit test relevant to Metadata Versioning

----


> core when use plpython udf
> --------------------------
>
>                 Key: HAWQ-133
>                 URL: https://issues.apache.org/jira/browse/HAWQ-133
>             Project: Apache HAWQ
>          Issue Type: Bug
>            Reporter: Dong Li
>            Assignee: Lei Chang
>
> Run sqls below can recur the core.
> {code}
> CREATE PROCEDURAL LANGUAGE plpythonu;
> CREATE TABLE users (
> 	fname text not null,
> 	lname text not null,
> 	username text,
> 	userid serial
> 	-- , PRIMARY KEY(lname, fname) 
> 	) DISTRIBUTED BY (userid);
> INSERT INTO users (fname, lname, username) VALUES ('jane', 'doe', 'j_doe');
> INSERT INTO users (fname, lname, username) VALUES ('john', 'doe', 'johnd');
> INSERT INTO users (fname, lname, username) VALUES ('willem', 'doe', 'w_doe');
> INSERT INTO users (fname, lname, username) VALUES ('rick', 'smith', 'slash');
> CREATE FUNCTION spi_prepared_plan_test_one(a text) RETURNS text
> 	AS
> 'if not SD.has_key("myplan"):
> 	q = "SELECT count(*) FROM users WHERE lname = $1"
> 	SD["myplan"] = plpy.prepare(q, [ "text" ])
> try:
> 	rv = plpy.execute(SD["myplan"], [a])
> 	return "there are " + str(rv[0]["count"]) + " " + str(a) + "s"
> except Exception, ex:
> 	plpy.error(str(ex))
> return None
> '
> 	LANGUAGE plpythonu;
> select spi_prepared_plan_test_one('doe');
> select spi_prepared_plan_test_one('smith');
> {code}
> when execute "select spi_prepared_plan_test_one('smith');"
> server closed the connection unexpectedly
> 	This probably means the server terminated abnormally
> 	before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
> !>



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)