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>
