phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Saurabh (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3419) phoenix client (sqlline) adds a duplicate table schema to the query
Date Wed, 02 Nov 2016 01:35:58 GMT

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

Saurabh commented on PHOENIX-3419:
----------------------------------

[~giacomotaylor] [~jamestaylor] - sorry for the delay, here is the DDL for the index

CREATE INDEX IF NOT EXISTS FIELD_HISTORY_ARCHIVE_INDEX 
ON ARCHIVE.FIELD_HISTORY_ARCHIVE (PARENT_KEY_PREFIX, CREATED_DATE, PARENT_ID, ENTITY_HISTORY_ID)
INCLUDE 
   (FIELD_HISTORY_ARCHIVE_ID, CREATED_BY_ID, FIELD, DATA_TYPE, OLDVAL_STRING, NEWVAL_STRING,

   OLDVAL_FIRST_NAME, NEWVAL_FIRST_NAME, OLDVAL_LAST_NAME, NEWVAL_LAST_NAME, OLDVAL_NUMBER,
    NEWVAL_NUMBER, OLDVAL_DATE, NEWVAL_DATE, ARCHIVE_PARENT_TYPE, ARCHIVE_FIELD_NAME,
    ARCHIVE_TIMESTAMP, ARCHIVE_PARENT_NAME, DIVISION, CONNECTION_ID) ASYNC

> phoenix client (sqlline) adds a duplicate table schema to the query
> -------------------------------------------------------------------
>
>                 Key: PHOENIX-3419
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3419
>             Project: Phoenix
>          Issue Type: Bug
>         Environment: HBase 0.98.20
>            Reporter: Saurabh
>
> phoenix client (sqlline) adds a duplicate table schema to the query. This causes the
select query to fail with table not found exception. Other DDL operations also are failing.
This appears to occur only with tables which have a secondary index.
> describe still works correctly.
> 0: jdbc:phoenix:istbd4-mnds1-1-crd.eng.sfdc.n> select count(1) from archive.field_history_archive;
> Error: ERROR 1012 (42M03): Table undefined. tableName=ARCHIVE.ARCHIVE.FIELD_HISTORY_ARCHIVE
(state=42M03,code=1012)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message