Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Partition By Query Problem

XYZ123Apr 28 2013
Hi everyone,

I'm trying to print out for every 5 seconds; the average value of each stock's price for last 10 seconds. The query shoud look like this:

select price, avg(price) from stockInputChannel [partition by stockName range 10 slide 5]

BUT, OCEP's CQL does not suppport this kind of query. It warns me to use "partition by $partname rows $rownumber range $rangevalue slide $slidevalue". As I mentioned above I do not need row related query, parameter.. Why the CQL forces me to use that?

Thanks.

Comments

alwu-Oracle
Hi,

I loaded the data you mentioned in another thread and run the query using Jena API. I got one answer for the query without seeing any problem.
I also checked the output you uploaded. It is unclear why the original query failed. There was no exception printed out.

Could you please run the query using Jena API (instead of Joseki) and then send the stack trace?

Thanks,

Zhe Wu
784525
Zhe,
This query is returning, the problem is that it takes a remarkably long time. It's taking nearly 4.5 seconds when most finish in tens or hundreds of milliseconds. When I looked into the logs to investigate the possible problems, I discovered that this query is responsible for over 8000 SELECT statements being sent to the database.

Making this query via the Jena API causes the same behavior.

The code I'm using to submit the query along with the output that is printed to standard out are bundled here
alwu-Oracle
In my test, I only see one query. Please email me your contact information so that I can give you a call.

Thanks,

Zhe Wu
784525
Awesome, your offline help fixed it. Turns out I had the wrong sdordf.jar. The rest of the patch was applied properly, but I had missed that step apparently. This query is executing very quickly now, no flood of SELECTS. Thank you.

Edited by: nyoung on Aug 19, 2010 2:29 PM
alwu-Oracle
Cool. Is the other problem still there?

1115984

Zhe
784525
yes. still truncating results.
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 26 2013
Added on Apr 28 2013
0 comments
829 views