[
https://issues.apache.org/jira/browse/DRILL-7247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
benj updated DRILL-7247:
------------------------
Description:
It would be usefull to be able to use the result of a DESCRIBE command like a
SELECT.
Examples:
{code:sql}
CREATE TABLE dfs.tmp.`outputTable.csv` AS (DESCRIBE dfs.tmp.`test`);
{code}
{code:sql}
SELECT `COLUMN_NAME`
FROM (DESCRIBE dfs.tmp.`test`)
WHERE `DATA_TYPE` LIKE '%INT%';
{code}
was:
It would be usefull to be able to use the result of a DESCRIBE command like a
SELECT.
Examples:
{code:sql}
CREATE TABLE dfs.tmp.`outputTable` AS (DESCRIBE dfs.tmp.`test`);
{code}
{code:sql}
SELECT `COLUMN_NAME`
FROM (DESCRIBE dfs.tmp.`test`)
WHERE `DATA_TYPE` LIKE '%INT%';
{code}
> Use result of DESCRIBE as a SELECT
> ----------------------------------
>
> Key: DRILL-7247
> URL: https://issues.apache.org/jira/browse/DRILL-7247
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - Information Schema
> Affects Versions: 1.16.0
> Reporter: benj
> Priority: Major
>
> It would be usefull to be able to use the result of a DESCRIBE command like a
> SELECT.
> Examples:
> {code:sql}
> CREATE TABLE dfs.tmp.`outputTable.csv` AS (DESCRIBE dfs.tmp.`test`);
> {code}
> {code:sql}
> SELECT `COLUMN_NAME`
> FROM (DESCRIBE dfs.tmp.`test`)
> WHERE `DATA_TYPE` LIKE '%INT%';
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
