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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.11.0
• Fix Version/s: 1.12.0
• Component/s: Storage - HBase
• Assignee: Prasad Nagaraj Subramanya
• Reporter: Prasad Nagaraj Subramanya
• Reviewer: Paul Rogers
• Created: 27/Aug/17 22:18
• Updated: 16/Oct/17 19:48
• Resolved: 16/Oct/17 19:48

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

Issue Links

• links to: GitHub Pull Request #975