topic Re: How use where clause for isodate field during load from mongodb in App Development

How use where clause for isodate field during load from mongodb

erku — Fri, 19 Feb 2021 08:28:14 GMT

Hi,

I've tried to load and filter out isodate field from mongodb but I got a lot of trouble.
I use:
Load
a,
date
;
select
*
from tab1 where date<='2021-01-27T12:24:30.000Z'
but it doesn't work, it can't recognize '<='. If I use like statement: from tab1 where date<='2021-01-27%' it's working correctly. Why this timestamp is a string and how use <= and put proper type of date?
Could anyone help me?

Re: How use where clause for isodate field during load from mongodb

Anil_Babu_Samineni — Sun, 21 Feb 2021 20:24:55 GMT

Try this?

Load a,
date where ConvertToLocalTime(date)<=ConvertToLocalTime('2021-01-27T12:24:30.000Z');
select * from tab1;

Re: How use where clause for isodate field during load from mongodb

erku — Wed, 24 Feb 2021 16:09:18 GMT

Hi,

Yes it's working but looks like first it loads all data and then filter it out and loading takes a lot of time. Maybe it's some kind of performance issue. For example filtering one date:
where ConvertToLocalTime(date)=ConvertToLocalTime('2021-01-27T12:24:30.000Z')
takes 20 min. Any idea why?

Re: How use where clause for isodate field during load from mongodb

Anil_Babu_Samineni — Wed, 03 Mar 2021 20:54:16 GMT

When you say 20 minutes, how many records are there?