Query error in mapd


#1

Mapd db(mapd):
select count(m_txn_date) from m86775bb6_877a_47bb_b281_3c498b743516 where m_txn_date BETWEEN '2017-08-01' AND '2017-08-31';
output:
EXPR$0
2730

postgres db(AthenaFinance):
select count(txn_date) from "86775bb6-877a-47bb-b281-3c498b743516" where txn_date BETWEEN '2017-08-01' AND '2017-08-31';
output:
count

2821
(1 row)

i have moved tables from postgres to mapd,i am using same query in both mapd and postgres but i getting different values
data are same in both mapd and postgres its urgent can you reply me soon


#2

Hi @nagulan,

I guess for whatever reason Mapd and Postgres stored the DateTime information with different time zones, so the results are both valid but different.


#3

but in some tables it is correct
all are same date type column


#4

how do you copy data? with sqlimporter?