[jira] [Commented] (HIVE-18113) Remove mixed partitions/table schema support
[ https://issues.apache.org/jira/browse/HIVE-18113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16262114#comment-16262114 ] Zoltan Haindrich commented on HIVE-18113: - [~ashutoshc]: my intention was to change the "cascade" option into a permanently enabled feature - so the only thing changed is that a partitioned table's *all* partition agrees on the actual schema. I think that employing views to describe the schema changes could achieve the same goal with better transparency for the user ; and could even add extra flexibility (invoke sql functions/etc). > Remove mixed partitions/table schema support > > > Key: HIVE-18113 > URL: https://issues.apache.org/jira/browse/HIVE-18113 > Project: Hive > Issue Type: Sub-task >Reporter: Zoltan Haindrich >Assignee: Zoltan Haindrich > Attachments: HIVE-18113.01.patch > > > Currently it is possible to have misaligned table/partition schemas; > [see here for example| > https://github.com/apache/hive/blob/a5c2e15c7cc125d8cda2ee3a8ed64c116ff6b755/ql/src/test/queries/clientpositive/schema_evol_text_vec_part.q#L156] > result of [this insert > statement|https://github.com/apache/hive/blob/a5c2e15c7cc125d8cda2ee3a8ed64c116ff6b755/ql/src/test/queries/clientpositive/schema_evol_text_vec_part.q#L162] > are these [null > values|https://github.com/apache/hive/blob/a5c2e15c7cc125d8cda2ee3a8ed64c116ff6b755/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_part.q.out#L660] > This mixed partition setup can cause the stats aggregation to become quite > confusing...I think it would be better to remove this thingthere is a > {{CASCADE}} flag already; which changes the schema all over the > table/partitions/etc. -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (HIVE-18113) Remove mixed partitions/table schema support
[ https://issues.apache.org/jira/browse/HIVE-18113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16261282#comment-16261282 ] Ashutosh Chauhan commented on HIVE-18113: - I am not sure what you are proposing. From patch it seems like you are removing {{cascade}} support in alter statement, though description and title of jira convey differently. In any case, capability of table and partition having different schema is one of key features of Hive which we don't want to remove unless there is a strong justification for it. > Remove mixed partitions/table schema support > > > Key: HIVE-18113 > URL: https://issues.apache.org/jira/browse/HIVE-18113 > Project: Hive > Issue Type: Sub-task >Reporter: Zoltan Haindrich >Assignee: Zoltan Haindrich > Attachments: HIVE-18113.01.patch > > > Currently it is possible to have misaligned table/partition schemas; > [see here for example| > https://github.com/apache/hive/blob/a5c2e15c7cc125d8cda2ee3a8ed64c116ff6b755/ql/src/test/queries/clientpositive/schema_evol_text_vec_part.q#L156] > result of [this insert > statement|https://github.com/apache/hive/blob/a5c2e15c7cc125d8cda2ee3a8ed64c116ff6b755/ql/src/test/queries/clientpositive/schema_evol_text_vec_part.q#L162] > are these [null > values|https://github.com/apache/hive/blob/a5c2e15c7cc125d8cda2ee3a8ed64c116ff6b755/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_part.q.out#L660] > This mixed partition setup can cause the stats aggregation to become quite > confusing...I think it would be better to remove this thingthere is a > {{CASCADE}} flag already; which changes the schema all over the > table/partitions/etc. -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (HIVE-18113) Remove mixed partitions/table schema support
[ https://issues.apache.org/jira/browse/HIVE-18113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16261126#comment-16261126 ] Hive QA commented on HIVE-18113: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12898683/HIVE-18113.01.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 175 failed/errored test(s), 11388 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.org.apache.hadoop.hive.cli.TestCliDriver (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.org.apache.hadoop.hive.cli.TestCliDriver (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.org.apache.hadoop.hive.cli.TestCliDriver (batchId=9) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_merge_stats] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_numbuckets_partitioned_table2_h23] (batchId=14) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_numbuckets_partitioned_table_h23] (batchId=67) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_partition_change_col] (batchId=25) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_rename_partition_authorization] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_table_cascade] (batchId=86) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_table_column_stats] (batchId=63) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_table_serde2] (batchId=26) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[authorization_6] (batchId=45) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[authorization_explain] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[authorization_view_2] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[authorization_view_disable_cbo_3] (batchId=9) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[autoColumnStats_5] (batchId=41) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[auto_join11] (batchId=9) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[avro_comments] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[avro_date] (batchId=9) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[avro_partitioned] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ba_table3] (batchId=9) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[bucket_map_join_spark2] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[bucketmapjoin10] (batchId=50) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[bucketmapjoin11] (batchId=70) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[bucketmapjoin12] (batchId=34) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[bucketmapjoin13] (batchId=39) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[bucketmapjoin8] (batchId=12) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[bucketmapjoin9] (batchId=16) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[bucketsortoptimize_insert_1] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[compute_stats_decimal] (batchId=9) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[constGby] (batchId=9) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_like_view] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_or_replace_view] (batchId=38) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_with_constraints] (batchId=67) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cte_mat_5] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[database_drop] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dbtxnmgr_showlocks] (batchId=77) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[delete_whole_partition] (batchId=9) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[describe_table] (batchId=42) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[display_colstats_tbllvl] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[druid_basic1] (batchId=9) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[druid_basic3] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[druid_topn] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[equal_ns] (batchId=9) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[exim_04_evolved_parts] (batchId=30) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[extract] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[filter_cond_pushdown] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby2_limit] (batchId=9) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby4_noskew] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby7_noskew_multi_single_reducer]