You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "benj (Jira)" <ji...@apache.org> on 2019/10/14 07:49:00 UTC
[jira] [Updated] (DRILL-7246) DESCRIBE on Parquet File
[ https://issues.apache.org/jira/browse/DRILL-7246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
benj updated DRILL-7246:
------------------------
Description:
It will be nice if it's possible to use DESCRIBE on Parquet File.
Example :
{code:sql}
DESCRIBE dfs.tmp.`test_parquet`;
+-------------------+-----------+-------------+
| COLUMN_NAME | DATA_TYPE | IS_NULLABLE |
+-------------------+-----------+-------------+
| MyColumn | INT | YES |
| AnotherColumn | DATE | NO |
| AdditionnalColumn | VARCHAR | YES |
+-------------------+-----------+-------------+
{code}
And more why not propose this possibility for any file (in the case of the CSV, DATA_TYPE will be VARCHAR and IS_NULLABLE YES) - if it's a little bit useless, this would at least list the available columns.
was:
It will be nice if it's possible to use DESCRIBE on Parquet File.
Example :
{code:sql}
DESCRIBE dfs.tmp.`test_parquet`;
+-------------------+-----------+-------------+
| COLUMN_NAME | DATA_TYPE | IS_NULLABLE |
+-------------------+-----------+-------------+
| MyColumn | INT | YES |
| AnotherColumn | DATE | NO |
| AdditionnalColumn | VARCHAR | YES | +-------------------+-----------+-------------+
{code}
And more why not propose this possibility for any file (in the case of the CSV, DATA_TYPE will be VARCHAR and IS_NULLABLE YES) - if it's a little bit useless, this would at least list the available columns.
> DESCRIBE on Parquet File
> ------------------------
>
> Key: DRILL-7246
> URL: https://issues.apache.org/jira/browse/DRILL-7246
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - Parquet
> Affects Versions: 1.16.0
> Reporter: benj
> Priority: Major
>
> It will be nice if it's possible to use DESCRIBE on Parquet File.
> Example :
> {code:sql}
> DESCRIBE dfs.tmp.`test_parquet`;
> +-------------------+-----------+-------------+
> | COLUMN_NAME | DATA_TYPE | IS_NULLABLE |
> +-------------------+-----------+-------------+
> | MyColumn | INT | YES |
> | AnotherColumn | DATE | NO |
> | AdditionnalColumn | VARCHAR | YES |
> +-------------------+-----------+-------------+
> {code}
> And more why not propose this possibility for any file (in the case of the CSV, DATA_TYPE will be VARCHAR and IS_NULLABLE YES) - if it's a little bit useless, this would at least list the available columns.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)