[jira] [Created] (DRILL-7610) Allow user to specify table schema in Metastore

["Paul Rogers (Jira)" <ji...@apache.org>]

Paul Rogers created DRILL-7610:
----------------------------------

             Summary: Allow user to specify table schema in Metastore
                 Key: DRILL-7610
                 URL: https://issues.apache.org/jira/browse/DRILL-7610
             Project: Apache Drill
          Issue Type: Improvement
    Affects Versions: 1.17.0
            Reporter: Paul Rogers


The Drill Metastore will infer the schema of a table while gathering stats. Unfortunately, this creates a chicken-and-egg problem. Some files need the Metastore because the schema is ambiguous. Such data won't even scan correctly without such information. Classic JSON example:

{code:json}
{a: 10} {a: 10.1}
{code}

In these cases, the user should first define the table schema, then run the {{ANALYZE TABLE}} commands. In such cases, Drill should not attempt to change the type information (since the actual data is ambiguous.)




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