hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ning Zhang (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-1082) "create table if not exists " should check if the specified schema matches the existing schema, and throw an error if it doesnt.
Date Mon, 25 Jan 2010 21:55:34 GMT

    [ https://issues.apache.org/jira/browse/HIVE-1082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12804744#action_12804744
] 

Ning Zhang commented on HIVE-1082:
----------------------------------

@venky, I am a little bit confused about the requirement. Do you mean we should allow the
following situation: Table T(a int, b string) and table T (a int, b string, c string) exist
in the same database? If so, what is the semantics of 'select a, b from T;'?

> "create table if not exists " should check if the specified  schema matches the existing
schema, and throw an error if it doesnt.  
> -----------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-1082
>                 URL: https://issues.apache.org/jira/browse/HIVE-1082
>             Project: Hadoop Hive
>          Issue Type: Bug
>            Reporter: Venky Iyer
>
> I think we should make sure that the table can either be created anew with the specified
properties, or it already exists with those properties, where 'properties' includes all metadata
except timestamps. Anything else is an error. This makes sense if you think of a table as
the name  + its schema, instead of the name alone. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message