phoenix-dev mailing list archives

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

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

James Taylor commented on PHOENIX-3419:
---------------------------------------

Thanks for the info, [~mvanwely]. I tried the following in the 4.9.0 RC and received no error,
so please let me know if you can repro it with that:
{code}
0: jdbc:phoenix:> CREATE TABLE IF NOT EXISTS FEEDS.FEED_COMPOSITION
. . . . . . . . > (
. . . . . . . . > ORGANIZATION_ID CHAR(15) NOT NULL,
. . . . . . . . > FEED_ELEMENT_ID CHAR(15) NOT NULL,
. . . . . . . . > CONTAINER_ID CHAR(15) NOT NULL,
. . . . . . . . > FEED_TYPE VARCHAR(1) NOT NULL, 
. . . . . . . . > NETWORK_ID CHAR(15) NOT NULL,
. . . . . . . . > USER_ID CHAR(15) NOT NULL,
. . . . . . . . > CREATED_TIME TIMESTAMP,
. . . . . . . . > LAST_UPDATE TIMESTAMP,
. . . . . . . . > RELEVANCE_SCORE DOUBLE,
. . . . . . . . > FEED_ITEM_TYPE VARCHAR(1), 
. . . . . . . . > FEED_ELEMENT_TYPE VARCHAR(1),
. . . . . . . . > FEED_ELEMENT_IS_SYS_GEN BOOLEAN,
. . . . . . . . > FEED_ELEMENT_STATUS VARCHAR(1),
. . . . . . . . > FEED_ELEMENT_VISIBILITY VARCHAR(1),
. . . . . . . . > PARENT_ID CHAR(15),
. . . . . . . . > CREATED_BY CHAR(15),
. . . . . . . . > BEST_COMMENT_ID CHAR(15),
. . . . . . . . > COMMENT_COUNT INTEGER,
. . . . . . . . > CONSTRAINT PK PRIMARY KEY
. . . . . . . . > (
. . . . . . . . > ORGANIZATION_ID,
. . . . . . . . > FEED_ELEMENT_ID,
. . . . . . . . > CONTAINER_ID,
. . . . . . . . > FEED_TYPE,
. . . . . . . . > NETWORK_ID,
. . . . . . . . > USER_ID
. . . . . . . . > )
. . . . . . . . > ) VERSIONS=1,MULTI_TENANT=TRUE,REPLICATION_SCOPE=1,TTL=31536000;
No rows affected (2.536 seconds)
0: jdbc:phoenix:> CREATE INDEX IF NOT EXISTS IE_FEED_COMPOSITION_LAST_UPDATE
. . . . . . . . > ON FEEDS.FEED_COMPOSITION (
. . . . . . . . > NETWORK_ID,
. . . . . . . . > CONTAINER_ID,
. . . . . . . . > FEED_TYPE,
. . . . . . . . > USER_ID,
. . . . . . . . > LAST_UPDATE DESC,
. . . . . . . . > FEED_ELEMENT_ID DESC
. . . . . . . . > ) INCLUDE (
. . . . . . . . > FEED_ITEM_TYPE,
. . . . . . . . > FEED_ELEMENT_TYPE,
. . . . . . . . > FEED_ELEMENT_IS_SYS_GEN,
. . . . . . . . > FEED_ELEMENT_STATUS,
. . . . . . . . > FEED_ELEMENT_VISIBILITY,
. . . . . . . . > PARENT_ID,
. . . . . . . . > CREATED_BY,
. . . . . . . . > BEST_COMMENT_ID,
. . . . . . . . > COMMENT_COUNT
. . . . . . . . > ) REPLICATION_SCOPE=1;
No rows affected (6.376 seconds)
0: jdbc:phoenix:> select * from FEEDS.FEED_COMPOSITION;
+------------------+------------------+---------------+------------+-------------+----------+---------------+--------------+------------------+-----------------+--------------------+----------------+
| ORGANIZATION_ID  | FEED_ELEMENT_ID  | CONTAINER_ID  | FEED_TYPE  | NETWORK_ID  | USER_ID
 | CREATED_TIME  | LAST_UPDATE  | RELEVANCE_SCORE  | FEED_ITEM_TYPE  | FEED_ELEMENT_TYPE 
| FEED_ELEMENT_I |
+------------------+------------------+---------------+------------+-------------+----------+---------------+--------------+------------------+-----------------+--------------------+----------------+
+------------------+------------------+---------------+------------+-------------+----------+---------------+--------------+------------------+-----------------+--------------------+----------------+
No rows selected (0.232 seconds)
0: jdbc:phoenix:> select count(1) from FEEDS.FEED_COMPOSITION;
+-----------+
| COUNT(1)  |
+-----------+
| 0         |
+-----------+
1 row selected (0.059 seconds)
{code}

> 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