[DRILL-6518] DESCRIBE command on Drill created parquet table does not return results

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.14.0
• Fix Version/s: Future
• Component/s: Storage - Parquet
• Assignee: Unassigned
• Reporter: Khurram Faraaz
• Created: 20/Jun/18 20:42
• Updated: 15/Jan/19 07:22

Description

Describe command on a Drill (1.14.0) created parquet table, does not return the table description.
Parquet file and parquet metadata cache file for item table is attached here, it has the details of column types in the metadata cache file.

Apache Drill 1.14.0-SNAPSHOT 
commit : b447260e49dc4a8c906f5b310c037fe6dd77166f

// DESCRIBE commands returns no information about the table.


0: jdbc:drill:schema=dfs.tpcds_sf1_parquet_vi> describe dfs.`/drill/testdata/tpcds_sf1/parquet/item`;
+--------------+------------+--------------+
| COLUMN_NAME | DATA_TYPE | IS_NULLABLE |
+--------------+------------+--------------+
+--------------+------------+--------------+
No rows selected (0.221 seconds)
0: jdbc:drill:schema=dfs.tpcds_sf1_parquet_vi> refresh table metadata dfs.`/drill/testdata/tpcds_sf1/parquet/item`;
+-------+----------------------------------------------------------------------------------+
| ok | summary |
+-------+----------------------------------------------------------------------------------+
| true | Successfully updated metadata for table /drill/testdata/tpcds_sf1/parquet/item. |
+-------+----------------------------------------------------------------------------------+
1 row selected (0.173 seconds)
0: jdbc:drill:schema=dfs.tpcds_sf1_parquet_vi> describe dfs.`/drill/testdata/tpcds_sf1/parquet/item`;
+--------------+------------+--------------+
| COLUMN_NAME | DATA_TYPE | IS_NULLABLE |
+--------------+------------+--------------+
+--------------+------------+--------------+
No rows selected (0.229 seconds)