HBase
  1. HBase
  2. HBASE-324

[Hbase Shell] If select command returns no result, it doesn't need to show the header information.

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Trivial Trivial
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      hql > select * from udanax;
      +-------------------------+-------------------------+-------------------------+
      | Row                     | Column                  | Cell                    |
      +-------------------------+-------------------------+-------------------------+
      0 row(s) in set. (0.09 sec)
      hql > exit;
      
      1. 2351.patch
        2 kB
        Edward J. Yoon
      2. 2351_v1.patch
        6 kB
        Edward J. Yoon

        Activity

        Hide
        Edward J. Yoon added a comment -

        I'd like to show only the message of null as describe below.

        hql > select * from udanax;
        +-------------------------+-------------------------+-------------------------+
        | Row                     | Column                  | Cell                    |
        +-------------------------+-------------------------+-------------------------+
        | a                       | a:                      | a                       |
        +-------------------------+-------------------------+-------------------------+
        | a                       | b:                      | b                       |
        +-------------------------+-------------------------+-------------------------+
        | a                       | c:                      | c                       |
        +-------------------------+-------------------------+-------------------------+
        3 row(s) in set. (0.09 sec)
        hql > select * from udanax where row='aaaa';
        0 row(s) in set. (0.03 sec)
        hql > select * from xnaadu;
        'xnaadu' is non-existant table.
        hql > exit;
        
        Show
        Edward J. Yoon added a comment - I'd like to show only the message of null as describe below. hql > select * from udanax; +-------------------------+-------------------------+-------------------------+ | Row | Column | Cell | +-------------------------+-------------------------+-------------------------+ | a | a: | a | +-------------------------+-------------------------+-------------------------+ | a | b: | b | +-------------------------+-------------------------+-------------------------+ | a | c: | c | +-------------------------+-------------------------+-------------------------+ 3 row(s) in set. (0.09 sec) hql > select * from udanax where row='aaaa'; 0 row(s) in set. (0.03 sec) hql > select * from xnaadu; 'xnaadu' is non-existant table. hql > exit;
        Hide
        Edward J. Yoon added a comment -
        hql > create table xanadu (a);
        Creating table... Please wait.
        Table created successfully.
        hql > select * from xanadu;
        0 row(s) in set. (0.03 sec)
        hql > exit;
        

        submitting.

        Show
        Edward J. Yoon added a comment - hql > create table xanadu (a); Creating table... Please wait. Table created successfully. hql > select * from xanadu; 0 row(s) in set. (0.03 sec) hql > exit; submitting.
        Hide
        Hadoop QA added a comment -

        -1 overall. Here are the results of testing the latest attachment
        http://issues.apache.org/jira/secure/attachment/12370992/2351.patch
        against trunk revision r601232.

        @author +1. The patch does not contain any @author tags.

        javadoc +1. The javadoc tool did not generate any warning messages.

        javac +1. The applied patch does not generate any new compiler warnings.

        findbugs +1. The patch does not introduce any new Findbugs warnings.

        core tests +1. The patch passed core unit tests.

        contrib tests -1. The patch failed contrib unit tests.

        Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1269/testReport/
        Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1269/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html
        Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1269/artifact/trunk/build/test/checkstyle-errors.html
        Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1269/console

        This message is automatically generated.

        Show
        Hadoop QA added a comment - -1 overall. Here are the results of testing the latest attachment http://issues.apache.org/jira/secure/attachment/12370992/2351.patch against trunk revision r601232. @author +1. The patch does not contain any @author tags. javadoc +1. The javadoc tool did not generate any warning messages. javac +1. The applied patch does not generate any new compiler warnings. findbugs +1. The patch does not introduce any new Findbugs warnings. core tests +1. The patch passed core unit tests. contrib tests -1. The patch failed contrib unit tests. Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1269/testReport/ Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1269/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1269/artifact/trunk/build/test/checkstyle-errors.html Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1269/console This message is automatically generated.
        Hide
        Bryan Duxbury added a comment -

        Doesn't make a functional change, only cosmetic. Not a major issue.

        Show
        Bryan Duxbury added a comment - Doesn't make a functional change, only cosmetic. Not a major issue.
        Hide
        Edward J. Yoon added a comment -

        canceling

        Show
        Edward J. Yoon added a comment - canceling
        Hide
        Edward J. Yoon added a comment -

        resubmitting

        Show
        Edward J. Yoon added a comment - resubmitting
        Hide
        Hadoop QA added a comment -

        -1 overall. Here are the results of testing the latest attachment
        http://issues.apache.org/jira/secure/attachment/12370992/2351.patch
        against trunk revision r603084.

        @author +1. The patch does not contain any @author tags.

        javadoc +1. The javadoc tool did not generate any warning messages.

        javac +1. The applied patch does not generate any new compiler warnings.

        findbugs +1. The patch does not introduce any new Findbugs warnings.

        core tests +1. The patch passed core unit tests.

        contrib tests -1. The patch failed contrib unit tests.

        Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1315/testReport/
        Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1315/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html
        Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1315/artifact/trunk/build/test/checkstyle-errors.html
        Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1315/console

        This message is automatically generated.

        Show
        Hadoop QA added a comment - -1 overall. Here are the results of testing the latest attachment http://issues.apache.org/jira/secure/attachment/12370992/2351.patch against trunk revision r603084. @author +1. The patch does not contain any @author tags. javadoc +1. The javadoc tool did not generate any warning messages. javac +1. The applied patch does not generate any new compiler warnings. findbugs +1. The patch does not introduce any new Findbugs warnings. core tests +1. The patch passed core unit tests. contrib tests -1. The patch failed contrib unit tests. Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1315/testReport/ Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1315/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1315/artifact/trunk/build/test/checkstyle-errors.html Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1315/console This message is automatically generated.
        Hide
        Edward J. Yoon added a comment -

        re-trying

        Show
        Edward J. Yoon added a comment - re-trying
        Hide
        Hadoop QA added a comment -

        +1 overall. Here are the results of testing the latest attachment
        http://issues.apache.org/jira/secure/attachment/12370992/2351.patch
        against trunk revision r603084.

        @author +1. The patch does not contain any @author tags.

        javadoc +1. The javadoc tool did not generate any warning messages.

        javac +1. The applied patch does not generate any new compiler warnings.

        findbugs +1. The patch does not introduce any new Findbugs warnings.

        core tests +1. The patch passed core unit tests.

        contrib tests +1. The patch passed contrib unit tests.

        Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1316/testReport/
        Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1316/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html
        Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1316/artifact/trunk/build/test/checkstyle-errors.html
        Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1316/console

        This message is automatically generated.

        Show
        Hadoop QA added a comment - +1 overall. Here are the results of testing the latest attachment http://issues.apache.org/jira/secure/attachment/12370992/2351.patch against trunk revision r603084. @author +1. The patch does not contain any @author tags. javadoc +1. The javadoc tool did not generate any warning messages. javac +1. The applied patch does not generate any new compiler warnings. findbugs +1. The patch does not introduce any new Findbugs warnings. core tests +1. The patch passed core unit tests. contrib tests +1. The patch passed contrib unit tests. Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1316/testReport/ Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1316/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1316/artifact/trunk/build/test/checkstyle-errors.html Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1316/console This message is automatically generated.
        Hide
        Edward J. Yoon added a comment -

        canceling.

        Show
        Edward J. Yoon added a comment - canceling.
        Hide
        Edward J. Yoon added a comment -

        It need some modifications for html outputting.

        bash-3.00# src/contrib/hbase/bin/hbase shell --html
        Hbase Shell, 0.0.2 version.
        Copyright (c) 2007 by udanax, licensed to Apache Software Foundation.
        Type 'help;' for usage.
        
        hql > select * from udanax;
        Exception in thread "main" java.lang.IllegalStateException: getState() == BEFORE_XML_DECLARATION
                at org.znerd.xmlenc.XMLOutputter.endTag(Unknown Source)
                at org.apache.hadoop.hbase.shell.formatter.HtmlTableFormatter.footer(HtmlTableFormatter.java:135)
                at org.apache.hadoop.hbase.shell.SelectCommand.scanPrint(SelectCommand.java:238)
                at org.apache.hadoop.hbase.shell.SelectCommand.execute(SelectCommand.java:94)
                at org.apache.hadoop.hbase.Shell.main(Shell.java:111)
        bash-3.00# 
        
        Show
        Edward J. Yoon added a comment - It need some modifications for html outputting. bash-3.00# src/contrib/hbase/bin/hbase shell --html Hbase Shell, 0.0.2 version. Copyright (c) 2007 by udanax, licensed to Apache Software Foundation. Type 'help;' for usage. hql > select * from udanax; Exception in thread "main" java.lang.IllegalStateException: getState() == BEFORE_XML_DECLARATION at org.znerd.xmlenc.XMLOutputter.endTag(Unknown Source) at org.apache.hadoop.hbase.shell.formatter.HtmlTableFormatter.footer(HtmlTableFormatter.java:135) at org.apache.hadoop.hbase.shell.SelectCommand.scanPrint(SelectCommand.java:238) at org.apache.hadoop.hbase.shell.SelectCommand.execute(SelectCommand.java:94) at org.apache.hadoop.hbase.Shell.main(Shell.java:111) bash-3.00#
        Hide
        Edward J. Yoon added a comment -
        • when shell re-launching, --master, --html parameters should be re-sended.
        • if select comman returns no result, console-monitor doesn't need to show the header lattice.
        • (--help | -h) option added.
        Show
        Edward J. Yoon added a comment - when shell re-launching, --master, --html parameters should be re-sended. if select comman returns no result, console-monitor doesn't need to show the header lattice. (--help | -h) option added.
        Hide
        Edward J. Yoon added a comment -

        submitting.

        Show
        Edward J. Yoon added a comment - submitting.
        Hide
        Hadoop QA added a comment -

        -1 overall. Here are the results of testing the latest attachment
        http://issues.apache.org/jira/secure/attachment/12371582/2351_v1.patch
        against trunk revision r603824.

        @author +1. The patch does not contain any @author tags.

        javadoc +1. The javadoc tool did not generate any warning messages.

        javac +1. The applied patch does not generate any new compiler warnings.

        findbugs +1. The patch does not introduce any new Findbugs warnings.

        core tests +1. The patch passed core unit tests.

        contrib tests -1. The patch failed contrib unit tests.

        Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1334/testReport/
        Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1334/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html
        Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1334/artifact/trunk/build/test/checkstyle-errors.html
        Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1334/console

        This message is automatically generated.

        Show
        Hadoop QA added a comment - -1 overall. Here are the results of testing the latest attachment http://issues.apache.org/jira/secure/attachment/12371582/2351_v1.patch against trunk revision r603824. @author +1. The patch does not contain any @author tags. javadoc +1. The javadoc tool did not generate any warning messages. javac +1. The applied patch does not generate any new compiler warnings. findbugs +1. The patch does not introduce any new Findbugs warnings. core tests +1. The patch passed core unit tests. contrib tests -1. The patch failed contrib unit tests. Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1334/testReport/ Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1334/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1334/artifact/trunk/build/test/checkstyle-errors.html Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1334/console This message is automatically generated.
        Hide
        Edward J. Yoon added a comment -

        canceling

        Show
        Edward J. Yoon added a comment - canceling
        Hide
        Edward J. Yoon added a comment -

        Retrying

        Show
        Edward J. Yoon added a comment - Retrying
        Hide
        Hadoop QA added a comment -

        +1 overall. Here are the results of testing the latest attachment
        http://issues.apache.org/jira/secure/attachment/12371582/2351_v1.patch
        against trunk revision r603824.

        @author +1. The patch does not contain any @author tags.

        javadoc +1. The javadoc tool did not generate any warning messages.

        javac +1. The applied patch does not generate any new compiler warnings.

        findbugs +1. The patch does not introduce any new Findbugs warnings.

        core tests +1. The patch passed core unit tests.

        contrib tests +1. The patch passed contrib unit tests.

        Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1336/testReport/
        Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1336/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html
        Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1336/artifact/trunk/build/test/checkstyle-errors.html
        Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1336/console

        This message is automatically generated.

        Show
        Hadoop QA added a comment - +1 overall. Here are the results of testing the latest attachment http://issues.apache.org/jira/secure/attachment/12371582/2351_v1.patch against trunk revision r603824. @author +1. The patch does not contain any @author tags. javadoc +1. The javadoc tool did not generate any warning messages. javac +1. The applied patch does not generate any new compiler warnings. findbugs +1. The patch does not introduce any new Findbugs warnings. core tests +1. The patch passed core unit tests. contrib tests +1. The patch passed contrib unit tests. Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1336/testReport/ Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1336/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1336/artifact/trunk/build/test/checkstyle-errors.html Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1336/console This message is automatically generated.
        Hide
        stack added a comment -

        Committed (Failure was in TTMR). Resolving. Thanks for the patch Edward.

        Show
        stack added a comment - Committed (Failure was in TTMR). Resolving. Thanks for the patch Edward.
        Hide
        Hudson added a comment -
        Show
        Hudson added a comment - Integrated in Hadoop-Nightly #332 (See http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Nightly/332/ )

          People

          • Assignee:
            Unassigned
            Reporter:
            Edward J. Yoon
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development