[jira] [Commented] (PHOENIX-1415) Unable to create TABLE VIEW for existing HBase table

["James Taylor (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-1415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14200475#comment-14200475 ] 

James Taylor commented on PHOENIX-1415:
---------------------------------------

Phoenix doesn't support table name space, but there's a JIRA for that here if you're interested in contributing that feature: PHOENIX-1311

Otherwise, I'm not sure how HBase resolves table names, but you might try not including zing: part in your CREATE VIEW statement.

> 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)