Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5743

Using order by clause in a select * query on hbase table returns only the row_key and order by field(s)

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.11.0
    • Fix Version/s: 1.12.0
    • Component/s: Storage - HBase
    • Labels:
      None

      Description

      1) Consider a hbase table 'part' having column family 'data', which contains columns related to tpch part table

      select * from hbase.`part`;
      

      Result

      +-------------+--+
      | row_key | data |
      +-------------+--+
      | [B@381ea162 | {"p_brand":"QnJhbmQjNDU=","p_comment":"aW5hbCBkZXBvc2l0cy4gY2FyZWY=","p_container":"TEcgQk9Y","p_mfgr":"TWFudWZhY3R1cmVyIzQ=","p_name":"cG93ZGVyIGJyb3duIHNhbG1vbiBzZWFzaGVsbCBkaW0=","p_partkey":"OTk5OQ==","p_retailprice":"MTkwOC45OQ==","p_size":"OA==","p_type":"TEFSR0UgUE9MSVNIRUQgU1RFRUw="} |
      

      3) Consider the following query -

      select * from hbase.`part` as t order by t.data.p_name;
      

      Expected
      The query should return row_key, and all the columns in 'data' column family ordered by column 'data.p_name'

      Actual

      +--------------+--------------------------------------------------------+
      |   row_key    |                          data                          |
      +--------------+--------------------------------------------------------+
      | [B@1bfcb7b6  | {"p_name":"eWVsbG93IHdoaXRlIHRhbiBraGFraSBzYWRkbGU="}  |
      +--------------+--------------------------------------------------------+
      

      Result contains only the row_key and column data.p_name, order by data.p_name

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                prasadns14 Prasad Nagaraj Subramanya
                Reporter:
                prasadns14 Prasad Nagaraj Subramanya
                Reviewer:
                Paul Rogers
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: