Hi Team I am referring to translateFilter(RexNode e) of DruidQuery class. When I have multiple conditions in the where clause, the filterString lower and upper values get converted into long format. Though in case of single filter condition it works fine.
I started debugging this method, and found that it is called from a loop. In every iteration the value of SqlType of operands in new JsonBound("bound", tr(e, posRef), tr(e, posConstant), true, null, false, false) keeps switching from CHAR to TIMESTAMP. Could you please suggest what can be the source of this issue or how to effectively debug to get to the source? Also, is the timestamp key in the mode.json mandatory? I am not using that field because my table contains more than one Date column. So I am rather checking the type of the column instead of matching it with the column name stated in this json key, to do the required timestamp parsing. Sample queries : select Sum("event_count") as "Sum_event_count", "event_severity" from "PIM_DOCTYPE_3"."PIM_DOCTYPE_3" where ("event_time_gmt" > timestamp('2016-01-15 00:00:00')) and ("event_time_gmt" < timestamp('2016-01-17 00:00:00')) group by "event_severity" order by "event_severity"; //timestamp gets converted to long. select Sum("event_count") as "Sum_event_count", "event_severity" from "PIM_DOCTYPE_3"."PIM_DOCTYPE_3" where ("event_time_gmt" < timestamp('2016-01-17 00:00:00')) group by "event_severity" order by "event_severity"; //working fine Thanks and Regards Shuchi Gupta Software Engineer (CA) CA Technologies | Plot 115/1, 115/16-115/21 | Hyderabad, 500032 Office: +71262 | shuchi.gup...@ca.com <mailto:shuchi.gup...@ca.com>[CA]<http://www.ca.com/us/default.aspx>[Twitter]<http://twitter.com/CAInc>[Slideshare]<http://www.slideshare.net/cainc>[Facebook]<https://www.facebook.com/CATechnologies>[YouTube]<http://www.youtube.com/user/catechnologies>[LinkedIn]<http://www.linkedin.com/company/1372?goback=.cps_1244823420724_1>[Google+]<https://plus.google.com/+CATechnologies>[Google+]<http://www.ca.com/us/rss.aspx?intcmp=footernav>