[ https://issues.apache.org/jira/browse/HIVE-1082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12804860#action_12804860 ]
Venky Iyer commented on HIVE-1082: ---------------------------------- What I want is to create a table if the table doesn't exist already. If it does exist, I want Hive to verify that its schema is identical to the schema I've specified. Basically, at the end of a successful statement, the schema in Hive should be exactly what I specified in the last CREATE TABLE IF NOT EXISTS statement. > "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.