You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Prasad Nagaraj Subramanya (JIRA)" <ji...@apache.org> on 2017/08/27 22:19:02 UTC
[jira] [Created] (DRILL-5743) Using order by clause in a select *
query on hbase table returns only the row_key and order by field(s)
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)