Prasad Nagaraj Subramanya created DRILL-5743: ------------------------------------------------
Summary: Using order by clause in a select * query on hbase table returns only the row_key and order by field(s) Key: DRILL-5743 URL: https://issues.apache.org/jira/browse/DRILL-5743 Project: Apache Drill Issue Type: Bug Components: Storage - HBase Affects Versions: 1.11.0 Reporter: Prasad Nagaraj Subramanya 1) Consider a hbase table 'part' having column family 'data', which contains columns related to tpch part table {code} select * from hbase.`part`; {code} Result {code} +-------------+--+ | 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="} | {code} 3) Consider the following query - {code} select * from hbase.`part` as t order by t.data.p_name; {code} Expected The query should return row_key, and all the columns in 'data' column family Actual {code} +--------------+--------------------------------------------------------+ | row_key | data | +--------------+--------------------------------------------------------+ | [B@1bfcb7b6 | {"p_name":"eWVsbG93IHdoaXRlIHRhbiBraGFraSBzYWRkbGU="} | +--------------+--------------------------------------------------------+ {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)