[
https://issues.apache.org/jira/browse/HIVE-10593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14550725#comment-14550725
]
Ryan Blue commented on HIVE-10593:
----------------------------------
+1 to file only. Merging file schemas is way out of scope.
I like the syntax, though it would be nice if we could detect the file type in
most cases by magic bytes. Avro and Parquet work that way, so we could have a
map of magic -> format. Anything else, like delimited text, doesn't work with
this feature anyway.
> 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)
