[ 
https://issues.apache.org/jira/browse/DRILL-7357?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Arina Ielchiieva updated DRILL-7357:
------------------------------------
    Description: 
Document:
https://docs.google.com/document/d/10CkLdrlUJUNRrHKLeo8jTUJB8xAP1D0byTOvn8wNoF0/edit#heading=h.gzj2dj5a4yds
Sections: 
5.19 INFORMATION_SCHEMA updates
4.3.2 Using the statistics

information_schema tables will contain data from Metastore only if 
{{metastore.enabled}} is set to true.

This Jira will add additional columns to TABLES and COLUMNS tables and new 
PARTITIONS table.
Additional columns
TABLES:
TABLE_SOURCE
LOCATION
NUM_ROWS
LAST_MODIFIED_TIME

COLUMNS:
COLUMN_SIZE (already existed but was not included)
COLUMN_FORMAT
NUM_NULLS
MIN_VAL
MAX_VAL
NDV
EST_NUM_NON_NULLS
IS_NESTED

PARTITIONS table columns:
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
METADATA_KEY
METADATA_TYPE
METADATA_IDENTIFIER
PARTITION_COLUMN
PARTITION_VALUE
LOCATION
LAST_MODIFIED_TIME



  was:
Document:
https://docs.google.com/document/d/10CkLdrlUJUNRrHKLeo8jTUJB8xAP1D0byTOvn8wNoF0/edit#heading=h.gzj2dj5a4yds
Sections: 
5.19 INFORMATION_SCHEMA updates
4.3.2 Using the statistics

information_schema tables will contain data from Metastore only if 
{{metastore.enabled}} is set to true.



> Expose Drill Metastore data through INFORMATION_SCHEMA
> ------------------------------------------------------
>
>                 Key: DRILL-7357
>                 URL: https://issues.apache.org/jira/browse/DRILL-7357
>             Project: Apache Drill
>          Issue Type: Sub-task
>            Reporter: Arina Ielchiieva
>            Assignee: Arina Ielchiieva
>            Priority: Major
>             Fix For: 1.17.0
>
>
> Document:
> https://docs.google.com/document/d/10CkLdrlUJUNRrHKLeo8jTUJB8xAP1D0byTOvn8wNoF0/edit#heading=h.gzj2dj5a4yds
> Sections: 
> 5.19 INFORMATION_SCHEMA updates
> 4.3.2 Using the statistics
> information_schema tables will contain data from Metastore only if 
> {{metastore.enabled}} is set to true.
> This Jira will add additional columns to TABLES and COLUMNS tables and new 
> PARTITIONS table.
> Additional columns
> TABLES:
> TABLE_SOURCE
> LOCATION
> NUM_ROWS
> LAST_MODIFIED_TIME
> COLUMNS:
> COLUMN_SIZE (already existed but was not included)
> COLUMN_FORMAT
> NUM_NULLS
> MIN_VAL
> MAX_VAL
> NDV
> EST_NUM_NON_NULLS
> IS_NESTED
> PARTITIONS table columns:
> TABLE_CATALOG
> TABLE_SCHEMA
> TABLE_NAME
> METADATA_KEY
> METADATA_TYPE
> METADATA_IDENTIFIER
> PARTITION_COLUMN
> PARTITION_VALUE
> LOCATION
> LAST_MODIFIED_TIME



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to