Re: Add custom fields into Json

2019-10-29 Thread Jingsong Li
Hi Srikanth, Which sql throws exception? On Tue, Oct 29, 2019 at 3:41 PM vino yang wrote: > Hi, > > The exception shows your SQL statement has grammatical errors. Please > check it again or provide the whole SQL statement here. > > Best, > Vino > > srikanth flink 于2019年10月29日周二 下午2:51写道: > >> H

Re: Add custom fields into Json

2019-10-29 Thread Jingsong Li
Hi Srikanth, 1.Can you share complete sql? And schema of input table? 2.What schema you want to select? I didn't understand what is "agg" field mean. On Tue, Oct 29, 2019 at 3:28 PM Jingsong Li wrote: > Hi Srikanth, > 1.Can you share complete sql? And schema of input table? > 2.What schema you w

Re: Add custom fields into Json

2019-10-29 Thread vino yang
Hi, The exception shows your SQL statement has grammatical errors. Please check it again or provide the whole SQL statement here. Best, Vino srikanth flink 于2019年10月29日周二 下午2:51写道: > Hi there, > > I'm querying json data and is working fine. I would like to add custom > fields including the que

Add custom fields into Json

2019-10-28 Thread srikanth flink
Hi there, I'm querying json data and is working fine. I would like to add custom fields including the query result. My query looks like: select ROW(`source`), ROW(`destination`), ROW(`dns`), organization, cnt from (select (source.`ip`,source.`isInternalIP`) as source, (destination.`ip`,destinatio