phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Akshita Malhotra (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-3475) MetaData #getTables() API doesn't return view indexes
Date Thu, 10 Nov 2016 22:02:58 GMT
Akshita Malhotra created PHOENIX-3475:
-----------------------------------------

             Summary: MetaData #getTables() API doesn't return view indexes
                 Key: PHOENIX-3475
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3475
             Project: Phoenix
          Issue Type: Bug
            Reporter: Akshita Malhotra
             Fix For: 4.9.0


HBase migration tool uses DatabaseMetadata#getTables() API to retrieve the tables for copying
data. We have found that API doesn't return base index tables ( _IDX_<base table name>)

For testing purposes, we issue following DDL to generate the view and the corresponding view
index:
-CREATE VIEW IF NOT EXISTS MIGRATIONTEST_VIEW (OLD_VALUE_VIEW varchar) AS SELECT * FROM MIGRATIONTEST
WHERE OLD_VALUE like 'E%'
-CREATE INDEX IF NOT EXISTS MIGRATIONTEST_VIEW_IDX ON MIGRATIONTEST_VIEW (OLD_VALUE_VIEW)

By using HBase API, we were able to confirm that base index table (_IDX_MIGRATIONTEST) is
created. 

Both jdbc  DatabaseMetadata API and P* getMetaDataCache API doesn't seem to be returning view
indexes. Also P*MetaData #getTableRef API return "TableNotFoundException" when attempted to
fetch PTable corresponding to the base index table name.





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

Mime
View raw message