You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by kvnew <27...@qq.com> on 2018/09/28 10:58:17 UTC

KVGEN - cann't select the drill on hbase with json value

Hi, 


About drill on hbase,  when i search the result of kvgen ,but cann't match the value on hbase. 


select KVGEN(CONVERT_FROM(united_user_profile_test1.f4.province_freq, 'UTF8')) from hbase.united_user_profile_test1 limit 10 


It take out error: 
"

Query Failed: An Error Occurred
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: DrillRuntimeException: kvgen function only supports Simple maps as input Fragment 0:0 [Error Id: 91b98616-de1c-49bf-bbbc-3d39e8b57a5a on tencent-recom-hdp04:31010]"




Hbase:
 00026b888c2eef20bad9de column=f4:province_freq, timestamp=1537861268399, value={"\xE5\xB9
         \xBF\xE4\xB8\x9C":1}





Thanks,
liuwenkai


------------------

Re: KVGEN - cann't select the drill on hbase with json value

Posted by Abhishek Girish <ag...@apache.org>.

Hey liuwenkai,

Can you please share a sample row from the table? Also the output of Drill
query with (1) select field, (2) select convert_from(field) ?

On Fri, Sep 28, 2018 at 10:15 AM kvnew <27...@qq.com> wrote:

> Hi,
>
>
> About drill on hbase,  when i search the result of kvgen ,but cann't match
> the value on hbase.
>
>
> select KVGEN(CONVERT_FROM(united_user_profile_test1.f4.province_freq,
> 'UTF8')) from hbase.united_user_profile_test1 limit 10
>
>
> It take out error:
> "
>
> Query Failed: An Error Occurred
> org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> DrillRuntimeException: kvgen function only supports Simple maps as input
> Fragment 0:0 [Error Id: 91b98616-de1c-49bf-bbbc-3d39e8b57a5a on
> tencent-recom-hdp04:31010]"
>
>
>
>
> Hbase:
>  00026b888c2eef20bad9de column=f4:province_freq, timestamp=1537861268399,
> value={"\xE5\xB9
>          \xBF\xE4\xB8\x9C":1}
>
>
>
>
>
> Thanks,
> liuwenkai
>
>
> ------------------