[
https://issues.apache.org/jira/browse/HIVE-10593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14551491#comment-14551491
]
Lenni Kuff commented on HIVE-10593:
-----------------------------------
Inferring the file type from the header type seems like a good idea. Do you
think we should avoid the 'file_format' keyword completely, or should it be an
optional "hint" which would fail the DDL op if the specified file does not
match the target format?
> 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)
