Hbase过滤器

it噩梦

已于 2022-01-28 20:56:26 修改

阅读量2k

点赞数

分类专栏：中间件文章标签： hbase big data 大数据

于 2022-01-28 20:44:02 首次发布

本文链接：https://blog.csdn.net/qq_37362891/article/details/122735901

版权

中间件专栏收录该内容

40 篇文章 4 订阅

订阅专栏

在这里插入图片描述

文章目录

简介

在HBase中，如果要对海量的数据来进行查询，此时基本的操作是比较无力的。此时，需要借助HBase中的高级语法——Filter来进行查询。Filter可以根据列簇、列、版本等条件来对数据进行过滤查询。因为在HBase中，主键、列、版本都是有序存储的，所以借助Filter，可以高效地完成查询。当执行Filter时，HBase会将Filter分发给各个HBase服务器节点来进行查询。

HBase中的过滤器也是基于Java开发的，只不过在Shell中，我们是使用基于JRuby的语法来实现的交互式查询。

实战

在HBase的shell中，通过show_filters指令，可以查看到HBase中内置的一些过滤器。

show_filters

在这里插入图片描述

rowkey过滤器

RowFilter 实现行键字符串的比较和过滤
PrefixFilter rowkey前缀过滤器
KeyOnlyFilter 只对单元格的键进行过滤和显示，不显示值
FirstKeyOnlyFilter 只扫描显示相同键的第一个单元格，其键值对会显示出来
InclusiveStopFilter 替代 ENDROW 返回终止条件行

列过滤器
FamilyFilter 列簇过滤器
QualifierFilter 列标识过滤器，只显示对应列名的数据
ColumnPrefixFilter 对列名称的前缀进行过滤
MultipleColumnPrefixFilter 可以指定多个前缀对列名称过滤
ColumnRangeFilter 过滤列名称的范围
值过滤器

ValueFilter 值过滤器，找到符合值条件的键值对
SingleColumnValueFilter 在指定的列蔟和列中进行比较的值过滤器
SingleColumnValueExcludeFilter 排除匹配成功的值

其他过滤器

ColumnPaginationFilter 对一行的所有列分页，只返回 [offset,offset+limit] 范围内的列
PageFilter 对显示结果按行进行分页显示
TimestampsFilter 时间戳过滤，支持等值，可以设置多个时间戳
ColumnCountGetFilter 限制每个逻辑行返回键值对的个数，在 get 方法中使用
DependentColumnFilter 允许用户指定一个参考列或引用列来过滤其他列的过滤器

Java API官方地址

过滤器的用法

过滤器一般结合scan命令来使用。打开HBase的JAVA API文档。找到RowFilter的构造器说明，我们来看以下，HBase的过滤器该如何使用。

scan ‘表名’, { Filter => "过滤器(比较运算符, ‘比较器表达式’)” }

比较运算符

在这里插入图片描述

比较器

在这里插入图片描述

比较器表达式

在这里插入图片描述

导入数据

将以下数据导入到hbase中,

create 'ORDER_INFO','C1'
put 'ORDER_INFO' ,'02602f66-adc7-40d4-8485-76b5632b5b53', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'0968a418-f2bc-49b4-b9a9-2157cf214cfd', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'0e01edba-5e55-425e-837a-7efb91c56630', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'0e01edba-5e55-425e-837a-7efb91c56630', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'0f46d542-34cb-4ef4-b7fe-6dcfa5f14751', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'0f46d542-34cb-4ef4-b7fe-6dcfa5f14751', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'1fb7c50f-9e26-4aa8-a140-a03d0de78729', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'23275016-996b-420c-8edc-3e3b41de1aee', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'2375a7cf-c206-4ac0-8de4-863e7ffae27b', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'2375a7cf-c206-4ac0-8de4-863e7ffae27b', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'269fe10c-740b-4fdb-ad25-7939094073de', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'269fe10c-740b-4fdb-ad25-7939094073de', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'2849fa34-6513-44d6-8f66-97bccb3a31a1', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'28b7e793-6d14-455b-91b3-0bd8b23b610c', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'28b7e793-6d14-455b-91b3-0bd8b23b610c', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'2909b28a-5085-4f1d-b01e-a34fbaf6ce37', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'2a01dfe5-f5dc-4140-b31b-a6ee27a6e51e', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'2a01dfe5-f5dc-4140-b31b-a6ee27a6e51e', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:STATUS','已取消'
put 'ORDER_INFO' ,'2e19fbe8-7970-4d62-8e8f-d364afc2dd41', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'2fc28d36-dca0-49e8-bad0-42d0602bdb40', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'31477850-8b15-4f1b-9ec3-939f7dc47241', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'31477850-8b15-4f1b-9ec3-939f7dc47241', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'39319322-2d80-41e7-a862-8b8858e63316', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'39319322-2d80-41e7-a862-8b8858e63316', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'42f7fe21-55a3-416f-9535-baa222cc0098', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'44231dbb-9e58-4f1a-8c83-be1aa814be83', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'44231dbb-9e58-4f1a-8c83-be1aa814be83', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'526e33d2-a095-4e19-b759-0017b13666ca', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'5a6932f4-b4a4-4a1a-b082-2475d13f9240', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'5fc0093c-59a3-417b-a9ff-104b9789b530', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'605c6dd8-123b-4088-a047-e9f377fcd866', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'613cfd50-55c7-44d2-bb67-995f72c488ea', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'62246ac1-3dcb-4f2c-8943-800c9216c29f', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'62246ac1-3dcb-4f2c-8943-800c9216c29f', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'625c7fef-de87-428a-b581-a63c71059b14', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'625c7fef-de87-428a-b581-a63c71059b14', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'6d43c490-58ab-4e23-b399-dda862e06481', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'70fa0ae0-6c02-4cfa-91a9-6ad929fe6b1b', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'7170ce71-1fc0-4b6e-a339-67f525536dcd', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'7170ce71-1fc0-4b6e-a339-67f525536dcd', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'72dc148e-ce64-432d-b99f-61c389cb82cd', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'72dc148e-ce64-432d-b99f-61c389cb82cd', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'7c0c1668-b783-413f-afc4-678a5a6d1033', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'7fa02f7a-10df-4247-9935-94c8b7d4dbc0', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'820c5e83-f2e0-42d4-b5f0-83802c75addc', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'83ed55ec-a439-44e0-8fe0-acb7703fb691', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:STATUS','已取消'
put 'ORDER_INFO' ,'8d32669e-327a-4802-89f4-2e91303aee59', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'8dadc2e4-63f1-490f-9182-793be64fed76', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'94ad8ee0-8898-442c-8cb1-083a4b609616', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'994cbb44-f0ee-45ff-a4f4-76c87bc2b972', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'9bf92519-6eb3-449a-853b-0e19f6005887', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'9ff3032c-8679-4247-9e6f-4caf2dc93aff', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'9ff3032c-8679-4247-9e6f-4caf2dc93aff', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'a467ba42-f91e-48a0-865e-1703aaa45e0e', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'a467ba42-f91e-48a0-865e-1703aaa45e0e', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'a5302f47-96d9-41b4-a14c-c7a508f59282', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'a5b57bec-6235-45f4-bd7e-6deb5cd1e008', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'a5b57bec-6235-45f4-bd7e-6deb5cd1e008', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'ae5c3363-cf8f-48a9-9676-701a7b0a7ca5', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'b1fb2399-7cf2-4af5-960a-a4d77f4803b8', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'b21c7dbd-dabd-4610-94b9-d7039866a8eb', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'b4bfd4b7-51f5-480e-9e23-8b1579e36248', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'b63983cc-2b59-4992-84c6-9810526d0282', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'b63983cc-2b59-4992-84c6-9810526d0282', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'bf60b752-1ccc-43bf-9bc3-b2aeccacc0ed', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'c808addc-8b8b-4d89-99b1-db2ed52e61b4', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'cc9dbd20-cf9f-4097-ae8b-4e73db1e4ba1', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'d7be5c39-e07c-40e8-bf09-4922fbc6335c', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'dfe16df7-4a46-4b6f-9c6d-083ec215218e', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'e1241ad4-c9c1-4c17-93b9-ef2c26e7f2b2', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'e1241ad4-c9c1-4c17-93b9-ef2c26e7f2b2', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'e180a9f2-9f80-4b6d-99c8-452d6c037fc7', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'e180a9f2-9f80-4b6d-99c8-452d6c037fc7', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'e4418843-9ac0-47a7-bfd8-d61c4d296933', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'e8b3bb37-1019-4492-93c7-305177271a71', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'eb1a1a22-953a-42f1-b594-f5dfc8fb6262', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'ecfd18f5-45f2-4dcd-9c47-f2ad9b216bd0', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'ecfd18f5-45f2-4dcd-9c47-f2ad9b216bd0', 'C1:STATUS','已完成'
put 'ORDER_INFO' ,'f1226752-7be3-4702-a496-3ddba56f66ec', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'f642b16b-eade-4169-9eeb-4d5f294ec594', 'C1:STATUS','已提交'
put 'ORDER_INFO' ,'f642b16b-eade-4169-9eeb-4d5f294ec594', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'f8f3ca6f-2f5c-44fd-9755-1792de183845', 'C1:STATUS','已付款'
put 'ORDER_INFO' ,'02602f66-adc7-40d4-8485-76b5632b5b53', 'C1:PAY_MONEY',4070
put 'ORDER_INFO' ,'0968a418-f2bc-49b4-b9a9-2157cf214cfd', 'C1:PAY_MONEY',4350
put 'ORDER_INFO' ,'0e01edba-5e55-425e-837a-7efb91c56630', 'C1:PAY_MONEY',6370
put 'ORDER_INFO' ,'0e01edba-5e55-425e-837a-7efb91c56630', 'C1:PAY_MONEY',6370
put 'ORDER_INFO' ,'0f46d542-34cb-4ef4-b7fe-6dcfa5f14751', 'C1:PAY_MONEY',9380
put 'ORDER_INFO' ,'0f46d542-34cb-4ef4-b7fe-6dcfa5f14751', 'C1:PAY_MONEY',9380
put 'ORDER_INFO' ,'1fb7c50f-9e26-4aa8-a140-a03d0de78729', 'C1:PAY_MONEY',6400
put 'ORDER_INFO' ,'23275016-996b-420c-8edc-3e3b41de1aee', 'C1:PAY_MONEY',280
put 'ORDER_INFO' ,'2375a7cf-c206-4ac0-8de4-863e7ffae27b', 'C1:PAY_MONEY',5600
put 'ORDER_INFO' ,'2375a7cf-c206-4ac0-8de4-863e7ffae27b', 'C1:PAY_MONEY',5600
put 'ORDER_INFO' ,'269fe10c-740b-4fdb-ad25-7939094073de', 'C1:PAY_MONEY',8340
put 'ORDER_INFO' ,'269fe10c-740b-4fdb-ad25-7939094073de', 'C1:PAY_MONEY',8340
put 'ORDER_INFO' ,'2849fa34-6513-44d6-8f66-97bccb3a31a1', 'C1:PAY_MONEY',7060
put 'ORDER_INFO' ,'28b7e793-6d14-455b-91b3-0bd8b23b610c', 'C1:PAY_MONEY',640
put 'ORDER_INFO' ,'28b7e793-6d14-455b-91b3-0bd8b23b610c', 'C1:PAY_MONEY',9410
put 'ORDER_INFO' ,'2909b28a-5085-4f1d-b01e-a34fbaf6ce37', 'C1:PAY_MONEY',9390
put 'ORDER_INFO' ,'2a01dfe5-f5dc-4140-b31b-a6ee27a6e51e', 'C1:PAY_MONEY',7490
put 'ORDER_INFO' ,'2a01dfe5-f5dc-4140-b31b-a6ee27a6e51e', 'C1:PAY_MONEY',7490
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:PAY_MONEY',5360
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:PAY_MONEY',5360
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:PAY_MONEY',5360
put 'ORDER_INFO' ,'2e19fbe8-7970-4d62-8e8f-d364afc2dd41', 'C1:PAY_MONEY',6490
put 'ORDER_INFO' ,'2fc28d36-dca0-49e8-bad0-42d0602bdb40', 'C1:PAY_MONEY',3820
put 'ORDER_INFO' ,'31477850-8b15-4f1b-9ec3-939f7dc47241', 'C1:PAY_MONEY',4650
put 'ORDER_INFO' ,'31477850-8b15-4f1b-9ec3-939f7dc47241', 'C1:PAY_MONEY',4650
put 'ORDER_INFO' ,'39319322-2d80-41e7-a862-8b8858e63316', 'C1:PAY_MONEY',5000
put 'ORDER_INFO' ,'39319322-2d80-41e7-a862-8b8858e63316', 'C1:PAY_MONEY',5000
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:PAY_MONEY',5000
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:PAY_MONEY',5000
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:PAY_MONEY',5000
put 'ORDER_INFO' ,'42f7fe21-55a3-416f-9535-baa222cc0098', 'C1:PAY_MONEY',3600
put 'ORDER_INFO' ,'44231dbb-9e58-4f1a-8c83-be1aa814be83', 'C1:PAY_MONEY',3950
put 'ORDER_INFO' ,'44231dbb-9e58-4f1a-8c83-be1aa814be83', 'C1:PAY_MONEY',3950
put 'ORDER_INFO' ,'526e33d2-a095-4e19-b759-0017b13666ca', 'C1:PAY_MONEY',3280
put 'ORDER_INFO' ,'5a6932f4-b4a4-4a1a-b082-2475d13f9240', 'C1:PAY_MONEY',50
put 'ORDER_INFO' ,'5fc0093c-59a3-417b-a9ff-104b9789b530', 'C1:PAY_MONEY',6310
put 'ORDER_INFO' ,'605c6dd8-123b-4088-a047-e9f377fcd866', 'C1:PAY_MONEY',8980
put 'ORDER_INFO' ,'613cfd50-55c7-44d2-bb67-995f72c488ea', 'C1:PAY_MONEY',6830
put 'ORDER_INFO' ,'62246ac1-3dcb-4f2c-8943-800c9216c29f', 'C1:PAY_MONEY',8610
put 'ORDER_INFO' ,'62246ac1-3dcb-4f2c-8943-800c9216c29f', 'C1:PAY_MONEY',8610
put 'ORDER_INFO' ,'625c7fef-de87-428a-b581-a63c71059b14', 'C1:PAY_MONEY',5970
put 'ORDER_INFO' ,'625c7fef-de87-428a-b581-a63c71059b14', 'C1:PAY_MONEY',5970
put 'ORDER_INFO' ,'6d43c490-58ab-4e23-b399-dda862e06481', 'C1:PAY_MONEY',4570
put 'ORDER_INFO' ,'70fa0ae0-6c02-4cfa-91a9-6ad929fe6b1b', 'C1:PAY_MONEY',4100
put 'ORDER_INFO' ,'7170ce71-1fc0-4b6e-a339-67f525536dcd', 'C1:PAY_MONEY',9740
put 'ORDER_INFO' ,'7170ce71-1fc0-4b6e-a339-67f525536dcd', 'C1:PAY_MONEY',9740
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:PAY_MONEY',6550
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:PAY_MONEY',6550
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:PAY_MONEY',6550
put 'ORDER_INFO' ,'72dc148e-ce64-432d-b99f-61c389cb82cd', 'C1:PAY_MONEY',4090
put 'ORDER_INFO' ,'72dc148e-ce64-432d-b99f-61c389cb82cd', 'C1:PAY_MONEY',4090
put 'ORDER_INFO' ,'7c0c1668-b783-413f-afc4-678a5a6d1033', 'C1:PAY_MONEY',3850
put 'ORDER_INFO' ,'7fa02f7a-10df-4247-9935-94c8b7d4dbc0', 'C1:PAY_MONEY',1060
put 'ORDER_INFO' ,'820c5e83-f2e0-42d4-b5f0-83802c75addc', 'C1:PAY_MONEY',9270
put 'ORDER_INFO' ,'83ed55ec-a439-44e0-8fe0-acb7703fb691', 'C1:PAY_MONEY',8380
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:PAY_MONEY',9750
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:PAY_MONEY',9750
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:PAY_MONEY',9750
put 'ORDER_INFO' ,'8d32669e-327a-4802-89f4-2e91303aee59', 'C1:PAY_MONEY',9390
put 'ORDER_INFO' ,'8dadc2e4-63f1-490f-9182-793be64fed76', 'C1:PAY_MONEY',9350
put 'ORDER_INFO' ,'94ad8ee0-8898-442c-8cb1-083a4b609616', 'C1:PAY_MONEY',4370
put 'ORDER_INFO' ,'994cbb44-f0ee-45ff-a4f4-76c87bc2b972', 'C1:PAY_MONEY',3190
put 'ORDER_INFO' ,'9bf92519-6eb3-449a-853b-0e19f6005887', 'C1:PAY_MONEY',1100
put 'ORDER_INFO' ,'9ff3032c-8679-4247-9e6f-4caf2dc93aff', 'C1:PAY_MONEY',850
put 'ORDER_INFO' ,'9ff3032c-8679-4247-9e6f-4caf2dc93aff', 'C1:PAY_MONEY',850
put 'ORDER_INFO' ,'a467ba42-f91e-48a0-865e-1703aaa45e0e', 'C1:PAY_MONEY',8040
put 'ORDER_INFO' ,'a467ba42-f91e-48a0-865e-1703aaa45e0e', 'C1:PAY_MONEY',8040
put 'ORDER_INFO' ,'a5302f47-96d9-41b4-a14c-c7a508f59282', 'C1:PAY_MONEY',8570
put 'ORDER_INFO' ,'a5b57bec-6235-45f4-bd7e-6deb5cd1e008', 'C1:PAY_MONEY',5700
put 'ORDER_INFO' ,'a5b57bec-6235-45f4-bd7e-6deb5cd1e008', 'C1:PAY_MONEY',5700
put 'ORDER_INFO' ,'ae5c3363-cf8f-48a9-9676-701a7b0a7ca5', 'C1:PAY_MONEY',7460
put 'ORDER_INFO' ,'b1fb2399-7cf2-4af5-960a-a4d77f4803b8', 'C1:PAY_MONEY',2690
put 'ORDER_INFO' ,'b21c7dbd-dabd-4610-94b9-d7039866a8eb', 'C1:PAY_MONEY',6310
put 'ORDER_INFO' ,'b4bfd4b7-51f5-480e-9e23-8b1579e36248', 'C1:PAY_MONEY',4000
put 'ORDER_INFO' ,'b63983cc-2b59-4992-84c6-9810526d0282', 'C1:PAY_MONEY',7370
put 'ORDER_INFO' ,'b63983cc-2b59-4992-84c6-9810526d0282', 'C1:PAY_MONEY',7370
put 'ORDER_INFO' ,'bf60b752-1ccc-43bf-9bc3-b2aeccacc0ed', 'C1:PAY_MONEY',720
put 'ORDER_INFO' ,'c808addc-8b8b-4d89-99b1-db2ed52e61b4', 'C1:PAY_MONEY',3630
put 'ORDER_INFO' ,'cc9dbd20-cf9f-4097-ae8b-4e73db1e4ba1', 'C1:PAY_MONEY',5000
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:PAY_MONEY',2660
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:PAY_MONEY',2660
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:PAY_MONEY',2660
put 'ORDER_INFO' ,'d7be5c39-e07c-40e8-bf09-4922fbc6335c', 'C1:PAY_MONEY',8750
put 'ORDER_INFO' ,'dfe16df7-4a46-4b6f-9c6d-083ec215218e', 'C1:PAY_MONEY',410
put 'ORDER_INFO' ,'e1241ad4-c9c1-4c17-93b9-ef2c26e7f2b2', 'C1:PAY_MONEY',6760
put 'ORDER_INFO' ,'e1241ad4-c9c1-4c17-93b9-ef2c26e7f2b2', 'C1:PAY_MONEY',6760
put 'ORDER_INFO' ,'e180a9f2-9f80-4b6d-99c8-452d6c037fc7', 'C1:PAY_MONEY',8120
put 'ORDER_INFO' ,'e180a9f2-9f80-4b6d-99c8-452d6c037fc7', 'C1:PAY_MONEY',8120
put 'ORDER_INFO' ,'e4418843-9ac0-47a7-bfd8-d61c4d296933', 'C1:PAY_MONEY',8170
put 'ORDER_INFO' ,'e8b3bb37-1019-4492-93c7-305177271a71', 'C1:PAY_MONEY',2560
put 'ORDER_INFO' ,'eb1a1a22-953a-42f1-b594-f5dfc8fb6262', 'C1:PAY_MONEY',2370
put 'ORDER_INFO' ,'ecfd18f5-45f2-4dcd-9c47-f2ad9b216bd0', 'C1:PAY_MONEY',8070
put 'ORDER_INFO' ,'ecfd18f5-45f2-4dcd-9c47-f2ad9b216bd0', 'C1:PAY_MONEY',8070
put 'ORDER_INFO' ,'f1226752-7be3-4702-a496-3ddba56f66ec', 'C1:PAY_MONEY',4410
put 'ORDER_INFO' ,'f642b16b-eade-4169-9eeb-4d5f294ec594', 'C1:PAY_MONEY',4010
put 'ORDER_INFO' ,'f642b16b-eade-4169-9eeb-4d5f294ec594', 'C1:PAY_MONEY',4010
put 'ORDER_INFO' ,'f8f3ca6f-2f5c-44fd-9755-1792de183845', 'C1:PAY_MONEY',5950
put 'ORDER_INFO' ,'02602f66-adc7-40d4-8485-76b5632b5b53', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'0968a418-f2bc-49b4-b9a9-2157cf214cfd', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'0e01edba-5e55-425e-837a-7efb91c56630', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'0e01edba-5e55-425e-837a-7efb91c56630', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'0f46d542-34cb-4ef4-b7fe-6dcfa5f14751', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'0f46d542-34cb-4ef4-b7fe-6dcfa5f14751', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'1fb7c50f-9e26-4aa8-a140-a03d0de78729', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'23275016-996b-420c-8edc-3e3b41de1aee', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'2375a7cf-c206-4ac0-8de4-863e7ffae27b', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'2375a7cf-c206-4ac0-8de4-863e7ffae27b', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'269fe10c-740b-4fdb-ad25-7939094073de', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'269fe10c-740b-4fdb-ad25-7939094073de', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'2849fa34-6513-44d6-8f66-97bccb3a31a1', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'28b7e793-6d14-455b-91b3-0bd8b23b610c', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'28b7e793-6d14-455b-91b3-0bd8b23b610c', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'2909b28a-5085-4f1d-b01e-a34fbaf6ce37', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'2a01dfe5-f5dc-4140-b31b-a6ee27a6e51e', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'2a01dfe5-f5dc-4140-b31b-a6ee27a6e51e', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'2e19fbe8-7970-4d62-8e8f-d364afc2dd41', 'C1:PAYWAY',0
put 'ORDER_INFO' ,'2fc28d36-dca0-49e8-bad0-42d0602bdb40', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'31477850-8b15-4f1b-9ec3-939f7dc47241', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'31477850-8b15-4f1b-9ec3-939f7dc47241', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'39319322-2d80-41e7-a862-8b8858e63316', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'39319322-2d80-41e7-a862-8b8858e63316', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'42f7fe21-55a3-416f-9535-baa222cc0098', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'44231dbb-9e58-4f1a-8c83-be1aa814be83', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'44231dbb-9e58-4f1a-8c83-be1aa814be83', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'526e33d2-a095-4e19-b759-0017b13666ca', 'C1:PAYWAY',0
put 'ORDER_INFO' ,'5a6932f4-b4a4-4a1a-b082-2475d13f9240', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'5fc0093c-59a3-417b-a9ff-104b9789b530', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'605c6dd8-123b-4088-a047-e9f377fcd866', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'613cfd50-55c7-44d2-bb67-995f72c488ea', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'62246ac1-3dcb-4f2c-8943-800c9216c29f', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'62246ac1-3dcb-4f2c-8943-800c9216c29f', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'625c7fef-de87-428a-b581-a63c71059b14', 'C1:PAYWAY',0
put 'ORDER_INFO' ,'625c7fef-de87-428a-b581-a63c71059b14', 'C1:PAYWAY',0
put 'ORDER_INFO' ,'6d43c490-58ab-4e23-b399-dda862e06481', 'C1:PAYWAY',0
put 'ORDER_INFO' ,'70fa0ae0-6c02-4cfa-91a9-6ad929fe6b1b', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'7170ce71-1fc0-4b6e-a339-67f525536dcd', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'7170ce71-1fc0-4b6e-a339-67f525536dcd', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'72dc148e-ce64-432d-b99f-61c389cb82cd', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'72dc148e-ce64-432d-b99f-61c389cb82cd', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'7c0c1668-b783-413f-afc4-678a5a6d1033', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'7fa02f7a-10df-4247-9935-94c8b7d4dbc0', 'C1:PAYWAY',0
put 'ORDER_INFO' ,'820c5e83-f2e0-42d4-b5f0-83802c75addc', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'83ed55ec-a439-44e0-8fe0-acb7703fb691', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'8d32669e-327a-4802-89f4-2e91303aee59', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'8dadc2e4-63f1-490f-9182-793be64fed76', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'94ad8ee0-8898-442c-8cb1-083a4b609616', 'C1:PAYWAY',0
put 'ORDER_INFO' ,'994cbb44-f0ee-45ff-a4f4-76c87bc2b972', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'9bf92519-6eb3-449a-853b-0e19f6005887', 'C1:PAYWAY',0
put 'ORDER_INFO' ,'9ff3032c-8679-4247-9e6f-4caf2dc93aff', 'C1:PAYWAY',0
put 'ORDER_INFO' ,'9ff3032c-8679-4247-9e6f-4caf2dc93aff', 'C1:PAYWAY',0
put 'ORDER_INFO' ,'a467ba42-f91e-48a0-865e-1703aaa45e0e', 'C1:PAYWAY',0
put 'ORDER_INFO' ,'a467ba42-f91e-48a0-865e-1703aaa45e0e', 'C1:PAYWAY',0
put 'ORDER_INFO' ,'a5302f47-96d9-41b4-a14c-c7a508f59282', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'a5b57bec-6235-45f4-bd7e-6deb5cd1e008', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'a5b57bec-6235-45f4-bd7e-6deb5cd1e008', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'ae5c3363-cf8f-48a9-9676-701a7b0a7ca5', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'b1fb2399-7cf2-4af5-960a-a4d77f4803b8', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'b21c7dbd-dabd-4610-94b9-d7039866a8eb', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'b4bfd4b7-51f5-480e-9e23-8b1579e36248', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'b63983cc-2b59-4992-84c6-9810526d0282', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'b63983cc-2b59-4992-84c6-9810526d0282', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'bf60b752-1ccc-43bf-9bc3-b2aeccacc0ed', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'c808addc-8b8b-4d89-99b1-db2ed52e61b4', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'cc9dbd20-cf9f-4097-ae8b-4e73db1e4ba1', 'C1:PAYWAY',0
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'d7be5c39-e07c-40e8-bf09-4922fbc6335c', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'dfe16df7-4a46-4b6f-9c6d-083ec215218e', 'C1:PAYWAY',0
put 'ORDER_INFO' ,'e1241ad4-c9c1-4c17-93b9-ef2c26e7f2b2', 'C1:PAYWAY',0
put 'ORDER_INFO' ,'e1241ad4-c9c1-4c17-93b9-ef2c26e7f2b2', 'C1:PAYWAY',0
put 'ORDER_INFO' ,'e180a9f2-9f80-4b6d-99c8-452d6c037fc7', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'e180a9f2-9f80-4b6d-99c8-452d6c037fc7', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'e4418843-9ac0-47a7-bfd8-d61c4d296933', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'e8b3bb37-1019-4492-93c7-305177271a71', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'eb1a1a22-953a-42f1-b594-f5dfc8fb6262', 'C1:PAYWAY',2
put 'ORDER_INFO' ,'ecfd18f5-45f2-4dcd-9c47-f2ad9b216bd0', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'ecfd18f5-45f2-4dcd-9c47-f2ad9b216bd0', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'f1226752-7be3-4702-a496-3ddba56f66ec', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'f642b16b-eade-4169-9eeb-4d5f294ec594', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'f642b16b-eade-4169-9eeb-4d5f294ec594', 'C1:PAYWAY',1
put 'ORDER_INFO' ,'f8f3ca6f-2f5c-44fd-9755-1792de183845', 'C1:PAYWAY',3
put 'ORDER_INFO' ,'02602f66-adc7-40d4-8485-76b5632b5b53', 'C1:USER_ID','4944191'
put 'ORDER_INFO' ,'0968a418-f2bc-49b4-b9a9-2157cf214cfd', 'C1:USER_ID','1625615'
put 'ORDER_INFO' ,'0e01edba-5e55-425e-837a-7efb91c56630', 'C1:USER_ID','3919700'
put 'ORDER_INFO' ,'0e01edba-5e55-425e-837a-7efb91c56630', 'C1:USER_ID','3919700'
put 'ORDER_INFO' ,'0f46d542-34cb-4ef4-b7fe-6dcfa5f14751', 'C1:USER_ID','2993700'
put 'ORDER_INFO' ,'0f46d542-34cb-4ef4-b7fe-6dcfa5f14751', 'C1:USER_ID','2993700'
put 'ORDER_INFO' ,'1fb7c50f-9e26-4aa8-a140-a03d0de78729', 'C1:USER_ID','5037058'
put 'ORDER_INFO' ,'23275016-996b-420c-8edc-3e3b41de1aee', 'C1:USER_ID','3018827'
put 'ORDER_INFO' ,'2375a7cf-c206-4ac0-8de4-863e7ffae27b', 'C1:USER_ID','6489579'
put 'ORDER_INFO' ,'2375a7cf-c206-4ac0-8de4-863e7ffae27b', 'C1:USER_ID','6489579'
put 'ORDER_INFO' ,'269fe10c-740b-4fdb-ad25-7939094073de', 'C1:USER_ID','2948003'
put 'ORDER_INFO' ,'269fe10c-740b-4fdb-ad25-7939094073de', 'C1:USER_ID','2948003'
put 'ORDER_INFO' ,'2849fa34-6513-44d6-8f66-97bccb3a31a1', 'C1:USER_ID','2092774'
put 'ORDER_INFO' ,'28b7e793-6d14-455b-91b3-0bd8b23b610c', 'C1:USER_ID','7152356'
put 'ORDER_INFO' ,'28b7e793-6d14-455b-91b3-0bd8b23b610c', 'C1:USER_ID','7152356'
put 'ORDER_INFO' ,'2909b28a-5085-4f1d-b01e-a34fbaf6ce37', 'C1:USER_ID','8237476'
put 'ORDER_INFO' ,'2a01dfe5-f5dc-4140-b31b-a6ee27a6e51e', 'C1:USER_ID','7813118'
put 'ORDER_INFO' ,'2a01dfe5-f5dc-4140-b31b-a6ee27a6e51e', 'C1:USER_ID','7813118'
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:USER_ID','5301038'
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:USER_ID','5301038'
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:USER_ID','5301038'
put 'ORDER_INFO' ,'2e19fbe8-7970-4d62-8e8f-d364afc2dd41', 'C1:USER_ID','3141181'
put 'ORDER_INFO' ,'2fc28d36-dca0-49e8-bad0-42d0602bdb40', 'C1:USER_ID','9054826'
put 'ORDER_INFO' ,'31477850-8b15-4f1b-9ec3-939f7dc47241', 'C1:USER_ID','5837271'
put 'ORDER_INFO' ,'31477850-8b15-4f1b-9ec3-939f7dc47241', 'C1:USER_ID','5837271'
put 'ORDER_INFO' ,'39319322-2d80-41e7-a862-8b8858e63316', 'C1:USER_ID','5686435'
put 'ORDER_INFO' ,'39319322-2d80-41e7-a862-8b8858e63316', 'C1:USER_ID','5686435'
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:USER_ID','1274270'
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:USER_ID','1274270'
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:USER_ID','1274270'
put 'ORDER_INFO' ,'42f7fe21-55a3-416f-9535-baa222cc0098', 'C1:USER_ID','2661641'
put 'ORDER_INFO' ,'44231dbb-9e58-4f1a-8c83-be1aa814be83', 'C1:USER_ID','3855371'
put 'ORDER_INFO' ,'44231dbb-9e58-4f1a-8c83-be1aa814be83', 'C1:USER_ID','3855371'
put 'ORDER_INFO' ,'526e33d2-a095-4e19-b759-0017b13666ca', 'C1:USER_ID','5553283'
put 'ORDER_INFO' ,'5a6932f4-b4a4-4a1a-b082-2475d13f9240', 'C1:USER_ID','1764961'
put 'ORDER_INFO' ,'5fc0093c-59a3-417b-a9ff-104b9789b530', 'C1:USER_ID','1292805'
put 'ORDER_INFO' ,'605c6dd8-123b-4088-a047-e9f377fcd866', 'C1:USER_ID','6202324'
put 'ORDER_INFO' ,'613cfd50-55c7-44d2-bb67-995f72c488ea', 'C1:USER_ID','6977236'
put 'ORDER_INFO' ,'62246ac1-3dcb-4f2c-8943-800c9216c29f', 'C1:USER_ID','5264116'
put 'ORDER_INFO' ,'62246ac1-3dcb-4f2c-8943-800c9216c29f', 'C1:USER_ID','5264116'
put 'ORDER_INFO' ,'625c7fef-de87-428a-b581-a63c71059b14', 'C1:USER_ID','8051757'
put 'ORDER_INFO' ,'625c7fef-de87-428a-b581-a63c71059b14', 'C1:USER_ID','8051757'
put 'ORDER_INFO' ,'6d43c490-58ab-4e23-b399-dda862e06481', 'C1:USER_ID','5514248'
put 'ORDER_INFO' ,'70fa0ae0-6c02-4cfa-91a9-6ad929fe6b1b', 'C1:USER_ID','8598963'
put 'ORDER_INFO' ,'7170ce71-1fc0-4b6e-a339-67f525536dcd', 'C1:USER_ID','4816392'
put 'ORDER_INFO' ,'7170ce71-1fc0-4b6e-a339-67f525536dcd', 'C1:USER_ID','4816392'
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:USER_ID','2393699'
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:USER_ID','2393699'
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:USER_ID','2393699'
put 'ORDER_INFO' ,'72dc148e-ce64-432d-b99f-61c389cb82cd', 'C1:USER_ID','2536942'
put 'ORDER_INFO' ,'72dc148e-ce64-432d-b99f-61c389cb82cd', 'C1:USER_ID','2536942'
put 'ORDER_INFO' ,'7c0c1668-b783-413f-afc4-678a5a6d1033', 'C1:USER_ID','6803936'
put 'ORDER_INFO' ,'7fa02f7a-10df-4247-9935-94c8b7d4dbc0', 'C1:USER_ID','6119810'
put 'ORDER_INFO' ,'820c5e83-f2e0-42d4-b5f0-83802c75addc', 'C1:USER_ID','5818454'
put 'ORDER_INFO' ,'83ed55ec-a439-44e0-8fe0-acb7703fb691', 'C1:USER_ID','6804703'
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:USER_ID','4382852'
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:USER_ID','4382852'
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:USER_ID','4382852'
put 'ORDER_INFO' ,'8d32669e-327a-4802-89f4-2e91303aee59', 'C1:USER_ID','4182962'
put 'ORDER_INFO' ,'8dadc2e4-63f1-490f-9182-793be64fed76', 'C1:USER_ID','5937549'
put 'ORDER_INFO' ,'94ad8ee0-8898-442c-8cb1-083a4b609616', 'C1:USER_ID','4666456'
put 'ORDER_INFO' ,'994cbb44-f0ee-45ff-a4f4-76c87bc2b972', 'C1:USER_ID','3200759'
put 'ORDER_INFO' ,'9bf92519-6eb3-449a-853b-0e19f6005887', 'C1:USER_ID','3457528'
put 'ORDER_INFO' ,'9ff3032c-8679-4247-9e6f-4caf2dc93aff', 'C1:USER_ID','8835231'
put 'ORDER_INFO' ,'9ff3032c-8679-4247-9e6f-4caf2dc93aff', 'C1:USER_ID','8835231'
put 'ORDER_INFO' ,'a467ba42-f91e-48a0-865e-1703aaa45e0e', 'C1:USER_ID','8206022'
put 'ORDER_INFO' ,'a467ba42-f91e-48a0-865e-1703aaa45e0e', 'C1:USER_ID','8206022'
put 'ORDER_INFO' ,'a5302f47-96d9-41b4-a14c-c7a508f59282', 'C1:USER_ID','5319315'
put 'ORDER_INFO' ,'a5b57bec-6235-45f4-bd7e-6deb5cd1e008', 'C1:USER_ID','6486444'
put 'ORDER_INFO' ,'a5b57bec-6235-45f4-bd7e-6deb5cd1e008', 'C1:USER_ID','6486444'
put 'ORDER_INFO' ,'ae5c3363-cf8f-48a9-9676-701a7b0a7ca5', 'C1:USER_ID','2379296'
put 'ORDER_INFO' ,'b1fb2399-7cf2-4af5-960a-a4d77f4803b8', 'C1:USER_ID','6686018'
put 'ORDER_INFO' ,'b21c7dbd-dabd-4610-94b9-d7039866a8eb', 'C1:USER_ID','1552851'
put 'ORDER_INFO' ,'b4bfd4b7-51f5-480e-9e23-8b1579e36248', 'C1:USER_ID','3260372'
put 'ORDER_INFO' ,'b63983cc-2b59-4992-84c6-9810526d0282', 'C1:USER_ID','3107867'
put 'ORDER_INFO' ,'b63983cc-2b59-4992-84c6-9810526d0282', 'C1:USER_ID','3107867'
put 'ORDER_INFO' ,'bf60b752-1ccc-43bf-9bc3-b2aeccacc0ed', 'C1:USER_ID','5034117'
put 'ORDER_INFO' ,'c808addc-8b8b-4d89-99b1-db2ed52e61b4', 'C1:USER_ID','6435854'
put 'ORDER_INFO' ,'cc9dbd20-cf9f-4097-ae8b-4e73db1e4ba1', 'C1:USER_ID','2007322'
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:USER_ID','7928516'
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:USER_ID','7928516'
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:USER_ID','7928516'
put 'ORDER_INFO' ,'d7be5c39-e07c-40e8-bf09-4922fbc6335c', 'C1:USER_ID','1250995'
put 'ORDER_INFO' ,'dfe16df7-4a46-4b6f-9c6d-083ec215218e', 'C1:USER_ID','1923817'
put 'ORDER_INFO' ,'e1241ad4-c9c1-4c17-93b9-ef2c26e7f2b2', 'C1:USER_ID','2457464'
put 'ORDER_INFO' ,'e1241ad4-c9c1-4c17-93b9-ef2c26e7f2b2', 'C1:USER_ID','2457464'
put 'ORDER_INFO' ,'e180a9f2-9f80-4b6d-99c8-452d6c037fc7', 'C1:USER_ID','7645270'
put 'ORDER_INFO' ,'e180a9f2-9f80-4b6d-99c8-452d6c037fc7', 'C1:USER_ID','7645270'
put 'ORDER_INFO' ,'e4418843-9ac0-47a7-bfd8-d61c4d296933', 'C1:USER_ID','7695668'
put 'ORDER_INFO' ,'e8b3bb37-1019-4492-93c7-305177271a71', 'C1:USER_ID','4405460'
put 'ORDER_INFO' ,'eb1a1a22-953a-42f1-b594-f5dfc8fb6262', 'C1:USER_ID','8233485'
put 'ORDER_INFO' ,'ecfd18f5-45f2-4dcd-9c47-f2ad9b216bd0', 'C1:USER_ID','6387107'
put 'ORDER_INFO' ,'ecfd18f5-45f2-4dcd-9c47-f2ad9b216bd0', 'C1:USER_ID','6387107'
put 'ORDER_INFO' ,'f1226752-7be3-4702-a496-3ddba56f66ec', 'C1:USER_ID','1981968'
put 'ORDER_INFO' ,'f642b16b-eade-4169-9eeb-4d5f294ec594', 'C1:USER_ID','6463215'
put 'ORDER_INFO' ,'f642b16b-eade-4169-9eeb-4d5f294ec594', 'C1:USER_ID','6463215'
put 'ORDER_INFO' ,'f8f3ca6f-2f5c-44fd-9755-1792de183845', 'C1:USER_ID','4060214'
put 'ORDER_INFO' ,'02602f66-adc7-40d4-8485-76b5632b5b53', 'C1:OPERATION_DATE','2020-04-25 12:09:16'
put 'ORDER_INFO' ,'0968a418-f2bc-49b4-b9a9-2157cf214cfd', 'C1:OPERATION_DATE','2020-04-25 12:09:37'
put 'ORDER_INFO' ,'0e01edba-5e55-425e-837a-7efb91c56630', 'C1:OPERATION_DATE','2020-04-25 12:09:39'
put 'ORDER_INFO' ,'0e01edba-5e55-425e-837a-7efb91c56630', 'C1:OPERATION_DATE','2020-04-25 12:09:44'
put 'ORDER_INFO' ,'0f46d542-34cb-4ef4-b7fe-6dcfa5f14751', 'C1:OPERATION_DATE','2020-04-25 12:09:41'
put 'ORDER_INFO' ,'0f46d542-34cb-4ef4-b7fe-6dcfa5f14751', 'C1:OPERATION_DATE','2020-04-25 12:09:46'
put 'ORDER_INFO' ,'1fb7c50f-9e26-4aa8-a140-a03d0de78729', 'C1:OPERATION_DATE','2020-04-25 12:10:13'
put 'ORDER_INFO' ,'23275016-996b-420c-8edc-3e3b41de1aee', 'C1:OPERATION_DATE','2020-04-25 12:09:53'
put 'ORDER_INFO' ,'2375a7cf-c206-4ac0-8de4-863e7ffae27b', 'C1:OPERATION_DATE','2020-04-25 12:08:55'
put 'ORDER_INFO' ,'2375a7cf-c206-4ac0-8de4-863e7ffae27b', 'C1:OPERATION_DATE','2020-04-25 12:09:00'
put 'ORDER_INFO' ,'269fe10c-740b-4fdb-ad25-7939094073de', 'C1:OPERATION_DATE','2020-04-25 12:09:26'
put 'ORDER_INFO' ,'269fe10c-740b-4fdb-ad25-7939094073de', 'C1:OPERATION_DATE','2020-04-25 12:09:30'
put 'ORDER_INFO' ,'2849fa34-6513-44d6-8f66-97bccb3a31a1', 'C1:OPERATION_DATE','2020-04-25 12:09:38'
put 'ORDER_INFO' ,'28b7e793-6d14-455b-91b3-0bd8b23b610c', 'C1:OPERATION_DATE','2020-04-25 12:09:49'
put 'ORDER_INFO' ,'28b7e793-6d14-455b-91b3-0bd8b23b610c', 'C1:OPERATION_DATE','2020-04-25 12:10:01'
put 'ORDER_INFO' ,'2909b28a-5085-4f1d-b01e-a34fbaf6ce37', 'C1:OPERATION_DATE','2020-04-25 12:10:08'
put 'ORDER_INFO' ,'2a01dfe5-f5dc-4140-b31b-a6ee27a6e51e', 'C1:OPERATION_DATE','2020-04-25 12:09:05'
put 'ORDER_INFO' ,'2a01dfe5-f5dc-4140-b31b-a6ee27a6e51e', 'C1:OPERATION_DATE','2020-04-25 12:09:06'
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:OPERATION_DATE','2020-04-25 12:08:50'
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:OPERATION_DATE','2020-04-25 12:08:53'
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:OPERATION_DATE','2020-04-25 12:08:58'
put 'ORDER_INFO' ,'2e19fbe8-7970-4d62-8e8f-d364afc2dd41', 'C1:OPERATION_DATE','2020-04-25 12:09:22'
put 'ORDER_INFO' ,'2fc28d36-dca0-49e8-bad0-42d0602bdb40', 'C1:OPERATION_DATE','2020-04-25 12:10:04'
put 'ORDER_INFO' ,'31477850-8b15-4f1b-9ec3-939f7dc47241', 'C1:OPERATION_DATE','2020-04-25 12:08:52'
put 'ORDER_INFO' ,'31477850-8b15-4f1b-9ec3-939f7dc47241', 'C1:OPERATION_DATE','2020-04-25 12:08:57'
put 'ORDER_INFO' ,'39319322-2d80-41e7-a862-8b8858e63316', 'C1:OPERATION_DATE','2020-04-25 12:08:51'
put 'ORDER_INFO' ,'39319322-2d80-41e7-a862-8b8858e63316', 'C1:OPERATION_DATE','2020-04-25 12:08:56'
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:OPERATION_DATE','2020-04-25 12:08:41'
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:OPERATION_DATE','2020-04-25 12:08:42'
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:OPERATION_DATE','2020-04-25 12:08:43'
put 'ORDER_INFO' ,'42f7fe21-55a3-416f-9535-baa222cc0098', 'C1:OPERATION_DATE','2020-04-25 12:09:58'
put 'ORDER_INFO' ,'44231dbb-9e58-4f1a-8c83-be1aa814be83', 'C1:OPERATION_DATE','2020-04-25 12:08:39'
put 'ORDER_INFO' ,'44231dbb-9e58-4f1a-8c83-be1aa814be83', 'C1:OPERATION_DATE','2020-04-25 12:08:40'
put 'ORDER_INFO' ,'526e33d2-a095-4e19-b759-0017b13666ca', 'C1:OPERATION_DATE','2020-04-25 12:09:01'
put 'ORDER_INFO' ,'5a6932f4-b4a4-4a1a-b082-2475d13f9240', 'C1:OPERATION_DATE','2020-04-25 12:10:07'
put 'ORDER_INFO' ,'5fc0093c-59a3-417b-a9ff-104b9789b530', 'C1:OPERATION_DATE','2020-04-25 12:09:36'
put 'ORDER_INFO' ,'605c6dd8-123b-4088-a047-e9f377fcd866', 'C1:OPERATION_DATE','2020-04-25 12:09:54'
put 'ORDER_INFO' ,'613cfd50-55c7-44d2-bb67-995f72c488ea', 'C1:OPERATION_DATE','2020-04-25 12:10:06'
put 'ORDER_INFO' ,'62246ac1-3dcb-4f2c-8943-800c9216c29f', 'C1:OPERATION_DATE','2020-04-25 12:09:14'
put 'ORDER_INFO' ,'62246ac1-3dcb-4f2c-8943-800c9216c29f', 'C1:OPERATION_DATE','2020-04-25 12:09:18'
put 'ORDER_INFO' ,'625c7fef-de87-428a-b581-a63c71059b14', 'C1:OPERATION_DATE','2020-04-25 12:09:07'
put 'ORDER_INFO' ,'625c7fef-de87-428a-b581-a63c71059b14', 'C1:OPERATION_DATE','2020-04-25 12:09:19'
put 'ORDER_INFO' ,'6d43c490-58ab-4e23-b399-dda862e06481', 'C1:OPERATION_DATE','2020-04-25 12:09:34'
put 'ORDER_INFO' ,'70fa0ae0-6c02-4cfa-91a9-6ad929fe6b1b', 'C1:OPERATION_DATE','2020-04-25 12:09:08'
put 'ORDER_INFO' ,'7170ce71-1fc0-4b6e-a339-67f525536dcd', 'C1:OPERATION_DATE','2020-04-25 12:09:51'
put 'ORDER_INFO' ,'7170ce71-1fc0-4b6e-a339-67f525536dcd', 'C1:OPERATION_DATE','2020-04-25 12:10:03'
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:OPERATION_DATE','2020-04-25 12:08:47'
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:OPERATION_DATE','2020-04-25 12:08:48'
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:OPERATION_DATE','2020-04-25 12:08:49'
put 'ORDER_INFO' ,'72dc148e-ce64-432d-b99f-61c389cb82cd', 'C1:OPERATION_DATE','2020-04-25 12:10:12'
put 'ORDER_INFO' ,'72dc148e-ce64-432d-b99f-61c389cb82cd', 'C1:OPERATION_DATE','2020-04-25 12:10:14'
put 'ORDER_INFO' ,'7c0c1668-b783-413f-afc4-678a5a6d1033', 'C1:OPERATION_DATE','2020-04-25 12:09:20'
put 'ORDER_INFO' ,'7fa02f7a-10df-4247-9935-94c8b7d4dbc0', 'C1:OPERATION_DATE','2020-04-25 12:09:21'
put 'ORDER_INFO' ,'820c5e83-f2e0-42d4-b5f0-83802c75addc', 'C1:OPERATION_DATE','2020-04-25 12:10:09'
put 'ORDER_INFO' ,'83ed55ec-a439-44e0-8fe0-acb7703fb691', 'C1:OPERATION_DATE','2020-04-25 12:09:52'
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:OPERATION_DATE','2020-04-25 12:09:43'
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:OPERATION_DATE','2020-04-25 12:09:48'
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:OPERATION_DATE','2020-04-25 12:10:00'
put 'ORDER_INFO' ,'8d32669e-327a-4802-89f4-2e91303aee59', 'C1:OPERATION_DATE','2020-04-25 12:09:57'
put 'ORDER_INFO' ,'8dadc2e4-63f1-490f-9182-793be64fed76', 'C1:OPERATION_DATE','2020-04-25 12:09:02'
put 'ORDER_INFO' ,'94ad8ee0-8898-442c-8cb1-083a4b609616', 'C1:OPERATION_DATE','2020-04-25 12:09:13'
put 'ORDER_INFO' ,'994cbb44-f0ee-45ff-a4f4-76c87bc2b972', 'C1:OPERATION_DATE','2020-04-25 12:09:25'
put 'ORDER_INFO' ,'9bf92519-6eb3-449a-853b-0e19f6005887', 'C1:OPERATION_DATE','2020-04-25 12:10:11'
put 'ORDER_INFO' ,'9ff3032c-8679-4247-9e6f-4caf2dc93aff', 'C1:OPERATION_DATE','2020-04-25 12:09:40'
put 'ORDER_INFO' ,'9ff3032c-8679-4247-9e6f-4caf2dc93aff', 'C1:OPERATION_DATE','2020-04-25 12:09:45'
put 'ORDER_INFO' ,'a467ba42-f91e-48a0-865e-1703aaa45e0e', 'C1:OPERATION_DATE','2020-04-25 12:09:50'
put 'ORDER_INFO' ,'a467ba42-f91e-48a0-865e-1703aaa45e0e', 'C1:OPERATION_DATE','2020-04-25 12:10:02'
put 'ORDER_INFO' ,'a5302f47-96d9-41b4-a14c-c7a508f59282', 'C1:OPERATION_DATE','2020-04-25 12:08:44'
put 'ORDER_INFO' ,'a5b57bec-6235-45f4-bd7e-6deb5cd1e008', 'C1:OPERATION_DATE','2020-04-25 12:09:27'
put 'ORDER_INFO' ,'a5b57bec-6235-45f4-bd7e-6deb5cd1e008', 'C1:OPERATION_DATE','2020-04-25 12:09:31'
put 'ORDER_INFO' ,'ae5c3363-cf8f-48a9-9676-701a7b0a7ca5', 'C1:OPERATION_DATE','2020-04-25 12:09:23'
put 'ORDER_INFO' ,'b1fb2399-7cf2-4af5-960a-a4d77f4803b8', 'C1:OPERATION_DATE','2020-04-25 12:09:55'
put 'ORDER_INFO' ,'b21c7dbd-dabd-4610-94b9-d7039866a8eb', 'C1:OPERATION_DATE','2020-04-25 12:09:15'
put 'ORDER_INFO' ,'b4bfd4b7-51f5-480e-9e23-8b1579e36248', 'C1:OPERATION_DATE','2020-04-25 12:09:35'
put 'ORDER_INFO' ,'b63983cc-2b59-4992-84c6-9810526d0282', 'C1:OPERATION_DATE','2020-04-25 12:08:45'
put 'ORDER_INFO' ,'b63983cc-2b59-4992-84c6-9810526d0282', 'C1:OPERATION_DATE','2020-04-25 12:08:46'
put 'ORDER_INFO' ,'bf60b752-1ccc-43bf-9bc3-b2aeccacc0ed', 'C1:OPERATION_DATE','2020-04-25 12:09:03'
put 'ORDER_INFO' ,'c808addc-8b8b-4d89-99b1-db2ed52e61b4', 'C1:OPERATION_DATE','2020-04-25 12:09:10'
put 'ORDER_INFO' ,'cc9dbd20-cf9f-4097-ae8b-4e73db1e4ba1', 'C1:OPERATION_DATE','2020-04-25 12:08:38'
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:OPERATION_DATE','2020-04-25 12:09:42'
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:OPERATION_DATE','2020-04-25 12:09:47'
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:OPERATION_DATE','2020-04-25 12:09:59'
put 'ORDER_INFO' ,'d7be5c39-e07c-40e8-bf09-4922fbc6335c', 'C1:OPERATION_DATE','2020-04-25 12:09:09'
put 'ORDER_INFO' ,'dfe16df7-4a46-4b6f-9c6d-083ec215218e', 'C1:OPERATION_DATE','2020-04-25 12:09:56'
put 'ORDER_INFO' ,'e1241ad4-c9c1-4c17-93b9-ef2c26e7f2b2', 'C1:OPERATION_DATE','2020-04-25 12:08:54'
put 'ORDER_INFO' ,'e1241ad4-c9c1-4c17-93b9-ef2c26e7f2b2', 'C1:OPERATION_DATE','2020-04-25 12:08:59'
put 'ORDER_INFO' ,'e180a9f2-9f80-4b6d-99c8-452d6c037fc7', 'C1:OPERATION_DATE','2020-04-25 12:09:28'
put 'ORDER_INFO' ,'e180a9f2-9f80-4b6d-99c8-452d6c037fc7', 'C1:OPERATION_DATE','2020-04-25 12:09:32'
put 'ORDER_INFO' ,'e4418843-9ac0-47a7-bfd8-d61c4d296933', 'C1:OPERATION_DATE','2020-04-25 12:09:11'
put 'ORDER_INFO' ,'e8b3bb37-1019-4492-93c7-305177271a71', 'C1:OPERATION_DATE','2020-04-25 12:10:05'
put 'ORDER_INFO' ,'eb1a1a22-953a-42f1-b594-f5dfc8fb6262', 'C1:OPERATION_DATE','2020-04-25 12:09:24'
put 'ORDER_INFO' ,'ecfd18f5-45f2-4dcd-9c47-f2ad9b216bd0', 'C1:OPERATION_DATE','2020-04-25 12:09:04'
put 'ORDER_INFO' ,'ecfd18f5-45f2-4dcd-9c47-f2ad9b216bd0', 'C1:OPERATION_DATE','2020-04-25 12:09:17'
put 'ORDER_INFO' ,'f1226752-7be3-4702-a496-3ddba56f66ec', 'C1:OPERATION_DATE','2020-04-25 12:10:10'
put 'ORDER_INFO' ,'f642b16b-eade-4169-9eeb-4d5f294ec594', 'C1:OPERATION_DATE','2020-04-25 12:09:29'
put 'ORDER_INFO' ,'f642b16b-eade-4169-9eeb-4d5f294ec594', 'C1:OPERATION_DATE','2020-04-25 12:09:33'
put 'ORDER_INFO' ,'f8f3ca6f-2f5c-44fd-9755-1792de183845', 'C1:OPERATION_DATE','2020-04-25 12:09:12'
put 'ORDER_INFO' ,'02602f66-adc7-40d4-8485-76b5632b5b53', 'C1:CATEGORY','手机;'
put 'ORDER_INFO' ,'0968a418-f2bc-49b4-b9a9-2157cf214cfd', 'C1:CATEGORY','家用电器;;电脑;'
put 'ORDER_INFO' ,'0e01edba-5e55-425e-837a-7efb91c56630', 'C1:CATEGORY','男装;男鞋;'
put 'ORDER_INFO' ,'0e01edba-5e55-425e-837a-7efb91c56630', 'C1:CATEGORY','男装;男鞋;'
put 'ORDER_INFO' ,'0f46d542-34cb-4ef4-b7fe-6dcfa5f14751', 'C1:CATEGORY','维修;手机;'
put 'ORDER_INFO' ,'0f46d542-34cb-4ef4-b7fe-6dcfa5f14751', 'C1:CATEGORY','维修;手机;'
put 'ORDER_INFO' ,'1fb7c50f-9e26-4aa8-a140-a03d0de78729', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'23275016-996b-420c-8edc-3e3b41de1aee', 'C1:CATEGORY','男鞋;汽车;'
put 'ORDER_INFO' ,'2375a7cf-c206-4ac0-8de4-863e7ffae27b', 'C1:CATEGORY','食品;家用电器;'
put 'ORDER_INFO' ,'2375a7cf-c206-4ac0-8de4-863e7ffae27b', 'C1:CATEGORY','食品;家用电器;'
put 'ORDER_INFO' ,'269fe10c-740b-4fdb-ad25-7939094073de', 'C1:CATEGORY','男装;男鞋;'
put 'ORDER_INFO' ,'269fe10c-740b-4fdb-ad25-7939094073de', 'C1:CATEGORY','男装;男鞋;'
put 'ORDER_INFO' ,'2849fa34-6513-44d6-8f66-97bccb3a31a1', 'C1:CATEGORY','酒店;旅游;'
put 'ORDER_INFO' ,'28b7e793-6d14-455b-91b3-0bd8b23b610c', 'C1:CATEGORY','维修;手机;'
put 'ORDER_INFO' ,'28b7e793-6d14-455b-91b3-0bd8b23b610c', 'C1:CATEGORY','维修;手机;'
put 'ORDER_INFO' ,'2909b28a-5085-4f1d-b01e-a34fbaf6ce37', 'C1:CATEGORY','男鞋;汽车;'
put 'ORDER_INFO' ,'2a01dfe5-f5dc-4140-b31b-a6ee27a6e51e', 'C1:CATEGORY','机票;文娱;'
put 'ORDER_INFO' ,'2a01dfe5-f5dc-4140-b31b-a6ee27a6e51e', 'C1:CATEGORY','机票;文娱;'
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:CATEGORY','维修;手机;'
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:CATEGORY','维修;手机;'
put 'ORDER_INFO' ,'2b86ab90-3180-4940-b624-c936a1e7568d', 'C1:CATEGORY','维修;手机;'
put 'ORDER_INFO' ,'2e19fbe8-7970-4d62-8e8f-d364afc2dd41', 'C1:CATEGORY','食品;家用电器;'
put 'ORDER_INFO' ,'2fc28d36-dca0-49e8-bad0-42d0602bdb40', 'C1:CATEGORY','家用电器;;电脑;'
put 'ORDER_INFO' ,'31477850-8b15-4f1b-9ec3-939f7dc47241', 'C1:CATEGORY','机票;文娱;'
put 'ORDER_INFO' ,'31477850-8b15-4f1b-9ec3-939f7dc47241', 'C1:CATEGORY','机票;文娱;'
put 'ORDER_INFO' ,'39319322-2d80-41e7-a862-8b8858e63316', 'C1:CATEGORY','家用电器;;电脑;'
put 'ORDER_INFO' ,'39319322-2d80-41e7-a862-8b8858e63316', 'C1:CATEGORY','家用电器;;电脑;'
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:CATEGORY','男装;男鞋;'
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:CATEGORY','男装;男鞋;'
put 'ORDER_INFO' ,'3d2254bd-c25a-404f-8e42-2faa4929a629', 'C1:CATEGORY','男装;男鞋;'
put 'ORDER_INFO' ,'42f7fe21-55a3-416f-9535-baa222cc0098', 'C1:CATEGORY','维修;手机;'
put 'ORDER_INFO' ,'44231dbb-9e58-4f1a-8c83-be1aa814be83', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'44231dbb-9e58-4f1a-8c83-be1aa814be83', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'526e33d2-a095-4e19-b759-0017b13666ca', 'C1:CATEGORY','食品;家用电器;'
put 'ORDER_INFO' ,'5a6932f4-b4a4-4a1a-b082-2475d13f9240', 'C1:CATEGORY','家用电器;;电脑;'
put 'ORDER_INFO' ,'5fc0093c-59a3-417b-a9ff-104b9789b530', 'C1:CATEGORY','男装;男鞋;'
put 'ORDER_INFO' ,'605c6dd8-123b-4088-a047-e9f377fcd866', 'C1:CATEGORY','机票;文娱;'
put 'ORDER_INFO' ,'613cfd50-55c7-44d2-bb67-995f72c488ea', 'C1:CATEGORY','酒店;旅游;'
put 'ORDER_INFO' ,'62246ac1-3dcb-4f2c-8943-800c9216c29f', 'C1:CATEGORY','维修;手机;'
put 'ORDER_INFO' ,'62246ac1-3dcb-4f2c-8943-800c9216c29f', 'C1:CATEGORY','维修;手机;'
put 'ORDER_INFO' ,'625c7fef-de87-428a-b581-a63c71059b14', 'C1:CATEGORY','男鞋;汽车;'
put 'ORDER_INFO' ,'625c7fef-de87-428a-b581-a63c71059b14', 'C1:CATEGORY','男鞋;汽车;'
put 'ORDER_INFO' ,'6d43c490-58ab-4e23-b399-dda862e06481', 'C1:CATEGORY','酒店;旅游;'
put 'ORDER_INFO' ,'70fa0ae0-6c02-4cfa-91a9-6ad929fe6b1b', 'C1:CATEGORY','维修;手机;'
put 'ORDER_INFO' ,'7170ce71-1fc0-4b6e-a339-67f525536dcd', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'7170ce71-1fc0-4b6e-a339-67f525536dcd', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:CATEGORY','男鞋;汽车;'
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:CATEGORY','男鞋;汽车;'
put 'ORDER_INFO' ,'71961b06-290b-457d-bbe0-86acb013b0e3', 'C1:CATEGORY','男鞋;汽车;'
put 'ORDER_INFO' ,'72dc148e-ce64-432d-b99f-61c389cb82cd', 'C1:CATEGORY','机票;文娱;'
put 'ORDER_INFO' ,'72dc148e-ce64-432d-b99f-61c389cb82cd', 'C1:CATEGORY','机票;文娱;'
put 'ORDER_INFO' ,'7c0c1668-b783-413f-afc4-678a5a6d1033', 'C1:CATEGORY','酒店;旅游;'
put 'ORDER_INFO' ,'7fa02f7a-10df-4247-9935-94c8b7d4dbc0', 'C1:CATEGORY','维修;手机;'
put 'ORDER_INFO' ,'820c5e83-f2e0-42d4-b5f0-83802c75addc', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'83ed55ec-a439-44e0-8fe0-acb7703fb691', 'C1:CATEGORY','男鞋;汽车;'
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'85287268-f139-4d59-8087-23fa6454de9d', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'8d32669e-327a-4802-89f4-2e91303aee59', 'C1:CATEGORY','机票;文娱;'
put 'ORDER_INFO' ,'8dadc2e4-63f1-490f-9182-793be64fed76', 'C1:CATEGORY','酒店;旅游;'
put 'ORDER_INFO' ,'94ad8ee0-8898-442c-8cb1-083a4b609616', 'C1:CATEGORY','维修;手机;'
put 'ORDER_INFO' ,'994cbb44-f0ee-45ff-a4f4-76c87bc2b972', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'9bf92519-6eb3-449a-853b-0e19f6005887', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'9ff3032c-8679-4247-9e6f-4caf2dc93aff', 'C1:CATEGORY','男鞋;汽车;'
put 'ORDER_INFO' ,'9ff3032c-8679-4247-9e6f-4caf2dc93aff', 'C1:CATEGORY','食品;家用电器;'
put 'ORDER_INFO' ,'a467ba42-f91e-48a0-865e-1703aaa45e0e', 'C1:CATEGORY','家用电器;;电脑;'
put 'ORDER_INFO' ,'a467ba42-f91e-48a0-865e-1703aaa45e0e', 'C1:CATEGORY','家用电器;;电脑;'
put 'ORDER_INFO' ,'a5302f47-96d9-41b4-a14c-c7a508f59282', 'C1:CATEGORY','机票;文娱;'
put 'ORDER_INFO' ,'a5b57bec-6235-45f4-bd7e-6deb5cd1e008', 'C1:CATEGORY','酒店;旅游;'
put 'ORDER_INFO' ,'a5b57bec-6235-45f4-bd7e-6deb5cd1e008', 'C1:CATEGORY','酒店;旅游;'
put 'ORDER_INFO' ,'ae5c3363-cf8f-48a9-9676-701a7b0a7ca5', 'C1:CATEGORY','维修;手机;'
put 'ORDER_INFO' ,'b1fb2399-7cf2-4af5-960a-a4d77f4803b8', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'b21c7dbd-dabd-4610-94b9-d7039866a8eb', 'C1:CATEGORY','男鞋;汽车;'
put 'ORDER_INFO' ,'b4bfd4b7-51f5-480e-9e23-8b1579e36248', 'C1:CATEGORY','机票;文娱;'
put 'ORDER_INFO' ,'b63983cc-2b59-4992-84c6-9810526d0282', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'b63983cc-2b59-4992-84c6-9810526d0282', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'bf60b752-1ccc-43bf-9bc3-b2aeccacc0ed', 'C1:CATEGORY','机票;文娱;'
put 'ORDER_INFO' ,'c808addc-8b8b-4d89-99b1-db2ed52e61b4', 'C1:CATEGORY','酒店;旅游;'
put 'ORDER_INFO' ,'cc9dbd20-cf9f-4097-ae8b-4e73db1e4ba1', 'C1:CATEGORY','维修;手机;'
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'ccceaf57-a5ab-44df-834a-e7b32c63efc1', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'d7be5c39-e07c-40e8-bf09-4922fbc6335c', 'C1:CATEGORY','食品;家用电器;'
put 'ORDER_INFO' ,'dfe16df7-4a46-4b6f-9c6d-083ec215218e', 'C1:CATEGORY','家用电器;;电脑;'
put 'ORDER_INFO' ,'e1241ad4-c9c1-4c17-93b9-ef2c26e7f2b2', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'e1241ad4-c9c1-4c17-93b9-ef2c26e7f2b2', 'C1:CATEGORY','数码;女装;'
put 'ORDER_INFO' ,'e180a9f2-9f80-4b6d-99c8-452d6c037fc7', 'C1:CATEGORY','男鞋;汽车;'
put 'ORDER_INFO' ,'e180a9f2-9f80-4b6d-99c8-452d6c037fc7', 'C1:CATEGORY','男鞋;汽车;'
put 'ORDER_INFO' ,'e4418843-9ac0-47a7-bfd8-d61c4d296933', 'C1:CATEGORY','家用电器;;电脑;'
put 'ORDER_INFO' ,'e8b3bb37-1019-4492-93c7-305177271a71', 'C1:CATEGORY','男装;男鞋;'
put 'ORDER_INFO' ,'eb1a1a22-953a-42f1-b594-f5dfc8fb6262', 'C1:CATEGORY','机票;文娱;'
put 'ORDER_INFO' ,'ecfd18f5-45f2-4dcd-9c47-f2ad9b216bd0', 'C1:CATEGORY','酒店;旅游;'
put 'ORDER_INFO' ,'ecfd18f5-45f2-4dcd-9c47-f2ad9b216bd0', 'C1:CATEGORY','酒店;旅游;'
put 'ORDER_INFO' ,'f1226752-7be3-4702-a496-3ddba56f66ec', 'C1:CATEGORY','维修;手机;'
put 'ORDER_INFO' ,'f642b16b-eade-4169-9eeb-4d5f294ec594', 'C1:CATEGORY','男鞋;汽车;'
put 'ORDER_INFO' ,'f642b16b-eade-4169-9eeb-4d5f294ec594', 'C1:CATEGORY','男鞋;汽车;'
put 'ORDER_INFO' ,'f8f3ca6f-2f5c-44fd-9755-1792de183845', 'C1:CATEGORY','机票;文娱;'

使用RowFilter查询指定订单ID的数据

只查询订单的ID为：02602f66-adc7-40d4-8485-76b5632b5b53、订单状态以及支付方式

分析

因为要订单ID就是ORDER_INFO表的rowkey，所以，我们应该使用rowkey过滤器来过滤
通过HBase的JAVA API，找到RowFilter构造器

在这里插入图片描述

通过上图，可以分析得到，RowFilter过滤器接受两个参数，

op——比较运算符
rowComparator——比较器
所以构建该Filter的时候，只需要传入两个参数即可

命令:

scan 'ORDER_INFO', {FILTER => "RowFilter(=,'binary:02602f66-adc7-40d4-8485-76b5632b5b53')", FORMATTER => 'toString'}

在这里插入图片描述

需求二：查询状态为已付款的订单

分析

因为此处要指定列来进行查询，所以，我们不再使用rowkey过滤器，而是要使用列过滤器
我们要针对指定列和指定值进行过滤，比较适合使用SingleColumnValueFilter过滤器，查看JAVA API

在这里插入图片描述

需要传入四个参数：

列簇
列标识（列名）
比较运算符
比较器

注意：

列名STATUS的大小写一定要对！此处使用的是大写！
列名写错了查不出来数据，但HBase不会报错，因为HBase是无模式的

命令:

scan 'ORDER_INFO', {FILTER => "SingleColumnValueFilter('C1', 'STATUS', =, 'binary:已付款')", FORMATTER => 'toString'}

需求三：查询支付方式为1，且金额大于3000的订单

分析:

此处需要使用多个过滤器共同来实现查询，多个过滤器，可以使用AND或者OR来组合多个过滤器完成查询
使用SingleColumnValueFilter实现对应列的查询

命令

查询支付方式为

SingleColumnValueFilter('C1', 'PAYWAY', = , 'binary:1')

查询金额大于3000的订单

SingleColumnValueFilter('C1', 'PAY_MONEY', > , 'binary:3000')

组合查询

scan 'ORDER_INFO', {FILTER => "SingleColumnValueFilter('C1', 'PAYWAY', = , 'binary:1') AND SingleColumnValueFilter('C1', 'PAY_MONEY', > , 'binary:3000')", FORMATTER => 'toString'}

注意：

HBase shell中比较默认都是字符串比较，所以如果是比较数值类型的，会出现不准确的情况
例如：在字符串比较中4000是比100000大的

it噩梦

关注

0
点赞
踩
8

收藏

觉得还不错? 一键收藏
1
评论
Hbase过滤器

文章目录简介实战过滤器的用法比较运算符比较器比较器表达式导入数据使用RowFilter查询指定订单ID的数据需求二：查询状态为已付款的订单需求三：查询支付方式为1，且金额大于3000的订单简介在HBase中，如果要对海量的数据来进行查询，此时基本的操作是比较无力的。此时，需要借助HBase中的高级语法——Filter来进行查询。Filter可以根据列簇、列、版本等条件来对数据进行过滤查询。因为在HBase中，主键、列、版本都是有序存储的，所以借助Filter，可以高效地完成查询。当执行Filter时，.
复制链接

扫一扫