813
技术社区[云栖]
亿级下ApsaraDB HBase Phoenix秒级内RT在大搜车实践
一、前言
大搜车业务线众多，对于数据的需求也各种各样，本文将介绍其中之一的大搜车车商客户实时数据需求，例如车商PC|H5端店铺、车辆、分享等实时流量数据报表；随着数据量级的增长，目前数据量级在亿级以上，原有以mysql提供查询服务不再适合此场景，经过多方面的考虑，存储最终选择Aliyun HBase，同时为了几乎0成本的切换，采用Phoenix On HBase Sql中间件，它管理着HBase的二级索引并且它对sql的支持友好，本文也将介绍Phoenix和HBase结合场景下的压力测试。
二、数据系统架构
- 实时数据来源为实时采集
PC|H5端访问日志，通过Flume收集这些日志，并按照业务场景需求，通过流试计算清洗、过滤、统计，使用Phoenix api推送到HBase。 - 由于Phoenix管理HBase二级索引，使用Phoenix api推送数据索引表的也会被更新，这样对于编码成本很低。
- 原始的日志同时会通过Flume 持久化至HDFS，方便离线计算数据分析。
-
统一通过数据网关提供业务查询。
架构图：
三、压测
-
数据准备
- 使用阿里云数据集成 服务将mysql数据导入至PHoenix，不过它使用的HBase原生api导入，所以索引数据需要在导完之后再重建。
- 使用MapReduce的方式，这种更友好，直接导出为HFile文件，不必走HBase API，这样会减少集群的负载以及网络消耗，速度更快。但使用的是阿里云HBase，依赖的Hadoop集群不对外。
- 使用Phoenix提供的 psql.py脚本以csv文件的方式导入。
考虑到是一次性的工作，本次压测数据我采用Phoenix提供的脚本的方式导入数据。
-
数据表、sql模板、索引建立
- 表建立 参考
CREATE TABLE FLOW.SHOP_DATA_BY_SALER_CAR_V2 ( PK varchar primary key, INFO.DATE_STR BIGINT, INFO.STORE_ID VARCHAR, INFO.CAR_ID VARCHAR, INFO.SELLER_ID VARCHAR, INFO.SHARE_PV INTEGER, INFO.SHARE_UV INTEGER, INFO.FLOW_PV INTEGER, INFO.FLOW_UV INTEGER, INFO.CALL_PV INTEGER, INFO.CALL_UV INTEGER, INFO.APPOINT_PV INTEGER, INFO.APPOINT_UV INTEGER, INFO.LAST_UPDATE_TIME DATE ) COMPRESSION='SNAPPY',DATA_BLOCK_ENCODING='DIFF';- 模拟真实查询sql模板，sql查询时间范围为1个月的数据。
SELECT info.seller_id, sum(info.share_pv) as sum_share_pv, sum(info.flow_pv) as sum_flow_pv, sum(info.call_pv) as sum_call_pv, sum(info.appoint_pv) as sum_appoint_pv FROM FLOW.SHOP_DATA_BY_SALER_CAR_V2 WHERE info.store_id = '%s' AND info.date >= %d AND info.date <= %d GROUP BY info.seller_id ORDER BY sum_share_pv DESCSELECT sum(info.share_pv) as sum_share_pv, sum(info.flow_pv) as sum_flow_pv, sum(info.call_pv) as sum_call_pv, sum(info.appoint_pv) as sum_appoint_pv FROM FLOW.SHOP_DATA_BY_SALER_CAR_V2 WHERE info.store_id = '%s' AND info.date >= %d AND info.date <= %dSELECT sum(info.share_pv) as sum_share_pv, sum(info.flow_pv) as sum_flow_pv, sum(info.call_pv) as sum_call_pv, sum(info.appoint_pv) as sum_appoint_pv FROM FLOW.SHOP_DATA_BY_SALER_CAR_V2 WHERE info.store_id = '%s' AND info.date >= %d AND info.date <= %d AND info.seller_id = '%s'SELECT info.seller_id, sum(info.share_pv) sum_share_pv, sum(info.flow_pv) sum_flow_pv FROM FLOW.SHOP_DATA_BY_SALER_CAR_V2 WHERE info.car_id = '%s' AND info.date >= %d AND info.date <= %d AND info.share_pv <> 0 ORDER BY info.seller_id -
针对sql模板场景，建立索引表，索引类为覆盖索引 Secondary Indexing
CREATE INDEX SHOP_DATA_BY_SALER_CAR_V2_INDEX ON FLOW.SHOP_DATA_BY_SALER_CAR_V2 (INFO.STORE_ID, INFO.DATE_STR) INCLUDE (INFO.SELLER_ID, INFO.CAR_ID, INFO.SHARE_PV, INFO.FLOW_PV, INFO.CALL_PV, INFO.APPOINT_PV) COMPRESSION='SNAPPY',DATA_BLOCK_ENCODING='DIFF'CREATE INDEX SHOP_DATA_BY_SALER_CAR_V2_INDEX1 ON FLOW.SHOP_DATA_BY_SALER_CAR_V2 (INFO.CAR_ID, INFO.DATE_STR, INFO.SHARE_PV) INCLUDE (INFO.SELLER_ID, INFO.FLOW_PV, INFO.CALL_PV, INFO.APPOINT_PV) COMPRESSION='SNAPPY',DATA_BLOCK_ENCODING='DIFF'- 数据样例的选择：sql查询时间范围均为1个月，查询条件由挑选出这1个月中按车商、销售、车辆各个分组总条数在前300、300、300的数据按照模板随机组合查询。保证sql查询都能命中数据，同时也排除每次都是量很大的数据。数据样例见最后。测试表的数据量级在亿行以上。
-
系统情况
- ECS：4CPU8GB。
- HBase节点信息：Master(4CPU8GB) Core(4CPU8GB) 数据盘都为云盘。
-
压测分别从10 ~ 100并发之前压测，以10为累加单位进行压测，压测时间为10分钟。目前我们业务场景每秒并发数在50 ~ 80左右，高峰期高于80。
- 压测的场景模拟线上的请求，查询基本是都是单表比较复杂的聚合操作。
- 压测结果分别从TPS(每秒处理任务数)、RT(平均响应数据)两个指标衡量。
- 以下挑选了并发数在100的时候应用GC、HBase系统负载情况。
- 应用GC情况 左边为应用日志 右边为GC(对应列分别为S0 S1 E O M CCS YGC YGCT FGC FGCT GCT)，应用本身GC状态良好。
- HBase负载，**从HBase 两台数据节点负载看得出压测的时候已经完全将HBase负载压到极限之上，所以不难得出如果在系统资源充足的情况下，并发数相同的情况下，TPS、RT远远比目前的结果要好**。
- 应用GC情况 左边为应用日志 右边为GC(对应列分别为S0 S1 E O M CCS YGC YGCT FGC FGCT GCT)，应用本身GC状态良好。
四、写在最后
- 进过压力测试，以及上线了一段时间，ApsaraDB HBase Phoenix能满足我们的业务场景的使用。同时Aliyun HBase支持横向扩展以及靠谱的运维能力，也为后面支持更高的并发提供夯实的基础。
- 结合我们业务场景，基本都是单表的复杂聚合操作，对IO消耗比较大，因此最近迁移了HBase，把云盘换成了SSD盘。提高IO的能力。迁移工具 同时期待Aliyun HBase的数据迁移能更加完善。
-
数据样例, ps:数据集经过特殊处理。
- 车商数据集
sql 010140548,001106040,001109847,001104443,001106241,001101049,001110943,001131047,001119549,001121749,001102043,001142748,001118444,001108248,001111340,001108240,001151942,001101240,001101346, 001140948,001101348,001109647,001111643,001100246,001101141,001100047,001100543,001100547,001101340,001135448,001100242,001109546,001109842,001101144,001109845,001104040,001101442,001108045, 001147249,001100544,001107545,001108349,001101245,001103942,001109444,001108748,001153341,001108848,001134442,001107147,001106449,001102047,001109040,001100841,001110446,001100549,001131749, 001109745,001107540,001100440,001123547,001108143,001108149,001101343,001110449,001122440,001100143,001128641,001103943,001107543,001108249,001147244,001112246,001147144,001100241,001149247, 001124344,001118442,001108741,001108943,001132248,001152748,001110543,001107645,001107549,001147947,001109746,001128446,001123143,001103749,001101642,001153442,001100540,001100646,001108740, 001100348,001121942,001154249,001101940,001113148,001152744,001109449,001126341,001130946,001121747,001144442,001108040,001112646,001108744,001108547,001106447,001130745,001145444,001149948, 001110946,001109141,001154848,001130940,001107845,001152146,001108742,001143944,001100248,001111145,001108140,001109843,001124349,001125747,001108841,001139049,001137041,001128049,001108449, 001149045,001132741,001111041,001109248,001147041,001139943,001106543,001106746,001122744,001143042,001114348,001112346,001120846,001136047,001106945,001134943,001106248,001132445,001150745, 001109549,001153844,001143745,001148141,001145149,001119648,001152440,001134245,001107644,001103845,001131242,001139548,001115742,001109241,001115640,001101949,001105048,001126347,001106947, 001102040,001109346,001109242,001121744,001118646,001108147,001131247,001130449,001152142,001112249,001109342,001105942,001128845,001118043,001111245,001100640,001140946,001154645,001108448, 001132948,001155543,001134244,001150649,001109841,001143849,001110047,001139540,001132443,001115449,001101540,001113040,001108743,001143040,001110847,001136142,001145340,001107141,001120943, 001126940,001109048,001107243,001154047,001127546,001122941,001131841,001140344,001110844,001100647,001118241,001101044,001152240,001103949,001106747,001129446,001102247,001106946,001101048, 001103746,001140347,001103747,001122148,001131448,001131645,001155547,001130448,001131349,001122644,001144346,001101941,001113646,001122244,001107042,001122444,001110348,001100845,001137545, 001101545,001137244,001145249,001109748,001153345,001140247,001100644,001139740,001123248,001109446,001149545,001137342,001108145,001120847,001126747,001114042,001131042,001109240,001114342, 001101342,001145145,001113446,001115840,001118046,001124943,001139145,001118247,001108443,001153846,001125340,001137944,001132944,001115447,001146947,001118342,001137248,001118849,001137649, 001142844,001101446,001128947,001132644,001146742,001130043,001108044,001110748,001135740,001143242,001134040,001127443,001124240,001114643,000134230 - 车辆数据集
Cg6f7hXsfkqffgWHsafk,adfu3fMhZsfkDffBFsa4kNadf,fcfchesfkdfg15saakcadf6d487b834e2b8eb81217c,72f8hOsfkRffgdIsaQkMadf,75fah8sfk3fg8fsa4kdadf7c4e03b9e46a864b858b6,59f0hesfk5ffg96sadk8adf934d72b4f8119f0e38acb, 1bfdh3sfk7ffgfesa5k9adfb04d9eb517fbe5f6f98b0,eef1hdsfk6ffg18sa1k9adff142faad8f6042f984a7d,0cf6h9sfk4ffga6sa8k5adf9d40268f8a3df6be9d888,6cf7h9sfk5ffgc5sa0kbadfa84963b5cd0019532d654,0af9hesfk2ffg7asafk4adf644cce8197dff30af47a4, d8f3hbsfkbffg5csaekcadf254f97b35bbba84466216,70fehfsfk0ffg1csabkcadf2c4dbfab031390aa4e837,aefah4sfk4ffg8bsa5k3adf7341fc9afe9c85b7969de,60f3hdsfkcffg1csa1k9adf2d41a59b503d0d788e9de,52f3h0sfkcffg9csa5keadf6d44dc9abb5c7eb36907e, fbfch4sfk7ffgedsa9kbadfb9493fb84fa8cb3c63bab,ccf2hdsfkdffg2asa9kfadf7742bb8129183921752a0,14f7h6sfkfffg33sa4k4adfc540bb9a43316beee70a4,c1f6h3sfk4ffg6asaekcadf45452eb5c53d98ca9f3ed,5bf4hcsfk6ffg51sa2kcadf1a467c9b96d6e8f37b33b, cdf2h3sfkcffgc3sabk4adf784fa6a4c3a9d3dede197,aff1h9sfkaffg29sa9k1adf544f0d817c7f19dc38d3b,c7fdhesfk0ffg7asafkfadf1f4161b9abd9af05f303b,24f7hfsfk5ffgbbsa-kfadf656-4318-b49-c86ad4b891d2,s0fKhSsfkYffghlsaKkcadf,0bf2h2sfkefg78safkeadf034877ae82f7f4cfe446f, 12f6h9sfk2ffga7sa0k6adf3442f9badf15703ecc750,feffh5sfk9ffgf7saek7adf8b4b89aadbf5fbd362356,54f2hcsfkdffgd0sadkbadf2d4808a21cecaf602ef43,f0fshdsfk1ffgPAsa2kLadf,afffh9sfk1fg21safkfadfd2490c8701894ddb9bc3b,12fbhcsfkcffg98safk2adf8541519e839f1ecac8aaf, 05f2hesfk9ffg5dsa0k6adfb740e2aea524c838f5c67,e6fdh4sfk0ffgb1sa2k1adf8345f0b67cdf6ad6a53f1,1dfbh7sfk7ffge2saek9adfe34b2f8dc9f0b6a652c78,03f2hbsfk0ffg40sa3keadf2b4b6daf666494c53ef29,8bfahfsfk5ffgdasa1kdadf1b4c66be94b1b9bb584fc, 3efdhdsfkfffgc6saekcadf48416ab8739ae0d867027,16f1h8sfk0ffg6esa6keafdhfsfk8ffg88sekcadfaf4269978b79d0c595664,53f6h5sfkeffg52saek8adf6245fb974827f1ed7ffa7,fbf6h9sfk1ffge6sa6kdadf12452eb4ccc206f84fb4f,f6fdh4sfkfffg34sa4k0adf1543628f1809dc581e3a8, e2fehesfk4ffg7esafk3adfda40479d1071b3d4d700a,79fbhfsfkbffg79sadkcadfba4a3f9519062efaf0e40,eff2h1sfk8ffg4bsafk7adf094615939aac43a821247,61f1hbsfk8ffg86sa5k0adfe04fcf8191794012dcbdc,bef2h9sfkdffgbesa4kbadf794bf2917c83752d02963, c2f6h0sfk0ffg72sa5keadf9f4bcaa76531abf86811c,beffhasfk8ffg0fsa2k9adfa04e0aa09b6026cbd7001,1df9h0sfkbffgc1sa5k8adfb54afdb278b14e1617fa2,40fahfsfkeffg22saek3adf034c0984623b6a10cdd88,bcf8hcsfk7ffga1saak0adf494f6eb469043862ac691, 09f9hdsfk1ffg10sabkfadf01463b963c7f995d22d62,36f3h0sfk4ffgf8sa4k1adfd9489b8550e4dfdc4bad3,70fbh5sfk9ffg84sa8keadfab43a2917789353431f17,dcfah0sfkfffg6asaekcadf9c42668e1a6eb36960052,5df5hesfkeffg64sa4k5adf7641bb86b0806e9d916a2, 4ef7hbsfk6ffg16sa2kcadf2a4f5b8eb1e0f26ab0dfe,ddfehdsfkdffg5bsaek7adfff40b6970158a933e2083,78f1h4sfk3ffg49sadkfadff34d169d80cd52ff3af56,daf9hdsfkfffg99sack0adf6649c6893357796192e9a,6ff2h2sfk0ffge8sack7adfec4f97bdc4d385fee91ed, QHf6hnsfkaffgNgsavkRadf,e9fah9sfk8fg5dsafkfadff549e59cacbec12c9a1aa,b2f9hesfk7ffgf8sadk7adfcb4ff88b33280a2dc89ac,25f7h4sfk0ffgb7sabk3adfc84ac18699c7410463233,d6f1h1sfk7ffg84saekaadfcc4ed7a073676b07b364d, 66f3hdsfkaffgedsack0adff84689bf5178ebe074f52,a4fbh0sfkfffg59sa8k0adff541eb84e13d570b64875,9ff5h0sfk3ffgd9sadk4adf00446895516b600ef5da7,ecfeh7sfkaffg7bsa8keadfde4dde9034693f302848c,a7fdh8sfk3ffg1csa9kdadf0a42a882b7afd4352a387, 19fbh9sfk7ffg97safk7adf1a4c6ab9ae94a5dde2d53,eaf0h9sfk4ffg68sa0kaadfc64cc3840afebd51da4da,53fehasfkcffgc5saek7adf18457aa2927c18c0315a1,86f7hasfkaffge8sa6k0adfa5441380afdd661c66bf7,2bf9h1sfkeffg52sa6k3adf174a9bbc70b9da2bb91d0, abf7hbsfk7ffge6sa0k1adf6e4ee88bededbf96b4144,e7fdhdsfk9ffgcfsa1kdadfcb4a2198dae8faeb3a5c3,c9f1h2sfk5ffg80sackfadf0047b6a56b43d39f599c3,47fdh1sfk7ffg13safk4adfec40ee849d5c3821010c8,81fch1sfk4ffg8esa7k2adfa94e82bf3780f14e476af, 8bfbh5sfkeffg3dsackbadf4e49b9bcbc35af975eb17,6af7hesfk7ffg71sadkfadf904bfdbba9af0fff5a406,9ffbhbsfkcffg5fsabk2adfd6408ebd79d34547c16dc,0ef7h9sfkbffg5asa3k5adfa84f328d8ebea3fbcdfec,f0f9h7sfk9ffg68sadkeadfa344f382aae5efb0e6224, 0cf6h6sfk2ffg47sa7k7adf104453ae80e1268fc0495,65fdh6sfk5ffg61sa2k1adf42453c8795e0d02904a94,7ff2hcsfk5ffg9csa3kbadf304d23b4246414c5dc8eb,99f6h2sfk3ffg7esa1k1adfd94db9aa8044ee5a03286,e5fdh5sfkaffg74sa8kdadf964a6fb3a8e85f1bae639, 1mfMhHsfkaffg1OsaYkUadf,7ff2h9sfk1fg8dsabkeadf3f4bba987cf8faabbf5f2,cbffh3sfkaffg47sa7k8adf2242ac9301afb95bd25cb,39fahdsfk1ffgedsackbadfad4f0f82d2783e4143bb8,6cfbh1sfk6ffg51sadk8adff5438889974c054bd622c,f9f2hbsfk6ffgb5sadk0adf8342e595c58ea90e98c49, dfffh5sfkfffga3sa2kbadf844af8908f2af4600de60,58fdhesfk6ffg91sa6k0adf0448a6bc79068cc8b0f27,15fehdsfkfffgc9sa7k5adf2549d7a8a690869f35be1,38f3hfsfkeffg23safk2adf934f6787fe4c6a655a0ed,61f6h4sfk3ffg77saek0adf45488f91e77e2df296bb2, d7f6hasfk5ffgfcsackfadfea4bf4af1b10e38787807,dbfahesfkeffgddsa1k6adfee4b74b309ee47ecd91e2,a6ffh2sfk2ffg13sa1k3adf554add80ed52a517f50ad,7ffeh3sfk8ffg77sa7kfadfbf47409247287bc3dbdc6,e3fbh7sfk9ffgfbsaekaadf594c89b6e920df1d48685, djfKhMsfkxffgLnsankmadf,4af9hesfk4fgcasa3k3adfdc467b827d9c732ea09e3,6ef0hasfk6ffg5asabk3adf3c4c499210026452c1bae,84f7hesfk8ffg30sa1k2adff043cebce49dc17279176,51f6h2sfkdffgdcsackaadfe6462fbeea97d6d4f15c2,cff4hasfkaffgc7safkaadf324e75a209a3ac5cedc8d, cef7hcsfk4ffg16saekeadfd2471f810779fef3c83e4,a5fah1sfkfffg46sa6kbadf1b4b1f953249ef0a4972f,3bf7hbsfk5ffg26sa2k1adf1b48ecadad2d4816aacc7,VrfOhCsfk5ffgKUsa8kuadf,edf7hasfk6fg19sa2k0adf6341a7b0ced29dab946b8,82f1h2sfk0ffg83sabk2adf524c11914011e0ce04c5b, fdfdh6sfk1ffg98sa1keadf5d4c09845c329130c0df6,fdf1hdsfk2ffgd0sa8kbadfe84b5d9077d49face8aa2,f0ffhasfk3ffg78saekdadfc84582bca33881c179b1d,6bf1hdsfk1ffg38sa7k6adffd4429b0a6f6aa6dd7880,42f0h3sfk0ffgfcsafk1adfed48f3991ee9c55939379, e4f8hfsfk2ffgf2saak2adff44330828661449f5b9a7,faf6hesfk6ffg1csack4adf6f45c98d9cdfff3869da9,02f2h1sfk4ffgd8sa2kaadfc345cd999287aeeef4de4,baf3h1sfkfffgcesa7k6adffa46da82e442a9f93a379,33f4hesfk5ffg6dsaak2adf064d2c84fa097947b9132, 60fahdsfkeffg44sa5k5adf414f8989dbc6b59ce1d31,95f6hfsfkdffg6bsa2k1adfc84988afae6d6b0ad4b07,d7f0hesfk0ffgacsafk1adfb74a57ab3ddf14c9e1297,40fch7sfkcffg3fsa7k3adf904493a7ce50eee63aaf3,13ffh8sfkaffga8sadk6adfef46de8cb32736af0007f, 7cfahcsfk1ffg24sa2k8adf2049af8aea108869b96ba,f6ffh6sfkaffgd6sa6k8adfb44f3c85e58a155b0f1b3,84f1hesfkcffg29sa9k8adfaf4b049ac76fe6c9b066a,1ef2h1sfk2ffg16sa7kbadfa74385844f28791e6e5c1,16f1h0sfk2ffg07sa4kcafdhfsfk0ffg6bsek4adfb441698f3a5eff36d4ca7,07f4h8sfk0ffg63sa5k0adf3348f6b2cba4d3937fe39,f6fah6sfk0ffg38sa7k4adf604028944deb52b3bfe6d, faf7hdsfkdffg6asackdadf954631ad082003632ede9,nyfehSsfkLffgCDsafk8adf,f9f2hfsfkcfg59saekeadf9246eeaa8da8939176523,59ffh7sfkcffgd5sa9keadf9e4f81a8e4b8a32c74b5d,8cfbh1sfk8ffg7dsa4kdadfa44c22980294546b6a614,2ff8h8sfk4ffgb5saek2adfbf440290f3d94725dc1b1,6ff9h7sfkaffg2csa6k6adf1248208917ad8617ac1e5,b3fah7sfk9ffg11sa2kcadfe34374aca920130fbc6b3, 0df0h4sfk4ffg20saak2adfdf4478b0a0dc35f7181c8,MofshzsfkWffgvrsatkjadf,47f7hdsfk0fg31sa5k7adf564956b6c6cfe67edf7fd,23f3h8sfk5ffgc6sa0keadf374695a3c6a10da3347d2,bdfdh0sfkaffgdesa1kfadf9b462db49836115c7ca9b,37fch3sfkaffg3esa8k1adfe24fa48ecc88750cca6a0,42f5h4sfkbffgc2sa9keadfc94886bda095caa28d0c1,faf9h8sfk1ffg1asa0k4adf5a4a8d92a1f012cd2f4cd, 72f1h3sfk5ffgb7sa7keadf7343ab99f19c4088b9de8,bdf9hdsfkdffg84sa4k9adf274063bcacf743fe89767,79fbh9sfkaffgcasack7adf074e8eb8b86c78a01340d,50fbh7sfkcffg86sa2kdadf5c44499da8be959e33d6c,e0f4hesfk6ffg36sa8kcadfab4e0ca2a638225c0b33c,82fdh0sfk7ffg6dsa3k9adfcf42c69d75de70913736f,48fchbsfkaffg1csa9kfadf0242749e9e606d73be869, 72feh4sfkdffg98sadk2adf1e4c28b7a4e8174529e1b,c1f7h0sfkbffgb6saak1adfaa4fa5b0f48758fe81d35,60fch4sfkaffga3sa2k3adfc042d9bccd7be1285b235,94f3hdsfkfffg62safk0adf5a4608baaa5ca31d3135e,57f4h3sfk7ffgb5saakdadf7e428fa5b992525796f67,abf2h3sfk5ffg32sack8adf534df0841c09fb0e29da3,77f9hasfk4ffg3bsa4kdadf4747d6afba5a20c8c503c, d5fbhfsfk2ffgb3sa9k3adf0d47feaa5b12e20a6ff28,d3f9hcsfkaffg9dsafk6adf3949b4aa1526c77dcc4cb,3BfKhGsfkAffgdvsankTadf,c5fch8sfk1fg17sadk8adfdf476ba82139417758962,65f7h5sfk9ffg24sa4kbadfbb4cde9f32cce9e8bb9ce,11f9hbsfk1ffg77saek6adf2c4ccebdcd139abc43f1c,b8f7h3sfk8ffg30sa4kbadf1449e786d86f0b29c98ff,3ef6h0sfk4ffg72sabk4adfa145c194aa62e0f62a31b, 1bf9hdsfk6ffg82sabkeadf364703988d1472daa0a51,8cf1h0sfk1ffge0sa1k5adf3248489887b636a11eba9,9ffdh5sfk2ffgdasaak4adfe249bda9acd383bf18cdb,0bf2hasfk6ffgc6sabk7adf094b01a3fcfaa121068e2,eefbh9sfkdffgfbsa5k6adf6f4492af13827e766b85b, 63f9h2sfkcffgbesa1k8adf2d4106ba885b8265dadd6,25fchdsfk4ffgf6sa2k1adf24463dbe6a18bee3a599d,eafchfsfk5ffg6fsa2k5adf6a4d6f82558d31299d52f,5df0h5sfk8ffg63sa4k9adfdf404194981accff69125,4ef7h7sfk9ffg1dsa3k1adfae44c994baf8a6ffc98a8, b2f9hesfkaffg8csa0keadff34c91b40ddf6dab4d160,5afchcsfk8ffg87sa5k4adfb4434a81260df0fb0c8f3,45fahesfk6ffg55sa2k5adf93460082a1148f603302a,3ef6hasfkfffgcesa2k7adf5a45b5b0f266d01be17f5,98f7h2sfk1ffg5fsack4adf4148b7861e730138f26c9, cbf6hfsfk2ffg43sa0k6adf6c4ba6853c25292256d71,31ffh3sfk3ffg07sa6k3adf5d42e893fc1edba18db89,8ef1h1sfkcffg45sack0adf8f4aeb8ceafa947094214,b7f8hcsfkfffg34saekeadf06460ea7c3da65fe0ef36,34feh4sfkfffg0bsa4k2adfe44a20a68ce130a731955, 6bf1hdsfkfffgc2sabk6adf1245a3adb8e299b4e93ec,b1f1h1sfk3ffg40sadk3adfa24e80802018856997a49,c7f2h8sfk8ffgf4sabk0adfd34fbe9663157fd5d6821,95f1h5sfk2ffg90saak5adf444653825c810e522b4a7,dcf3h9sfk8ffgaasa5kcadf3841cd8fd1e278cf2b367, 07feh3sfk2ffg0asa3kbadfb94e038a0984a4ed9139b,adf6h6sfk7ffg55sa2k2adfb943cf919e4251503cd9c,nifuhssfkiffgkSsask4adf,1dffhfsfk6fg8esa6k7adfdc47ec847da98e23ee7f2,85f8h6sfk7ffgb8safk1adf0c447cae16a123ca88c68,0ff0h6sfk2ffg17sa7k7adffb4e90a47672bc0cafc3f,6cfchdsfk6ffg6asafkfadf80460da9127ee993d822c,ANf6hhsfkdffgB1saMk8adf, bbf5h5sfkafg52sack4adfd043d0bd8a3de3337ed5f,ddfdh3sfk6ffgadsadk2adf824ec3a6cec0be173e5e6,a8f6hdsfkcffg7esa6keadf8d4039a28dfc5669756b2,8df9h2sfk0ffgf8sa7k9adf944fb6b4c1e5d3354bffc,08fbh8sfk0ffgbasa7k2adf004492b6b79a1f40f8f3a,30f3h7sfkeffg72sa3kfadf62419fbeb4b556fe3443f,e2fbh3sfkcffg3dsafk4adfb84738b3031c0bbfd5976, 60fehdsfkaffgcdsa8kfadf87417daaca5efe462da8f,d7fbh7sfk8ffgf8sa7keadf614666ba08cbe8091ef3e,e7f4h1sfk7ffg12safkdadfcd43a898106871a5e5809,Nofshnsfk0ffgfBsanktadf,3af0hcsfkdfg0dsa0k4adfb144a990284f4669572af,14f2hdsfk4ffg8dsa5kaadfaa42bba1f86eff68f405c,46f0h6sfkbffg6esa5k9adfef4bacb2f0126229b2386,c5ffh5sfk3ffgaasaekdadf0c40889dea8cadd738bf3, c8f8hcsfk2ffg55saak4adfb04da5bd73919e1390f1c,6af4h8sfk1ffg2bsa1k3adf7347ca8bb07d95545fb2c,6ff9hcsfk6ffg2bsa0kbadf1740b5a65660ee82d907c,98f3hasfk2ffg2dsafk7adfc645aa8d2c1417b4726b9,2ef9hesfk0ffgcasa2k0adf7c436e9b055b3314cd614, 6bfch3sfk4ffgc2sa3k3adf114cdd8024664efdc3ce5,6ff5h9sfk8ffg46safk8adf4f4c3e9659dc175d2f664,AAfwhdsfkSffgrhsa1kfadf,4df3hbsfk8fg4bsadk2adf284480b181eee4488bbf9,15fbh5sfkfffgb5sa9kaadf7141ed89ba83a09152b17,30f8h9sfk7ffg83safk3adfe74fc6b8dd96d91e55d09,d1fah1sfk9ffg2bsackdadfb84db5b23400431541f34,75f0h2sfk7ffgf7sa8k8adf7143a1aed974a68111774, 20f8h4sfk7ffgc9sa6kaadf8a48b488308f0a8eceef7,70f6h4sfkeffg8esa1kbadf884dcd9d667daafae6f30,69f5hcsfk9ffg3csaakeadf2e42c29ba55a38c306d5c,a2f2hbsfk4ffgb8sa4keadfc7401ca464d157a4dbb1b,8dfdhfsfk5ffg75safk0adf3748c7aad503cbd937ebc,w0fKhssfkdffgRvsaIkmadf,04f1h1sfk4fge7sa1k6adf1e4c7b9ddd46cd7d9596d,34f8h5sfkdffg62sa3k1adfe74f18a65c191354a21b2, 0af4h0sfk3ffg68sadk5adff44e08b30870ece4dbbc8,e2f4h3sfk6ffg92sa2k5adfc04848b57ccd86740d909,ddfahfsfkaffg68sa2k9adfc64c24b18459cd7c5a118,bef5hfsfk6ffgfcsa6k1adfd5466fa89db87ba69c8a5,79f5h0sfkdffgfdsa1kcadfac4f00918dfee0651bbec,96feh5sfkaffgdfsa2k8adf724e96be90cf3f03e876f,42f2h6sfk5ffg28sabkdadfe14d3da1fc25318c29fac, 14f4h4sfkcffgc7sa5k3adf44488e9699151f84b3380,3ffbhcsfk8ffg23sa0k8adf1f41c8bc8afe2679ed2be,bef4h1sfkfffgf4sa8kfadfd443fdb056b561be88833,71fdh0sfk9ffg4asa3k5adf374b7d8e0f114a636d336,c3f7hdsfkbffg28sack6adf2242538380c3c595ef030,5af8h4sfk8ffg4fsaekfadf18488595781f3e2e80bc9,47f4hcsfk0ffgd2sadk8adfd74b7a8fd639288f956db, 01f8h7sfkaffgbfsafk7adf5242449351d2df078e351,75f0h9sfk7ffg5dsa9kaadff64ecab273a7019fe21ee,69fch4sfkdffgdesafkfadfa24ceeb728ca6511f8af1,b7f7h7sfk2ffg6csafkfadf95440dba907d3f89d4f1f,1cf6h5sfk0ffgc3sackaadf0a4390ae65f1b14ab278d,a6fdh2sfk6ffg21safkcadffc40d0825f93775ef7402,8afeh6sfk0ffg06saak7adfef4b76b30a27c08d2cd87, 4cf1hcsfkeffgf6saek9adf2846e49ba5d7905b3d8b2,92f3h9sfk3ffgbdsa6keadf50450890660f4f8091454,a3f6h1sfkdffg14sa9k0adf0346b4bb8414433f4e3ba,25fchdsfk8ffg74sa0kbadf2145c0aaf62665c6f9f8a,0af4h7sfk5ffg65sa9keadf4743b3938a7a23c688cfa, 6bf8hcsfk8ffg5asa6k6adf8241138aa3d115585c17d,aef0h4sfkdffg7asa5k1adf9c4be9b6af0b085dc759e,34f3h4sfk4ffg8esa3kfadf1d4356af6c7df8bd1297e,c1fdh0sfkeffg92sadkaadf664e0f95cbf64f7e9de33,ebfch3sfkfffg6esa5k8adf3b4d50b809d4a856588ee, b0f7h0sfk7ffgf7sa8k0adfcc443e93b263f53c9e65c,9ef1h3sfkbffg7fsa3k1adf7a46c68403758f99c24f0,50f1h2sfkfffgf6saakbadfd94e0eaa301900ece3f49,IWf6hZsfkhffgvpsa0kdadf,c4f8h5sfk5fgc8sa2k6adfe24b03ba200d6560a1207, 5af7hasfk3ffgfcsa2k5adf854d48b9404fb66f52ed5,2cf7h6sfk5ffgb9sa0kfadf794c74abeb61bf176810b,ebfbh4sfk3ffg35sa9kdadf3b4a4493f865fece6bfdf,daf2h8sfkdffg47saakdadf6541a9b9cb562cc57346e,QEfMhXsfk4ffgqCsaLk6adf,7df5hdsfkbfg7asa6k1adf144b5484732340dce1152, 61f6hcsfkdffg3csa4keadf9d409b807840ccdf6ff6f,caf9h2sfk6ffg06sa1k6adf4d449ea50e394cd925407,2ff9h0sfk5ffg43sa7k9adfe44cb18e19feaae33b49d,74feh7sfk7ffge9sa6kcadf764ab0bd7ff248df1ffe1,b5f3h6sfk2ffge9saakeadf7446488df5989343444ca,34f0h0sfk1ffgdbsa1k4adfdc49be83c202a4257ef6b,34f0h1ffgdbsa1k4adfdc42a4257ef6b,2cfabeb61bf176810b- 销售数据集
sql 19234,11791,18782,13298,15889,13069,13213,18231,18988,18346,18946,13137,15051,15320,15680,15066, 15512,13585,15555,13235,18195,13888,13363,13921,17777,18088,13188,15708,13571,15888,18055,15269, 18887,18770,18539,13784,18972,15563,18163,17577,18028,15782,18080,13559,15513,15936,18971,13853, 13752,15374,13050,18622,13035,13212,15832,13680,15951,18401,13889,18333,15622,15269,18902,18991, 18000,15107,15708,13460,13689,15177,18160,18206,18508,18716,15888,18025,13704,13290,18057,18505, 18006,18620,18839,15444,15087,18955,13864,15263,18332,13482,13696,13177,15813,18763,18707,18062, 18118,15423,18567,13437,15017,18921,18432,15648,18777,13581,13090,18741,13505,18586,15986,13041, 13685,13598,18999,18226,13779,13726,18219,13102,13638,13670,15657,18171,13476,18666,18377,13711, 18928,18621,18895,13599,18111,15203,13799,13255,18599,18733,18038,18938,13687,13668,17999,13399, 15768,13679,15662,15245,15870,17993,13688,18809,13229,15666,13777,13767,13524,18020,18632,18666, 15183,18855,15333,15291,15488,18822,15888,18172,18228,18231,18668,15951,18775,13488,13156,17568, 15922,15266,15492,18024,18222,15086,17576,18850,18000,13597,17124,13701,13777,13233,18068,15999, 15669,18115,17561,18076,18445,18077,18962,18728,13494,18641,13069,15020,15051,15050,15922,13070, 15585,15411,18921,18555,18050,15005,18113,18455,13120,13121,13212,18802,18088,17863,15999,15082, 15666,15030,13663,18586,13245,15547,15293,13889,18191,15662,15839,13377,18999,15444,18788,18756, 15933,15995,18118,18090,13222,18583,15512,13155,15439,13382,18218,18053,13186,15422,15470,13466, 18199,18568,18106,15561,18252,18289,13943,18555,18857,15081,13090,13012,18625,18918,15655,13277, 13306,13893,18627,18499,13068,18797,13590,13055,17201,18234,13555,13759,15927,18770,17208,15166, 18224,15505,17858,13621,15811,13012,18335,18236,18332,18555,13030,17117
- 车商数据集
最后更新：2017-09-11 12:03:24