syntax for named streams

View: New views
3 Messages — Rating Filter:   Alert me  

syntax for named streams

by justinmiller621 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hey all,

I feel like there is probably a simple solution to this, but for the life of me, I cannot get the syntax right for using a named stream in my where clause. I've read the documentation over and over. Here is what I've got:

"select * from MyEvent as evt where MyUtils.myFunction(evt)"

When I create the statement, I get an error that reads:

"Property named 'evt' is not valid in any stream"

From everything I've read, this should be simple and my syntax is correct. Just for kicks, I also tried:

"select evt.* as myEvent from MyEvent as evt where MyUtils.myFunction(myEvent)"

And pretty much got the same error. The only way I've gotten this to work is, in the first statement, to replace 'evt' with 's0'. I'd like the stream name to be a little more descriptive than 's0' though.

Anyone have a clue what I'm doing wrong?

Thanks!
Justin

Re: syntax for named streams

by justinmiller621 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Has no one encountered this? Is this not as simple as I might have thought? Does my syntax look right?

justinmiller621 wrote:
Hey all,

I feel like there is probably a simple solution to this, but for the life of me, I cannot get the syntax right for using a named stream in my where clause. I've read the documentation over and over. Here is what I've got:

"select * from MyEvent as evt where MyUtils.myFunction(evt)"

When I create the statement, I get an error that reads:

"Property named 'evt' is not valid in any stream"

From everything I've read, this should be simple and my syntax is correct. Just for kicks, I also tried:

"select evt.* as myEvent from MyEvent as evt where MyUtils.myFunction(myEvent)"

And pretty much got the same error. The only way I've gotten this to work is, in the first statement, to replace 'evt' with 's0'. I'd like the stream name to be a little more descriptive than 's0' though.

Anyone have a clue what I'm doing wrong?

Thanks!
Justin

Re: syntax for named streams

by Thomas Bernhardt :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.
Hi Justin,

I have created a JIRA for this issue at http://jira.codehaus.org/browse/ESPER-393

Best regards,
Tom

From: justinmiller621 <justin.adam.miller@...>
To: user@...
Sent: Monday, September 14, 2009 9:12:21 AM
Subject: Re: [esper-user] syntax for named streams


Has no one encountered this? Is this not as simple as I might have thought?
Does my syntax look right?


justinmiller621 wrote:

>
> Hey all,
>
> I feel like there is probably a simple solution to this, but for the life
> of me, I cannot get the syntax right for using a named stream in my where
> clause. I've read the documentation over and over. Here is what I've got:
>
> "select * from MyEvent as evt where MyUtils.myFunction(evt)"
>
> When I create the statement, I get an error that reads:
>
> "Property named 'evt' is not valid in any stream"
>
> From everything I've read, this should be simple and my syntax is correct.
> Just for kicks, I also tried:
>
> "select evt.* as myEvent from MyEvent as evt where
> MyUtils.myFunction(myEvent)"
>
> And pretty much got the same error. The only way I've gotten this to work
> is, in the first statement, to replace 'evt' with 's0'. I'd like the
> stream name to be a little more descriptive than 's0' though.
>
> Anyone have a clue what I'm doing wrong?
>
> Thanks!
> Justin
>

--
View this message in context: http://www.nabble.com/syntax-for-named-streams-tp25407689p25435530.html
Sent from the Esper User list mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email