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

["Venky Iyer (JIRA)" <ji...@apache.org>]

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