You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by read2me <re...@gmail.com> on 2017/01/13 06:12:35 UTC
how to query fields with keywords
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.
Re: how to query fields with keywords
Posted by Billy Liu <bi...@apache.org>.
The Uppercase will work for Calcite reserved words
2017-01-14 0:04 GMT+08:00 nichunen <ni...@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 <ni...@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 <re...@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.
> >>
>
Re: how to query fields with keywords
Posted by read2me <re...@gmail.com>.
THX All,it's solved.
upper case with double quote, for example "KEYWORD"
--
View this message in context: http://apache-kylin.74782.x6.nabble.com/how-to-query-fields-with-keywords-tp6933p6962.html
Sent from the Apache Kylin mailing list archive at Nabble.com.
Re: how to query fields with keywords
Posted by nichunen <ni...@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 <ni...@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 <re...@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.
>>
Re: how to query fields with keywords
Posted by nichunen <ni...@mininglamp.com>.
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 <re...@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.
>