Error on some query


#1

I queried as below, then got an error after some seconds. ( and mapd session is expired. )
( taxi_weather_tracts_factual : from nyc taxi example )

mapdql> SELECT COUNT(*) as n FROM taxi_weather_tracts_factual WHERE (EXTRACT(DOW from TIMESTAMPADD(HOUR, -5, pickup_datetime)) = 1 OR EXTRACT(DOW from TIMESTAMPADD(HOUR, -5, pickup_datetime)) = 2);

Thrift: Mon Mar 19 07:51:56 2018 TSocket::write_partial() send() <Host: localhost Port: 9091>Broken pipe
Thrift: Mon Mar 19 07:52:17 2018 TSocket::write_partial() send() <Host: localhost Port: 9091>Broken pipe

mapdql> [any input]
Session not valid.

But this query executed very well.

mapdql> SELECT COUNT(*) as n FROM taxi_weather_tracts_factual WHERE (EXTRACT(DOW from TIMESTAMPADD(HOUR, -5, pickup_datetime)) = 1);
n
1600491


#2

Hi @jude, thanks for pointing this out!

We believe we have identified the issue and the fix will likely be committed today (and will be in the next release).

Thanks again.


#3

I can confirm the issue was fixed and will be pushed out to our open source repo shortly (and will be in the next release).