The Uppercase will work for Calcite reserved words 2017-01-14 0:04 GMT+08:00 nichunen <nichu...@mininglamp.com>:
> Typo. > > > 2. Use TheTable.’KEYWORD’ in your sql > 3. Use TheTable.”KEYWORD” in your sql > > > > George/倪春恩 > > Mobile:+86-13501723787| WeChat:nceecn > > 北京明略软件系统有限公司(MiningLamp.COM > ) > > > > > > 上海市浦东新区晨晖路258号G座iDream张江科创中心C125 > > > > > Room C125#,Intelligent Industrial Park Building G,258#Chenhui Road, Pudong > District,Shanghai,201203 > > > > > > On Jan 13, 2017, at 11:58 PM, nichunen <nichu...@mininglamp.com> wrote: > > > > > > Suppose your table is “TheTable”, with a column named “keyword”. > > Try: > > 1. Use `keyword` in your sql > > 2. Use TheTable.’keyword’ in your sql > > 3. Use TheTable.”keyword” in your sql > > > > > > Wish one of these works. > > > > > > George/倪春恩 > > Mobile:+86-13501723787| WeChat:nceecn > > 北京明略软件系统有限公司(MiningLamp.COM > > ) > > > > > > > > > > 上海市浦东新区晨晖路258号G座iDream张江科创中心C125 > > > > > > > > > > Room C125#,Intelligent Industrial Park Building G,258#Chenhui Road, > Pudong District,Shanghai,201203 > > > > > > > >> On Jan 13, 2017, at 2:12 PM, read2me <readme...@gmail.com> wrote: > >> > >> > >> I have the field calls position,and it is the keyword in kylin > query.when i > >> execute the sql.error occurs. > >> Encountered "position from" at line 1, column 8. Was expecting one of: > >> "UNION" ... "INTERSECT" ... "EXCEPT" ... "ORDER" ... "LIMIT" ... > "OFFSET" > >> ... "FETCH" ... "STREAM" ... "DISTINCT" ... "ALL" ... "*" ... "+" ... > "-" > >> ... > >> > >> > >> > >> > >> > >> somebody who can help me! > >> > >> > >> -- > >> View this message in context: http://apache-kylin.74782.x6. > nabble.com/how-to-query-fields-with-keywords-tp6933.html > >> Sent from the Apache Kylin mailing list archive at Nabble.com. > >> >