The query looks like valid SQL. However, I don’t recall whether we have implemented INSERT INTO … SELECT … GROUP BY.
Can you please log a JIRA case along with the exception stack, and post the JIRA URL here? Then someone can investigate further. Julian > On Nov 27, 2015, at 4:36 AM, Raghavender Reddy Erupaka > <[email protected]> wrote: > > Hi Team, > > I am trying to run below queries using SQLParser object, the first query is > executing as expected but when am adding sum(ppd.value) function I am > getting exception, but same query I am able to run in SQL SERVER. > > Working query: insert into planning_point_data_cache > (ts_business_name_id,planning_point_seq,detail_id,detail_id,period_id,cache_value) > select > ppd.ts_business_name_id,denorm.input_ppt_cache_seq,denorm.detail_id,denorm.period_id,cache_value > from rule_output_input_map_normalize denorm join > planning_point_data ppd on denorm.input_ppt_seq=ppd.planning_point_seq > where denorm.param_order='raghu' and > denorm.input_ppt_cache_seq>0 group by ppd.ts_business_name_id. > > Problem facing query: insert into > planning_point_data_cache(ts_business_name_id,planning_point_seq,detail_id,detail_id,period_id,cache_value) > > selectppd.ts_business_name_id,denorm.input_ppt_cache_seq,denorm.detail_id,denorm.period_id,sum(ppd.value) > from rule_output_input_map_normalize denorm join > planning_point_data ppd ondenorm.input_ppt_seq=ppd.planning_point_seq > where denorm.param_order='raghu' and > denorm.input_ppt_cache_seq>0 group byppd.ts_business_name_id,ppd.value > > May I know the problem. > > > > Thanks, > > Raghavender Reddy Erupaka > Software Engineer > > Steelwedge Software, Inc. > > cell 9030684174 > www.steelwedge.com <http://www.steelwedge.com/> > > > Plan. Perform. Profit. > > CONFIDENTIALITY NOTICE This message, including any attachments, contains > confidential information and may contain information that is also proprietary > and/or privileged. If you are not the intended recipient, you are hereby > notified that any disclosure, copying, distribution or use of this message is > strictly prohibited. If you have received this message in error, please > notify us immediately by replying to this e-mail and then delete this message > and its attachments from your system. Thank you.
