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