[
https://issues.apache.org/jira/browse/PHOENIX-1421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14202281#comment-14202281
]
James Taylor commented on PHOENIX-1421:
---------------------------------------
Seems like you may have some unexpected character within the double quotes?
Either that, or the table namespace is throwing things off. You might try a
test by creating an HBase table without a namespace to see if it behaves
correctly.
Also, make sure you only have a single PRIMARY KEY defined. If you want a
composite primary key, you need to list it at the end with all the columns that
make up your row key (see below). Can you give us an example of an existing row
key? Based on your VIEW definition, we'd expect the following structure:
{code}
<4 byte int><null terminated UTF8 encoded string><4 byte int>
{code}
If you're mapping to an existing HBase table whose data was serialized using
the Bytes utility methods in HBase, you'll need to use our UNSIGNED_INT types
instead. If your string is fixed length (and not null terminated), then you'll
want to use CHAR(xx) where the xx is the character length.
{code}
CREATE VIEW “zing” (retailerId UNSIGNED_INT,
eventId VARCHAR,
seq UNSIGNED_INT,
“pr”.”offerId” INTEGER,
“pr”.”promotionId” INTEGER,
“pr”.”expiry” INTEGER,
“pr”.”serveBarcode” VARCHAR,
“pr”.”servedUcode” VARCHAR,
“pr”.”issuedBarcode” VARCHAR,
“pr”.”issuedUcode” VARCHAR,
“pr”.”printer” INTEGER,
“pr”.”interpreter” INTEGER,
“pr”.”cache” INTEGER,
CONSTRAINT pk PRIMARY KEY(retailerId, eventId, seq));
{code}
> User-space table qualifiers can only contain 'alphanumeric characters': i.e.
> [a-zA-Z_0-9-.]
> --------------------------------------------------------------------------------------------
>
> Key: PHOENIX-1421
> URL: https://issues.apache.org/jira/browse/PHOENIX-1421
> Project: Phoenix
> Issue Type: Bug
> Reporter: venkat
>
> while I am trying to map with my HBase table the following exception occurred.
> java.lang.IllegalArgumentException: Illegal character code:-30, <￢> at 17.
> User-space table qualifiers can only contain 'alphanumeric characters': i.e.
> [a-zA-Z_0-9-.]: ZING.MACRO”
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
