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