[
https://issues.apache.org/jira/browse/DRILL-6518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16518715#comment-16518715
]
Khurram Faraaz commented on DRILL-6518:
---------------------------------------
SHOW TABLES; command does not return any results. Thanks Vlad for looking into
this.
{noformat}
[test@tqa1102-45 bin]# ./sqlline -u
"jdbc:drill:schema=dfs.tmp;drillbit=<IP-ADDRESS>"
apache drill 1.14.0-SNAPSHOT
"just drill it"
0: jdbc:drill:schema=dfs.tmp> show tables;
+---------------+-------------+
| TABLE_SCHEMA | TABLE_NAME |
+---------------+-------------+
+---------------+-------------+
No rows selected (0.296 seconds)
{noformat}
> DESCRIBE command on Drill created parquet table does not return results
> -----------------------------------------------------------------------
>
> Key: DRILL-6518
> URL: https://issues.apache.org/jira/browse/DRILL-6518
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Parquet
> Affects Versions: 1.14.0
> Reporter: Khurram Faraaz
> Priority: Major
> Attachments: 0_0_0.parquet, item.drill.parquet_metadata
>
>
> 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.
> {noformat}
> Apache Drill 1.14.0-SNAPSHOT
> commit : b447260e49dc4a8c906f5b310c037fe6dd77166f
> {noformat}
> {noformat}
> // 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)
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
