Hi,

I have a partitioned table ORDERS having two partitions named: OpenOrders and ClosedOrders.

Now I want to fire a delete on some of the closed orders. So to make the query efficient i want to specify the partition from which to delete (which will be ClosedOrders partition).

But when I use normal SQL syntax :

delete from Orders partition (closedOrders) where id = ?

I get the exception "Unexpected Token partition "

Can anybody tell how to specify partition in HQL query?

Hi,
Here is a link pointing to HQL grammar.
http://anonhibernate.labs.jboss.com/tru ... mmar/hql.g

deleteStatement
: DELETE^
(optionalFromTokenFromClause)
(whereClause)?
;

optionalFromTokenFromClause!
: (FROM!)? f:path (a:asAlias)? {
AST #range = #([RANGE, "RANGE"], #f, #a);
#optionalFromTokenFromClause = #([FROM, "FROM"], #range);
}
;

I don't get it fully. Looks like, it is not possible to have partition specified here.

--------------------------------------------------------------
Rate the reply if you find it helpful