Hive
  1. Hive
  2. HIVE-3649

Hive List Bucketing - enhance DDL to specify list bucketing table

    Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.10.0
    • Fix Version/s: 0.10.0
    • Component/s: None
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      We need to differ normal skewed table from list bucketing table. we use an optional parameter "store as DIRECTORIES"

      4 main cases:
      1. create table <name> skewed by .. on .. stored as directories;
      2. alter table <name> skewed by .. on .. stored as directories;
      3. alter table <name> not skewed;
      4. alter table <name> not stored as directories;

      details in https://cwiki.apache.org/confluence/display/Hive/ListBucketing

      1. HIVE-3649.patch.4
        79 kB
        Gang Tim Liu
      2. HIVE-3649.patch.6
        77 kB
        Gang Tim Liu
      3. HIVE-3649.patch.7
        75 kB
        Gang Tim Liu
      4. HIVE-3649.patch.8
        78 kB
        Gang Tim Liu
      5. HIVE-3649.patch.9
        112 kB
        Gang Tim Liu

        Issue Links

          Activity

          Hide
          Gang Tim Liu added a comment -
          Show
          Gang Tim Liu added a comment - patch is available. https://reviews.facebook.net/D6543
          Hide
          Namit Jain added a comment -

          comments

          Show
          Namit Jain added a comment - comments
          Hide
          Gang Tim Liu added a comment -

          Patch is available.

          Show
          Gang Tim Liu added a comment - Patch is available.
          Hide
          Namit Jain added a comment -

          minor comments

          Show
          Namit Jain added a comment - minor comments
          Hide
          Gang Tim Liu added a comment -

          Yes, address comments. patch available. thanks

          Show
          Gang Tim Liu added a comment - Yes, address comments. patch available. thanks
          Hide
          Namit Jain added a comment -

          +1

          Show
          Namit Jain added a comment - +1
          Hide
          Namit Jain added a comment -

          Gang Tim Liu, can you refresh ? This may conflict due to the thrift upgrade.

          Show
          Namit Jain added a comment - Gang Tim Liu , can you refresh ? This may conflict due to the thrift upgrade.
          Hide
          Gang Tim Liu added a comment -

          Yes, doing it. thanks

          Show
          Gang Tim Liu added a comment - Yes, doing it. thanks
          Hide
          Gang Tim Liu added a comment -

          patch available.

          Show
          Gang Tim Liu added a comment - patch available.
          Hide
          Namit Jain added a comment -

          Running tests again.

          Show
          Namit Jain added a comment - Running tests again.
          Hide
          Namit Jain added a comment -

          Committed. Thanks Tim

          Show
          Namit Jain added a comment - Committed. Thanks Tim
          Hide
          Gang Tim Liu added a comment -

          Namit thanks a lot

          Sent from my iPhone

          Show
          Gang Tim Liu added a comment - Namit thanks a lot Sent from my iPhone
          Hide
          Hudson added a comment -

          Integrated in Hive-trunk-h0.21 #1785 (See https://builds.apache.org/job/Hive-trunk-h0.21/1785/)
          HIVE-3649 Hive List Bucketing - enhance DDL to specify list bucketing table
          (Gang Tim Liu via namit) (Revision 1407353)

          Result = FAILURE
          namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1407353
          Files :

          • /hive/trunk/metastore/if/hive_metastore.thrift
          • /hive/trunk/metastore/scripts/upgrade/derby/010-HIVE-3649.derby.sql
          • /hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.10.0.derby.sql
          • /hive/trunk/metastore/scripts/upgrade/derby/upgrade-0.9.0-to-0.10.0.derby.sql
          • /hive/trunk/metastore/scripts/upgrade/mysql/010-HIVE-3649.mysql.sql
          • /hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.10.0.mysql.sql
          • /hive/trunk/metastore/scripts/upgrade/mysql/upgrade-0.9.0-to-0.10.0.mysql.sql
          • /hive/trunk/metastore/scripts/upgrade/oracle/010-HIVE-3649.oracle.sql
          • /hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql
          • /hive/trunk/metastore/scripts/upgrade/postgres/010-HIVE-3649.postgres.sql
          • /hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql
          • /hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.9.0-to-0.10.0.postgres.sql
          • /hive/trunk/metastore/src/gen/thrift/gen-cpp/hive_metastore_types.cpp
          • /hive/trunk/metastore/src/gen/thrift/gen-cpp/hive_metastore_types.h
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Database.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/EnvironmentContext.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Index.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Partition.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/PrincipalPrivilegeSet.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Schema.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/SerDeInfo.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/SkewedInfo.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/StorageDescriptor.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/ThriftHiveMetastore.java
          • /hive/trunk/metastore/src/gen/thrift/gen-php/hive_metastore/hive_metastore_types.php
          • /hive/trunk/metastore/src/gen/thrift/gen-php/metastore/Types.php
          • /hive/trunk/metastore/src/gen/thrift/gen-py/hive_metastore/ttypes.py
          • /hive/trunk/metastore/src/gen/thrift/gen-rb/hive_metastore_types.rb
          • /hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java
          • /hive/trunk/metastore/src/model/org/apache/hadoop/hive/metastore/model/MStorageDescriptor.java
          • /hive/trunk/metastore/src/model/package.jdo
          • /hive/trunk/metastore/src/test/org/apache/hadoop/hive/metastore/TestHiveMetaStore.java
          • /hive/trunk/ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Operator.java
          • /hive/trunk/ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Query.java
          • /hive/trunk/ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Stage.java
          • /hive/trunk/ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Task.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/ErrorMsg.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/Table.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/MetaDataFormatUtils.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/ImportSemanticAnalyzer.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/LoadSemanticAnalyzer.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/AlterTableDesc.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/CreateTableDesc.java
          • /hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/QTestUtil.java
          • /hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/metadata/TestHive.java
          • /hive/trunk/ql/src/test/queries/clientnegative/load_stored_as_dirs.q
          • /hive/trunk/ql/src/test/queries/clientpositive/create_alter_list_bucketing_table1.q
          • /hive/trunk/ql/src/test/results/clientnegative/load_stored_as_dirs.q.out
          • /hive/trunk/ql/src/test/results/clientpositive/create_alter_list_bucketing_table1.q.out
          • /hive/trunk/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/Complex.java
          • /hive/trunk/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/MegaStruct.java
          Show
          Hudson added a comment - Integrated in Hive-trunk-h0.21 #1785 (See https://builds.apache.org/job/Hive-trunk-h0.21/1785/ ) HIVE-3649 Hive List Bucketing - enhance DDL to specify list bucketing table (Gang Tim Liu via namit) (Revision 1407353) Result = FAILURE namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1407353 Files : /hive/trunk/metastore/if/hive_metastore.thrift /hive/trunk/metastore/scripts/upgrade/derby/010- HIVE-3649 .derby.sql /hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.10.0.derby.sql /hive/trunk/metastore/scripts/upgrade/derby/upgrade-0.9.0-to-0.10.0.derby.sql /hive/trunk/metastore/scripts/upgrade/mysql/010- HIVE-3649 .mysql.sql /hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.10.0.mysql.sql /hive/trunk/metastore/scripts/upgrade/mysql/upgrade-0.9.0-to-0.10.0.mysql.sql /hive/trunk/metastore/scripts/upgrade/oracle/010- HIVE-3649 .oracle.sql /hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql /hive/trunk/metastore/scripts/upgrade/postgres/010- HIVE-3649 .postgres.sql /hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql /hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.9.0-to-0.10.0.postgres.sql /hive/trunk/metastore/src/gen/thrift/gen-cpp/hive_metastore_types.cpp /hive/trunk/metastore/src/gen/thrift/gen-cpp/hive_metastore_types.h /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Database.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/EnvironmentContext.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Index.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Partition.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/PrincipalPrivilegeSet.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Schema.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/SerDeInfo.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/SkewedInfo.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/StorageDescriptor.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/ThriftHiveMetastore.java /hive/trunk/metastore/src/gen/thrift/gen-php/hive_metastore/hive_metastore_types.php /hive/trunk/metastore/src/gen/thrift/gen-php/metastore/Types.php /hive/trunk/metastore/src/gen/thrift/gen-py/hive_metastore/ttypes.py /hive/trunk/metastore/src/gen/thrift/gen-rb/hive_metastore_types.rb /hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java /hive/trunk/metastore/src/model/org/apache/hadoop/hive/metastore/model/MStorageDescriptor.java /hive/trunk/metastore/src/model/package.jdo /hive/trunk/metastore/src/test/org/apache/hadoop/hive/metastore/TestHiveMetaStore.java /hive/trunk/ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Operator.java /hive/trunk/ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Query.java /hive/trunk/ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Stage.java /hive/trunk/ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Task.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/ErrorMsg.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/Table.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/MetaDataFormatUtils.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/ImportSemanticAnalyzer.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/LoadSemanticAnalyzer.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/AlterTableDesc.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/CreateTableDesc.java /hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/QTestUtil.java /hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/metadata/TestHive.java /hive/trunk/ql/src/test/queries/clientnegative/load_stored_as_dirs.q /hive/trunk/ql/src/test/queries/clientpositive/create_alter_list_bucketing_table1.q /hive/trunk/ql/src/test/results/clientnegative/load_stored_as_dirs.q.out /hive/trunk/ql/src/test/results/clientpositive/create_alter_list_bucketing_table1.q.out /hive/trunk/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/Complex.java /hive/trunk/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/MegaStruct.java
          Hide
          Hudson added a comment -

          Integrated in Hive-trunk-hadoop2 #54 (See https://builds.apache.org/job/Hive-trunk-hadoop2/54/)
          HIVE-3649 Hive List Bucketing - enhance DDL to specify list bucketing table
          (Gang Tim Liu via namit) (Revision 1407353)

          Result = ABORTED
          namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1407353
          Files :

          • /hive/trunk/metastore/if/hive_metastore.thrift
          • /hive/trunk/metastore/scripts/upgrade/derby/010-HIVE-3649.derby.sql
          • /hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.10.0.derby.sql
          • /hive/trunk/metastore/scripts/upgrade/derby/upgrade-0.9.0-to-0.10.0.derby.sql
          • /hive/trunk/metastore/scripts/upgrade/mysql/010-HIVE-3649.mysql.sql
          • /hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.10.0.mysql.sql
          • /hive/trunk/metastore/scripts/upgrade/mysql/upgrade-0.9.0-to-0.10.0.mysql.sql
          • /hive/trunk/metastore/scripts/upgrade/oracle/010-HIVE-3649.oracle.sql
          • /hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql
          • /hive/trunk/metastore/scripts/upgrade/postgres/010-HIVE-3649.postgres.sql
          • /hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql
          • /hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.9.0-to-0.10.0.postgres.sql
          • /hive/trunk/metastore/src/gen/thrift/gen-cpp/hive_metastore_types.cpp
          • /hive/trunk/metastore/src/gen/thrift/gen-cpp/hive_metastore_types.h
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Database.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/EnvironmentContext.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Index.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Partition.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/PrincipalPrivilegeSet.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Schema.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/SerDeInfo.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/SkewedInfo.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/StorageDescriptor.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java
          • /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/ThriftHiveMetastore.java
          • /hive/trunk/metastore/src/gen/thrift/gen-php/hive_metastore/hive_metastore_types.php
          • /hive/trunk/metastore/src/gen/thrift/gen-php/metastore/Types.php
          • /hive/trunk/metastore/src/gen/thrift/gen-py/hive_metastore/ttypes.py
          • /hive/trunk/metastore/src/gen/thrift/gen-rb/hive_metastore_types.rb
          • /hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java
          • /hive/trunk/metastore/src/model/org/apache/hadoop/hive/metastore/model/MStorageDescriptor.java
          • /hive/trunk/metastore/src/model/package.jdo
          • /hive/trunk/metastore/src/test/org/apache/hadoop/hive/metastore/TestHiveMetaStore.java
          • /hive/trunk/ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Operator.java
          • /hive/trunk/ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Query.java
          • /hive/trunk/ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Stage.java
          • /hive/trunk/ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Task.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/ErrorMsg.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/Table.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/MetaDataFormatUtils.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/ImportSemanticAnalyzer.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/LoadSemanticAnalyzer.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/AlterTableDesc.java
          • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/CreateTableDesc.java
          • /hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/QTestUtil.java
          • /hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/metadata/TestHive.java
          • /hive/trunk/ql/src/test/queries/clientnegative/load_stored_as_dirs.q
          • /hive/trunk/ql/src/test/queries/clientpositive/create_alter_list_bucketing_table1.q
          • /hive/trunk/ql/src/test/results/clientnegative/load_stored_as_dirs.q.out
          • /hive/trunk/ql/src/test/results/clientpositive/create_alter_list_bucketing_table1.q.out
          • /hive/trunk/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/Complex.java
          • /hive/trunk/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/MegaStruct.java
          Show
          Hudson added a comment - Integrated in Hive-trunk-hadoop2 #54 (See https://builds.apache.org/job/Hive-trunk-hadoop2/54/ ) HIVE-3649 Hive List Bucketing - enhance DDL to specify list bucketing table (Gang Tim Liu via namit) (Revision 1407353) Result = ABORTED namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1407353 Files : /hive/trunk/metastore/if/hive_metastore.thrift /hive/trunk/metastore/scripts/upgrade/derby/010- HIVE-3649 .derby.sql /hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.10.0.derby.sql /hive/trunk/metastore/scripts/upgrade/derby/upgrade-0.9.0-to-0.10.0.derby.sql /hive/trunk/metastore/scripts/upgrade/mysql/010- HIVE-3649 .mysql.sql /hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.10.0.mysql.sql /hive/trunk/metastore/scripts/upgrade/mysql/upgrade-0.9.0-to-0.10.0.mysql.sql /hive/trunk/metastore/scripts/upgrade/oracle/010- HIVE-3649 .oracle.sql /hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql /hive/trunk/metastore/scripts/upgrade/postgres/010- HIVE-3649 .postgres.sql /hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql /hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.9.0-to-0.10.0.postgres.sql /hive/trunk/metastore/src/gen/thrift/gen-cpp/hive_metastore_types.cpp /hive/trunk/metastore/src/gen/thrift/gen-cpp/hive_metastore_types.h /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Database.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/EnvironmentContext.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Index.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Partition.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/PrincipalPrivilegeSet.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Schema.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/SerDeInfo.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/SkewedInfo.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/StorageDescriptor.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java /hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/ThriftHiveMetastore.java /hive/trunk/metastore/src/gen/thrift/gen-php/hive_metastore/hive_metastore_types.php /hive/trunk/metastore/src/gen/thrift/gen-php/metastore/Types.php /hive/trunk/metastore/src/gen/thrift/gen-py/hive_metastore/ttypes.py /hive/trunk/metastore/src/gen/thrift/gen-rb/hive_metastore_types.rb /hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java /hive/trunk/metastore/src/model/org/apache/hadoop/hive/metastore/model/MStorageDescriptor.java /hive/trunk/metastore/src/model/package.jdo /hive/trunk/metastore/src/test/org/apache/hadoop/hive/metastore/TestHiveMetaStore.java /hive/trunk/ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Operator.java /hive/trunk/ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Query.java /hive/trunk/ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Stage.java /hive/trunk/ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Task.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/ErrorMsg.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/Table.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/MetaDataFormatUtils.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/ImportSemanticAnalyzer.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/LoadSemanticAnalyzer.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/AlterTableDesc.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/CreateTableDesc.java /hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/QTestUtil.java /hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/metadata/TestHive.java /hive/trunk/ql/src/test/queries/clientnegative/load_stored_as_dirs.q /hive/trunk/ql/src/test/queries/clientpositive/create_alter_list_bucketing_table1.q /hive/trunk/ql/src/test/results/clientnegative/load_stored_as_dirs.q.out /hive/trunk/ql/src/test/results/clientpositive/create_alter_list_bucketing_table1.q.out /hive/trunk/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/Complex.java /hive/trunk/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/MegaStruct.java
          Hide
          Ashutosh Chauhan added a comment -

          This issue is fixed and released as part of 0.10.0 release. If you find an issue which seems to be related to this one, please create a new jira and link this one with new jira.

          Show
          Ashutosh Chauhan added a comment - This issue is fixed and released as part of 0.10.0 release. If you find an issue which seems to be related to this one, please create a new jira and link this one with new jira.
          Hide
          Lefty Leverenz added a comment -

          Doc note and question: I added the ALTER TABLE syntax to the DDL wikidoc (please review) but don't know what to document about CONCATENATE, which is mentioned in the design doc. The CREATE TABLE syntax was already documented.

          So does ALTER TABLE ... CONCATENATE need any doc?

          Show
          Lefty Leverenz added a comment - Doc note and question: I added the ALTER TABLE syntax to the DDL wikidoc (please review) but don't know what to document about CONCATENATE, which is mentioned in the design doc. The CREATE TABLE syntax was already documented. DDL – Alter Table Skewed or Stored as Directories List Bucketing – Design : "When such a table is being loaded, it would be good to create a sub-directory per skewed key. The infrastructure similar to dynamic partitions can be used." DDL – AlterTable/Partition Concatenate DDL – Create Table (syntax) DDL – Create Table – Skewed Tables So does ALTER TABLE ... CONCATENATE need any doc?

            People

            • Assignee:
              Gang Tim Liu
              Reporter:
              Gang Tim Liu
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development