drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhishek Girish <agir...@apache.org>
Subject Re: KVGEN - cann't select the drill on hbase with json value
Date Thu, 11 Oct 2018 03:30:05 GMT
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 <272301523@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
>
>
> ------------------

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message