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

Venky Iyer commented on HIVE-1082:
----------------------------------

Talked to Prasad a little more about this:

1) The expectation is that the table that will exist after 'CREATE TABLE IF NOT 
EXISTS' is a combination of the specified schema + properties, plus the default 
properties when not specified. We should enforce this
2) Current code may break if we turn this on, so maybe we should have a CREATE 
TABLE IF NOT EXISTSWITHSCHEMA statement, or a strict mode of some sort.

> "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.

Reply via email to