Hive
  1. Hive
  2. HIVE-2909

SHOW COLUMNS table_name; to provide a comma-delimited list of columns.

    Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.10.0
    • Component/s: None
    • Labels:
      None

      Description

      Due to the way that SELECT * and partitioning works, it is frequently obnoxious to insert data into tables of the same schema.

      This could be fixed in a number of ways, all murky; this feature request reduces the obnoxicity of the current situation.

      SHOW COLUMNS foo;
      OK
      bar, baz, tball, ds

      ...then I could just copy the first three and not the last.

        Activity

        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
        Hudson added a comment -

        Integrated in Hive-trunk-hadoop2 #54 (See https://builds.apache.org/job/Hive-trunk-hadoop2/54/)
        HIVE-2909. SHOW COLUMNS table_name; to provide a comma-delimited list of columns. (njain via kevinwilfong) (Revision 1365222)

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

        • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.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/SemanticAnalyzerFactory.java
        • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/DDLWork.java
        • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/HiveOperation.java
        • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/ShowColumnsDesc.java
        • /hive/trunk/ql/src/test/queries/clientnegative/show_columns1.q
        • /hive/trunk/ql/src/test/queries/clientnegative/show_columns2.q
        • /hive/trunk/ql/src/test/queries/clientnegative/show_columns3.q
        • /hive/trunk/ql/src/test/queries/clientpositive/show_columns.q
        • /hive/trunk/ql/src/test/results/clientnegative/show_columns1.q.out
        • /hive/trunk/ql/src/test/results/clientnegative/show_columns2.q.out
        • /hive/trunk/ql/src/test/results/clientnegative/show_columns3.q.out
        • /hive/trunk/ql/src/test/results/clientpositive/show_columns.q.out
        Show
        Hudson added a comment - Integrated in Hive-trunk-hadoop2 #54 (See https://builds.apache.org/job/Hive-trunk-hadoop2/54/ ) HIVE-2909 . SHOW COLUMNS table_name; to provide a comma-delimited list of columns. (njain via kevinwilfong) (Revision 1365222) Result = ABORTED kevinwilfong : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1365222 Files : /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.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/SemanticAnalyzerFactory.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/DDLWork.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/HiveOperation.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/ShowColumnsDesc.java /hive/trunk/ql/src/test/queries/clientnegative/show_columns1.q /hive/trunk/ql/src/test/queries/clientnegative/show_columns2.q /hive/trunk/ql/src/test/queries/clientnegative/show_columns3.q /hive/trunk/ql/src/test/queries/clientpositive/show_columns.q /hive/trunk/ql/src/test/results/clientnegative/show_columns1.q.out /hive/trunk/ql/src/test/results/clientnegative/show_columns2.q.out /hive/trunk/ql/src/test/results/clientnegative/show_columns3.q.out /hive/trunk/ql/src/test/results/clientpositive/show_columns.q.out
        Hide
        Hudson added a comment -

        Integrated in Hive-trunk-h0.21 #1565 (See https://builds.apache.org/job/Hive-trunk-h0.21/1565/)
        HIVE-2909. SHOW COLUMNS table_name; to provide a comma-delimited list of columns. (njain via kevinwilfong) (Revision 1365222)

        Result = SUCCESS
        kevinwilfong : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1365222
        Files :

        • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.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/SemanticAnalyzerFactory.java
        • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/DDLWork.java
        • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/HiveOperation.java
        • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/ShowColumnsDesc.java
        • /hive/trunk/ql/src/test/queries/clientnegative/show_columns1.q
        • /hive/trunk/ql/src/test/queries/clientnegative/show_columns2.q
        • /hive/trunk/ql/src/test/queries/clientnegative/show_columns3.q
        • /hive/trunk/ql/src/test/queries/clientpositive/show_columns.q
        • /hive/trunk/ql/src/test/results/clientnegative/show_columns1.q.out
        • /hive/trunk/ql/src/test/results/clientnegative/show_columns2.q.out
        • /hive/trunk/ql/src/test/results/clientnegative/show_columns3.q.out
        • /hive/trunk/ql/src/test/results/clientpositive/show_columns.q.out
        Show
        Hudson added a comment - Integrated in Hive-trunk-h0.21 #1565 (See https://builds.apache.org/job/Hive-trunk-h0.21/1565/ ) HIVE-2909 . SHOW COLUMNS table_name; to provide a comma-delimited list of columns. (njain via kevinwilfong) (Revision 1365222) Result = SUCCESS kevinwilfong : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1365222 Files : /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.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/SemanticAnalyzerFactory.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/DDLWork.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/HiveOperation.java /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/ShowColumnsDesc.java /hive/trunk/ql/src/test/queries/clientnegative/show_columns1.q /hive/trunk/ql/src/test/queries/clientnegative/show_columns2.q /hive/trunk/ql/src/test/queries/clientnegative/show_columns3.q /hive/trunk/ql/src/test/queries/clientpositive/show_columns.q /hive/trunk/ql/src/test/results/clientnegative/show_columns1.q.out /hive/trunk/ql/src/test/results/clientnegative/show_columns2.q.out /hive/trunk/ql/src/test/results/clientnegative/show_columns3.q.out /hive/trunk/ql/src/test/results/clientpositive/show_columns.q.out
        Hide
        Kevin Wilfong added a comment -

        Committed, thanks Namit.

        Show
        Kevin Wilfong added a comment - Committed, thanks Namit.
        Hide
        Kevin Wilfong added a comment -

        It looks like you've responded to all of Carl's comments except for the one regarding the partition column. Given that this goes against the original spirit of the JIRA, which appeared to be getting a simple list of columns, and that Carl hasn't yet commented against this change, I think it's ok.

        +1 running tests

        Show
        Kevin Wilfong added a comment - It looks like you've responded to all of Carl's comments except for the one regarding the partition column. Given that this goes against the original spirit of the JIRA, which appeared to be getting a simple list of columns, and that Carl hasn't yet commented against this change, I think it's ok. +1 running tests
        Hide
        Namit Jain added a comment -

        Incorporated all the comments other than the output of show columns.
        Mysql output is very close to describe.

        Here, the goal is just to get the names of the columns.

        Show
        Namit Jain added a comment - Incorporated all the comments other than the output of show columns. Mysql output is very close to describe. Here, the goal is just to get the names of the columns.
        Hide
        Namit Jain added a comment -

        @Carl, can you review https://reviews.facebook.net/D4101 ?
        Most of the comments should be addressed. I can address the remaining ones.

        Show
        Namit Jain added a comment - @Carl, can you review https://reviews.facebook.net/D4101 ? Most of the comments should be addressed. I can address the remaining ones.
        Hide
        Carl Steinbach added a comment -

        @Namit: please see my comments on phabricator. Thanks.

        Show
        Carl Steinbach added a comment - @Namit: please see my comments on phabricator. Thanks.
        Hide
        Namit Jain added a comment - - edited

        https://reviews.facebook.net/D4101

        Added more tests, moved the errors to compile time.
        Addressed Carl's comments

        Show
        Namit Jain added a comment - - edited https://reviews.facebook.net/D4101 Added more tests, moved the errors to compile time. Addressed Carl's comments
        Hide
        Phabricator added a comment -

        dikanggu updated the revision "HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.".
        Reviewers: JIRA, njain

        address Namit's comments, add the partition columns.

        REVISION DETAIL
        https://reviews.facebook.net/D2595

        AFFECTED FILES
        ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
        ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
        ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
        ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzerFactory.java
        ql/src/java/org/apache/hadoop/hive/ql/plan/DDLWork.java
        ql/src/java/org/apache/hadoop/hive/ql/plan/HiveOperation.java
        ql/src/java/org/apache/hadoop/hive/ql/plan/ShowColumnsDesc.java
        ql/src/test/queries/clientpositive/show_columns.q
        ql/src/test/results/clientpositive/show_columns.q.out

        Show
        Phabricator added a comment - dikanggu updated the revision " HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.". Reviewers: JIRA, njain address Namit's comments, add the partition columns. REVISION DETAIL https://reviews.facebook.net/D2595 AFFECTED FILES ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzerFactory.java ql/src/java/org/apache/hadoop/hive/ql/plan/DDLWork.java ql/src/java/org/apache/hadoop/hive/ql/plan/HiveOperation.java ql/src/java/org/apache/hadoop/hive/ql/plan/ShowColumnsDesc.java ql/src/test/queries/clientpositive/show_columns.q ql/src/test/results/clientpositive/show_columns.q.out
        Hide
        Carl Steinbach added a comment -

        MySQL has a SHOW COLUMNS command: http://dev.mysql.com/doc/refman/5.0/en/show-columns.html

        Seems like we should follow convention and try to duplicate that instead of inventing our own behavior. Also, I think returning each column name in a separate row is much more convenient (and consistent) for clients than forcing them to tokenize the names by splitting on ','

        Show
        Carl Steinbach added a comment - MySQL has a SHOW COLUMNS command: http://dev.mysql.com/doc/refman/5.0/en/show-columns.html Seems like we should follow convention and try to duplicate that instead of inventing our own behavior. Also, I think returning each column name in a separate row is much more convenient (and consistent) for clients than forcing them to tokenize the names by splitting on ','
        Hide
        Phabricator added a comment -

        njain has commented on the revision "HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.".

        INLINE COMMENTS
        ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java:2039 for partitioned tables, all partitioned columns also
        cols.addAll(tbl.getPartCols());

        REVISION DETAIL
        https://reviews.facebook.net/D2595

        Show
        Phabricator added a comment - njain has commented on the revision " HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.". INLINE COMMENTS ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java:2039 for partitioned tables, all partitioned columns also cols.addAll(tbl.getPartCols()); REVISION DETAIL https://reviews.facebook.net/D2595
        Hide
        Phabricator added a comment -

        dikanggu updated the revision "HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.".
        Reviewers: JIRA, njain

        address Namit's comments.

        REVISION DETAIL
        https://reviews.facebook.net/D2595

        AFFECTED FILES
        ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
        ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
        ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
        ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzerFactory.java
        ql/src/java/org/apache/hadoop/hive/ql/plan/DDLWork.java
        ql/src/java/org/apache/hadoop/hive/ql/plan/HiveOperation.java
        ql/src/java/org/apache/hadoop/hive/ql/plan/ShowColumnsDesc.java
        ql/src/test/queries/clientpositive/show_columns.q
        ql/src/test/results/clientpositive/show_columns.q.out

        Show
        Phabricator added a comment - dikanggu updated the revision " HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.". Reviewers: JIRA, njain address Namit's comments. REVISION DETAIL https://reviews.facebook.net/D2595 AFFECTED FILES ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzerFactory.java ql/src/java/org/apache/hadoop/hive/ql/plan/DDLWork.java ql/src/java/org/apache/hadoop/hive/ql/plan/HiveOperation.java ql/src/java/org/apache/hadoop/hive/ql/plan/ShowColumnsDesc.java ql/src/test/queries/clientpositive/show_columns.q ql/src/test/results/clientpositive/show_columns.q.out
        Hide
        Phabricator added a comment -

        njain has commented on the revision "HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.".

        INLINE COMMENTS
        ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java:2037 dont sort the columns.

        Use the same order as used by describeTable

        REVISION DETAIL
        https://reviews.facebook.net/D2595

        Show
        Phabricator added a comment - njain has commented on the revision " HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.". INLINE COMMENTS ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java:2037 dont sort the columns. Use the same order as used by describeTable REVISION DETAIL https://reviews.facebook.net/D2595
        Hide
        Phabricator added a comment -

        dikanggu updated the revision "HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.".
        Reviewers: JIRA, njain

        address Namit's comments.

        REVISION DETAIL
        https://reviews.facebook.net/D2595

        AFFECTED FILES
        ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
        ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
        ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
        ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzerFactory.java
        ql/src/java/org/apache/hadoop/hive/ql/plan/DDLWork.java
        ql/src/java/org/apache/hadoop/hive/ql/plan/HiveOperation.java
        ql/src/java/org/apache/hadoop/hive/ql/plan/ShowColumnsDesc.java
        ql/src/test/queries/clientpositive/show_columns.q
        ql/src/test/results/clientpositive/show_columns.q.out

        Show
        Phabricator added a comment - dikanggu updated the revision " HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.". Reviewers: JIRA, njain address Namit's comments. REVISION DETAIL https://reviews.facebook.net/D2595 AFFECTED FILES ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzerFactory.java ql/src/java/org/apache/hadoop/hive/ql/plan/DDLWork.java ql/src/java/org/apache/hadoop/hive/ql/plan/HiveOperation.java ql/src/java/org/apache/hadoop/hive/ql/plan/ShowColumnsDesc.java ql/src/test/queries/clientpositive/show_columns.q ql/src/test/results/clientpositive/show_columns.q.out
        Hide
        Phabricator added a comment -

        njain has commented on the revision "HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.".

        You need to add the table as the input for inputs.

        I mean, if you are performing:

        show columns FOO;

        FOO should appear in the inputs

        INLINE COMMENTS
        ql/src/test/queries/clientpositive/show_columns.q:4 add SHOW COLUMNS shcols_test also

        REVISION DETAIL
        https://reviews.facebook.net/D2595

        Show
        Phabricator added a comment - njain has commented on the revision " HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.". You need to add the table as the input for inputs. I mean, if you are performing: show columns FOO; FOO should appear in the inputs INLINE COMMENTS ql/src/test/queries/clientpositive/show_columns.q:4 add SHOW COLUMNS shcols_test also REVISION DETAIL https://reviews.facebook.net/D2595
        Hide
        Phabricator added a comment -

        dikanggu updated the revision "HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.".
        Reviewers: JIRA, njain

        fix the unit tests

        ant test -Dtestcase=TestCliDriver -Dqfile=show_columns.q -Doverwrite=true -Dtest.silent=false

        REVISION DETAIL
        https://reviews.facebook.net/D2595

        AFFECTED FILES
        ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
        ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
        ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
        ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzerFactory.java
        ql/src/java/org/apache/hadoop/hive/ql/plan/DDLWork.java
        ql/src/java/org/apache/hadoop/hive/ql/plan/HiveOperation.java
        ql/src/java/org/apache/hadoop/hive/ql/plan/ShowColumnsDesc.java
        ql/src/test/queries/clientpositive/show_columns.q
        ql/src/test/results/clientpositive/show_columns.q.out

        Show
        Phabricator added a comment - dikanggu updated the revision " HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.". Reviewers: JIRA, njain fix the unit tests ant test -Dtestcase=TestCliDriver -Dqfile=show_columns.q -Doverwrite=true -Dtest.silent=false REVISION DETAIL https://reviews.facebook.net/D2595 AFFECTED FILES ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzerFactory.java ql/src/java/org/apache/hadoop/hive/ql/plan/DDLWork.java ql/src/java/org/apache/hadoop/hive/ql/plan/HiveOperation.java ql/src/java/org/apache/hadoop/hive/ql/plan/ShowColumnsDesc.java ql/src/test/queries/clientpositive/show_columns.q ql/src/test/results/clientpositive/show_columns.q.out
        Hide
        Phabricator added a comment -

        dikanggu has commented on the revision "HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.".

        There are something wrong with the unit test, and I'm still working it.

        REVISION DETAIL
        https://reviews.facebook.net/D2595

        Show
        Phabricator added a comment - dikanggu has commented on the revision " HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.". There are something wrong with the unit test, and I'm still working it. REVISION DETAIL https://reviews.facebook.net/D2595
        Hide
        Phabricator added a comment -

        dikanggu requested code review of "HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.".
        Reviewers: JIRA

        add the show columns in hive cli

        Due to the way that SELECT * and partitioning works, it is frequently obnoxious to insert data into tables of the same schema.

        This could be fixed in a number of ways, all murky; this feature request reduces the obnoxicity of the current situation.

        SHOW COLUMNS foo;
        OK
        bar, baz, tball, ds

        ...then I could just copy the first three and not the last.

        TEST PLAN
        unit test, show_columns.q

        REVISION DETAIL
        https://reviews.facebook.net/D2595

        AFFECTED FILES
        ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
        ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
        ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
        ql/src/java/org/apache/hadoop/hive/ql/plan/DDLWork.java
        ql/src/java/org/apache/hadoop/hive/ql/plan/ShowColumnsDesc.java
        ql/src/test/queries/clientpositive/show_columns.q

        MANAGE HERALD DIFFERENTIAL RULES
        https://reviews.facebook.net/herald/view/differential/

        WHY DID I GET THIS EMAIL?
        https://reviews.facebook.net/herald/transcript/5919/

        Tip: use the X-Herald-Rules header to filter Herald messages in your client.

        Show
        Phabricator added a comment - dikanggu requested code review of " HIVE-2909 [jira] SHOW COLUMNS table_name; to provide a comma-delimited list of columns.". Reviewers: JIRA add the show columns in hive cli Due to the way that SELECT * and partitioning works, it is frequently obnoxious to insert data into tables of the same schema. This could be fixed in a number of ways, all murky; this feature request reduces the obnoxicity of the current situation. SHOW COLUMNS foo; OK bar, baz, tball, ds ...then I could just copy the first three and not the last. TEST PLAN unit test, show_columns.q REVISION DETAIL https://reviews.facebook.net/D2595 AFFECTED FILES ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g ql/src/java/org/apache/hadoop/hive/ql/plan/DDLWork.java ql/src/java/org/apache/hadoop/hive/ql/plan/ShowColumnsDesc.java ql/src/test/queries/clientpositive/show_columns.q MANAGE HERALD DIFFERENTIAL RULES https://reviews.facebook.net/herald/view/differential/ WHY DID I GET THIS EMAIL? https://reviews.facebook.net/herald/transcript/5919/ Tip: use the X-Herald-Rules header to filter Herald messages in your client.
        Show
        Namit Jain added a comment - https://cwiki.apache.org/Hive/phabricatorcodereview.html

          People

          • Assignee:
            Namit Jain
            Reporter:
            Adam Kramer
          • Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development