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 <272301...@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 > > > ------------------