phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Special Charecters in Phoenix 2.2.2
Date Wed, 26 Mar 2014 18:02:29 GMT
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 <ankur5.c@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
>
>

Mime
View raw message