drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prasad Nagaraj Subramanya (JIRA)" <j...@apache.org>
Subject [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)
Date Sun, 27 Aug 2017 22:19:00 GMT
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)

Mime
View raw message