hi、phoenix要映射现有hbase表,改一下phoenix建标语句应该可以解决
TonyChen <tonychen0...@qq.com> 于2020年10月10日周六 下午4:03写道: > 查了下 > > hbase(main):011:0> get 'ods_iot_gasdevice', '2900' > COLUMN CELL > base_info:device_id timestamp=1602314819543, > value=\x00\x00\x0BT > base_info:verify_code timestamp=1602314819543, > value=54976e8caf8f524 > status_info:battery_power timestamp=1602314819543, > value=\x00\x00\x00T > status_info:device_status timestamp=1602314819543, > value=\x00\x00\x00\x02 > time_characteristics:create_time timestamp=1602314819543, > value=\x00\x00\x01u\x13\x1F\x1Fv > 1 row(s) in 0.1950 seconds > > > Best, > TonyChen > > > 2020年10月10日 下午3:51,Jark Wu <imj...@gmail.com> 写道: > > > > 我看你是在 phoenix 中查询的,有试过在 hbase shell 中查询吗? > > > > On Sat, 10 Oct 2020 at 15:36, TonyChen <tonychen0...@qq.com> wrote: > > > >> 补充下:print输出数据正常 > >> > >> 11> +I(2910,2910,c514eecbc5c4748,9,1,2020-10-10T15:26:48.182) > >> 12> +I(2911,2911,0d1508ec452d27e,68,4,2020-10-10T15:26:48.182) > >> 3> +I(2902,2902,54976e60b7e8f54,83,1,2020-10-10T15:26:48.182) > >> 5> +I(2904,2904,72806e351aa5849,75,1,2020-10-10T15:26:48.182) > >> 8> +I(2907,2907,1f17c8000abc9e1,38,2,2020-10-10T15:26:48.182) > >> 1> +I(2900,2900,54976e8caf8f524,84,2,2020-10-10T15:26:48.182) > >> 6> +I(2905,2905,70852c245fbd949,45,3,2020-10-10T15:26:48.182) > >> 10> +I(2909,2909,22854c002e08c80,48,2,2020-10-10T15:26:48.182) > >> 2> +I(2901,2901,4110ae7bfd85814,58,2,2020-10-10T15:26:48.182) > >> 9> +I(2908,2908,e5074eeedcaea14,46,3,2020-10-10T15:26:48.182) > >> 4> +I(2903,2903,cc936a01758c0f3,6,4,2020-10-10T15:26:48.182) > >> 7> +I(2906,2906,30864c59367e180,50,4,2020-10-10T15:26:48.182) > >> 7> +I(2918,2918,90bbe8079999fd5,7,4,2020-10-10T15:26:49.178) > >> 9> +I(2920,2920,7e2f257406c730f,54,4,2020-10-10T15:26:49.178) > >> 4> +I(2915,2915,b4f2549ea4436b7,60,2,2020-10-10T15:26:49.178) > >> 11> +I(2922,2922,d7bfa14a1a9555f,6,1,2020-10-10T15:26:49.178) > >> 6> +I(2917,2917,9515c66bb40527b,78,1,2020-10-10T15:26:49.178) > >> 12> +I(2923,2923,8f4535a229b3a32,1,1,2020-10-10T15:26:49.178) > >> 5> +I(2916,2916,093037cdc5acec9,50,4,2020-10-10T15:26:49.178) > >> 2> +I(2913,2913,2842267351e9487,55,2,2020-10-10T15:26:49.178) > >> 10> +I(2921,2921,7704923d1f5042b,33,4,2020-10-10T15:26:49.178) > >> 1> +I(2912,2912,eba073be1b6f4b2,72,2,2020-10-10T15:26:49.178) > >> 8> +I(2919,2919,dd4ae09e50859b9,3,3,2020-10-10T15:26:49.178) > >> 3> +I(2914,2914,49655f1ca53e26e,24,2,2020-10-10T15:26:49.178) > >> 11> +I(2934,2934,3a00563a0ecaf6b,57,2,2020-10-10T15:26:50.173) > >> 9> +I(2932,2932,9a67d05622a57ae,54,1,2020-10-10T15:26:50.173) > >> 4> +I(2927,2927,c6db9148eeddd51,26,1,2020-10-10T15:26:50.173) > >> 5> +I(2928,2928,ae06b971bdeaff4,35,1,2020-10-10T15:26:50.173) > >> 1> +I(2924,2924,176b97cbb37b8e6,62,1,2020-10-10T15:26:50.173) > >> 6> +I(2929,2929,115d2d3f33188a6,62,2,2020-10-10T15:26:50.173) > >> 2> +I(2925,2925,3f3db2f63e505c7,86,4,2020-10-10T15:26:50.173) > >> 3> +I(2926,2926,d88f38f093f274d,55,1,2020-10-10T15:26:50.173) > >> 12> +I(2935,2935,56d5fbf93fd515d,72,1,2020-10-10T15:26:50.173) > >> 8> +I(2931,2931,dd98a2999028a83,59,1,2020-10-10T15:26:50.173) > >> 10> +I(2933,2933,377ec5fa4e52ca3,28,1,2020-10-10T15:26:50.173) > >> 7> +I(2930,2930,d2e93ff01ba5d2b,18,1,2020-10-10T15:26:50.174) > >> 9> +I(2944,2944,8589c30a128c7eb,45,3,2020-10-10T15:26:51.173) > >> 1> +I(2936,2936,d536e4d1703d20c,98,3,2020-10-10T15:26:51.173) > >> 5> +I(2940,2940,8fd48a674b19424,10,2,2020-10-10T15:26:51.173) > >> 11> +I(2946,2946,862c6321430e164,74,1,2020-10-10T15:26:51.173) > >> 2> +I(2937,2937,d177b845862342f,83,3,2020-10-10T15:26:51.173) > >> 6> +I(2941,2941,7c45b6f1ae69811,86,1,2020-10-10T15:26:51.173) > >> 4> +I(2939,2939,8db073425a9d0a9,81,1,2020-10-10T15:26:51.173) > >> 8> +I(2943,2943,b0d63314e8f7c63,57,1,2020-10-10T15:26:51.173) > >> 10> +I(2945,2945,384375f5f161a93,67,2,2020-10-10T15:26:51.173) > >> 12> +I(2947,2947,7a7ed532a9e5b5a,61,4,2020-10-10T15:26:51.173) > >> 3> +I(2938,2938,10e55f27f137a7f,22,4,2020-10-10T15:26:51.173) > >> 7> +I(2942,2942,52ae903a2633739,91,1,2020-10-10T15:26:51.176) > >> 3> +I(2950,2950,e3e60cd0630aa66,88,4,2020-10-10T15:26:52.174) > >> 1> +I(2948,2948,2cca133cca14cbf,44,1,2020-10-10T15:26:52.174) > >> 2> +I(2949,2949,7cc761cdb8bb924,77,4,2020-10-10T15:26:52.174) > >> > >> > >> Best, > >> TonyChen > >> > >> > >