hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lenni Kuff (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-10593) Support creating table from a file schema: CREATE TABLE ... LIKE <file_format> '/path/to/file'
Date Tue, 19 May 2015 23:50:00 GMT

    [ 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)

Mime
View raw message