Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-2932

SQuirrel SQL Client could not list VIEWS created by Phoenix SQL

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 4.7.0
    • None
    • None
    • Oracle JDK 1.8, Phoenix4.7, SQuirrel 3.7.1, HBase 1.1.2, CentOS7

    Description

      SQuirrel SQL Client could not list VIEWS created by Phoenix SQL
      Steps:
      1, Create table and views using SQL;
      CREATE TABLE TESTTABLE111 (PK VARCHAR NOT NULL PRIMARY KEY, CF1.COL1 VARCHAR)
      UPSERT INTO TESTTABLE111 VALUES ('KEY1','VAL1')
      CREATE VIEW TESTVIEW111 AS SELECT * FROM TESTTABLE111
      SELECT * FROM TESTVIEW111
      2, In SQuirrel Objects pannel, could not list out the created VIEWS.

      Attachments

        Activity

          People

            Unassigned Unassigned
            jasonchio Jason Chio
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: