Dear, Please help me, recently I met a issue when I test drill with hbase.
I tested two sqls, one return the wrong result and the other return correct result. the wrong sql: select CONVERT_FROM(a.`v`.`e0`, 'UTF8') as k, count(a.`v`.`e0`) p from hbase.browser_action2 a where a.row_key >'0' group by a.`v`.`e0`; 03-04 Scan(groupscan=[HBaseGroupScan [HBaseScanSpec=HBaseScanSpec [tableName=browser_action2, startRow=0\x00, stopRow=, filter=null], *columns=[`*`]*]]) the correct sql : select CONVERT_FROM(a.`v`.`e0`, 'UTF8') as k, count(a.`v`.`e0`) p from hbase.browser_action2 a group by a.`v`.`e0` can return the right result. 03-04 Scan(groupscan=[HBaseGroupScan [HBaseScanSpec=HBaseScanSpec [tableName=browser_action2, startRow=null, stopRow=null, filter=null], *columns=[`v`.`e0`]*]]) As you can see, the difference of the plan is the columns, the plan is not what I want when I have where clause. Can anyone help me as I do not know how to submit issue for drill at issues.apache.org ?
