You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "benj (JIRA)" <ji...@apache.org> on 2019/05/09 12:43:00 UTC

[jira] [Created] (DRILL-7247) Use result of DESCRIBE as a SELECT

benj created DRILL-7247:
---------------------------

             Summary: 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


It would be usefull to be able to use the result of a DESCRIBE command like a SELECT.

Examples:
{code:sql}
CREATE TABLE 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)