[
https://issues.apache.org/jira/browse/PHOENIX-1415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14200703#comment-14200703
]
Samarth Jain commented on PHOENIX-1415:
---------------------------------------
Phoenix doesn't allow column family for row key columns. What column family you
have specified for retailerId on the hbase table?
> Unable to create TABLE VIEW for existing HBase table
> ----------------------------------------------------
>
> Key: PHOENIX-1415
> URL: https://issues.apache.org/jira/browse/PHOENIX-1415
> Project: Phoenix
> Issue Type: Task
> Affects Versions: 4.0.0
> Environment: CentOS
> Reporter: venkat
> Labels: TABLE, VIEW, phoenix
> Fix For: 4.0.0
>
> Original Estimate: 12h
> Remaining Estimate: 12h
>
> I am unable to create TABLE VIEW for below mentioned existing HBase table.
> here zing is table name space and macro is table name
> CREATE VIEW “zing:macro” ( “_”.retailerId INTEGER, “_”.eventId VARCHAR,
> “_”.channelServerId VARCHAR, “_”.channelEndpointName VARCHAR,
> “_”.channelEndpointVersion VARCHAR, “_”.transactionTime VARCHAR,
> “_”.transactionParseTime VARCHAR, “_”transactionVersion VARCHAR, “_”.dataType
> VARCHAR, “_”.ieType, “_”.serveOfferFlag VARCHAR, “_”.cacheResyncFlag VARCHAR,
> “_”.totalSpend VARCHAR, “_”.receiptBarcode VARCHAR, “_”.version VARCHAR,
> “_”.timestamp TIMESTAMP, “log”.receiptBody VARCHAR, “log”.matchingEngineTrace
> VARCHAR, “log”.parsingErrors VARCHAR, “log”.originalTransactionData VARCHAR,
> “log”.jsonType VARCHAR, “log”.jsonValue VARCHAR, “trn”.timestamp TIMESTAMP,
> “trn”.id VARCHAR, “trn”.uuid VARCHAR, “trn”.deflate VARCHAR, “pt”.uuid
> VARCHAR, “pt”.name VARCHAR, “pt”.type VARCHAR, “pt”.personality VARCHAR,
> “pt”.version VARCHAR, “pt”.settings_timeZoneOffset VARCHAR,
> “pt”.settings_currencies VARCHAR, “pt”.o_store VARCHAR, “pt”.o_branch
> VARCHAR, “pt”.o_region VARCHAR, “pt”.o_company VARCHAR, “pt”.o_loc_addr
> VARCHAR, “pt”.o_loc_postcode VARCHAR, “pt”.o_loc_country VARCHAR, CONSTRAINT
> pk PRIMARY KEY(retailerId, eventId) );
> Error: ERROR 601 (42P00): Syntax error. Encountered ":macro" at line 1,
> column 18. (state=42P00,code=601)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
