[PHOENIX-3419] phoenix client (sqlline) adds a duplicate table schema to the query

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved

Environment

HBase 0.98.20

• Assignee: Unassigned
• Reporter: Saurabh
• Created: 27/Oct/16 17:31
• Updated: 04/Nov/16 19:25

Description

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)