[
https://issues.apache.org/jira/browse/PHOENIX-1415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
venkat updated PHOENIX-1415:
----------------------------
Description:
I am unable to create TABLE VIEW for below mentioned existing HBase table.
here zing is table name space and macro is table name
Error: ERROR 601 (42P00): Syntax error. Encountered ":macro" at line 1, column
18. (state=42P00,code=601)
was:
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)
> 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
> 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)
