Special Charecters in Phoenix 2.2.2

[Ankur5 C <an...@tcs.com>]

Hi,

I have query like :

 SELECT * FROM v4.test  (testmeter-version VARCHAR,traffic VARCHAR) WHERE 
test=?  OR test=? ;

I am getting a parsing exception from Pheonix .

Error: ERROR 601 (42P00): Syntax error. Encountered "-" at line 1, column 
98. (state=42P00,code=601)

Same error via sqlline client also.

 Is it like Phoenix have some limitation in supporting characters like '-' 
 while querying ?

If so could you please list down a list of such characters .

Any help is appreciated .


Thanks and Regards,
Ankur Chakraborty
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you

Re: Special Charecters in Phoenix 2.2.2

[James Taylor <ja...@apache.org>]

SQL restricts column names to letters+numbers+underscore. Otherwise there
would be ambiguities in the grammar. If you want to get around this, you
can always double quote your column names.

Thanks,
James

On Wed, Mar 26, 2014 at 3:45 AM, Ankur5 C <an...@tcs.com> wrote:

> Hi,
>
> I have query like :
>
>  SELECT * FROM v4.test  (*testmeter-version* VARCHAR,traffic VARCHAR)
> WHERE test=?  OR test=? ;
>
> I am getting a parsing exception from Pheonix .
>
> Error: ERROR 601 (42P00): Syntax error. Encountered "-" at line 1, column
> 98. (state=42P00,code=601)
>
> Same error via sqlline client also.
>
>  Is it like Phoenix have some limitation in supporting characters like '-'
>  while querying ?
>
> If so could you please list down a list of such characters .
>
> Any help is appreciated .
>
>
> Thanks and Regards,
> Ankur Chakraborty
>
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you
>
>