Re: SQL Query over I-STAR
In SQL Query over I-STAR I wrote:
>
> select * from remote_rate
> where
> counter_id = 61 and
> timestamp > (current year to minute - interval(30) minute to minute)
> and I get:
> 1261: Too many digits in the first field of datetime or interval.
I turned on set explain and got this:
QUERY:
------
select * from cope_rate
where
counter_id = 61 and
timestamp > (current year to minute - interval(30) minute to minute)
Estimated Cost: 1
Estimated # of Rows Returned: 1
1) cope_rate: REMOTE PATH
Remote SQL Request:
select x0.counter_id ,x0.timestamp ,x0.duration ,x0.shift ,x0.qu
antity from printer_prod:"gap".rate x0 where ((x0.counter_id = 6
1 ) AND (x0.timestamp > (? - ' 30' ) ) )
Looks like maybe "CURRENT" isn't getting across the network?
Ken Miles
HP Vancouver Division
kenm@vcd.hp.com