Re: [Postgres-xc-general] Execute direct fails with syntax error

[Mason S. <ma...@st...>]

EXECUTE DIRECT ON (datanode1) ‘select count(*) from app.someTable’;

Parens and single quotes.


On Wed, Jun 18, 2014 at 2:31 PM, Aaron Jackson <aja...@re...>
wrote:

>  Sorry if this seems awefully mundane, but I’ve tried this several ways
> and it simply doesn’t seem to work.
>
>
>
> EXECUTE DIRECT ON datanode1 select count(*) from app.someTable;
>
>
>
> ERROR:  syntax error at or near “datanode1” – I’ve tried variations..
>
>
>
> EXECUTE DIRECT ON NODE datanode1 select count(*) from app.someTable;
>
> EXECUTE DIRECT ON NODE datanode1 ‘select count(*) from app.someTable’;
>
> EXECUTE DIRECT ON datanode1 ‘select count(*) from app.someTable’;
>
>
>
> Those should be single quotes if they come across wrong.  I’d venture to
> guess there is a BNF parser somewhere that processed this request and if
> so, I’ll go dig down into that code to see if it’s a bison parsing issue.
> Any suggestions or pointers would be helpful, or maybe I just screwed up
> the syntax.
>
>
>
> Aaron
>
>
> ------------------------------------------------------------------------------
> HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
> Find What Matters Most in Your Big Data with HPCC Systems
> Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
> Leverages Graph Analysis for Fast Processing & Easy Data Exploration
> http://p.sf.net/sfu/hpccsystems
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>


-- 
Mason Sharp

StormDB - http://www.stormdb.com
The Database Cloud
Postgres-XC Support and Services