venkat created PHOENIX-1415:
-------------------------------
Summary: 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
Fix For: 4.0.0
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)
