Rahul Challapalli created DRILL-751:
---------------------------------------
Summary: INFORMATION_SCHEMA.TABLES shows the view as a table
Key: DRILL-751
URL: https://issues.apache.org/jira/browse/DRILL-751
Project: Apache Drill
Issue Type: Bug
Reporter: Rahul Challapalli
Priority: Minor
1. create view v1 as select * from `/drill/testdata/views/dfs/parquet/rankings`;
2. select * from INFORMATION_SCHEMA.`TABLES`; (shows the view as table)
+---------------+--------------+------------+------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE |
+---------------+--------------+------------+------------+
| DRILL | hive.test | t1 | TABLE |
| DRILL | dfs.drillTestDirViews | v1 | TABLE |
| DRILL | sys | drillbits | TABLE |
| DRILL | sys | options | TABLE |
| DRILL | INFORMATION_SCHEMA | VIEWS | TABLE |
| DRILL | INFORMATION_SCHEMA | COLUMNS | TABLE |
| DRILL | INFORMATION_SCHEMA | TABLES | TABLE |
| DRILL | INFORMATION_SCHEMA | CATALOGS | TABLE |
| DRILL | INFORMATION_SCHEMA | SCHEMATA | TABLE |
+---------------+--------------+------------+------------+
--
This message was sent by Atlassian JIRA
(v6.2#6252)
