[jira] [Created] (HIVE-10593) Support creating table from a file schema: CREATE TABLE ... LIKE '/path/to/file'

["Lenni Kuff (JIRA)" <ji...@apache.org>]

Lenni Kuff created HIVE-10593:
---------------------------------

             Summary: Support creating table from a file schema: CREATE TABLE ... LIKE <file_format> '/path/to/file'
                 Key: HIVE-10593
                 URL: https://issues.apache.org/jira/browse/HIVE-10593
             Project: Hive
          Issue Type: Improvement
          Components: Query Processor
    Affects Versions: 1.2.0
            Reporter: Lenni Kuff


It would be useful if Hive could infer the column definitions in a create table statement from the underlying data file. For example:

CREATE TABLE new_tbl LIKE PARQUET '/path/to/file.parquet';

If the targeted file is not the specified file format, the statement should fail analysis. In addition to PARQUET, it would be useful to support other formats such as AVRO, JSON, and ORC.









--
This message was sent by Atlassian JIRA
(v6.3.4#6332)