【多模型能力测试记录】ArgoDB分布式分析型数据库与图数据库StellarDB联合查询

前言

随着数据量的爆炸性增长和业务需求的日益复杂化，传统的单一模型数据库已经难以满足复杂多变的业务需求。尽管当前针对不同的数据类型，例如关系型数据、文档数据、图数据和时序数据业内提供了多种数据库以应对存储及处理需求，但是在实际应用中，许多场景需要将多种数据模型结合起来，以支持复杂的业务逻辑和决策分析。

统一的多模型大数据平台的出现，为解决这一问题提供了创新的思路。它能够在单一平台上同时支持多种数据模型，从而减少了跨系统整合的复杂性和成本。在联合查询场景中，多模型数据库的能力尤为重要：它不仅可以高效处理不同模型之间的数据联动，还能够为用户提供统一的查询接口，显著提高数据访问效率和开发效率。

因此，数据库联合查询的能力显得尤为重要。

基础背景介绍

ArgoDB

Transwarp ArgoDB 是星环科技自主研发的分布式分析型数据库，可以替代 Hadoop+MPP 混合架构。支持标准 SQL 语法，提供多模分析、实时数据处理、存算解耦、混合负载、数据联邦、异构服务器混合部署等先进技术能力。ArgoDB 基于多模型统一架构，支持关系型、宽表、时序、地理空间、搜索、图、向量等市面主流的 11种数据模型。通过一个 ArgoDB 数据库，就可以满足 OLAP、AETP、多模型融合分析、联邦计算、数据仓库、实时数据仓库、湖仓集一体等场景。

更多案例分享及最佳实践详见：

  • 【数据处理效率提升实践】ArgoDB如何助力企业全面实现数据处理效率最大化？
  • 【最新案例】ArgoDB新功能之读写分离，助力某医药集团打造高效数据中心，消除传统方案的灵活性限制，确保响应时间的可预测性
  • 【指标查询调优实践案例】ArgoDB助力某银行实现性能全面提升
  • 【CDH国产化替代案例】全面简化架构，降低成本，大幅提升数据处理效率

StellarDB

Transwarp StellarDB 是一款为企业级图应用而打造的分布式图数据库，用于快速查找数据间的关联关系，并提供强大的算法分析能力。StellarDB克服了万亿级关联图数据存储的难题，通过自定义图存储格式和集群化存储， 实现了传统数据库无法提供的低延时多层关系查询，在社交网络、金融领域都有巨大应用潜力。

场景示例

基于社交网络的推荐系统

  • 显式的社交网络关系已经存在于很多购物消费、休闲娱乐的产品平台中，这种社交网络的实体和实体间的关联关系都处于不断变化的过程中，比如关注列表的变化、兴趣点的变化、流行趋势的变化等等。可以使用 StellarDB 分布式图数据库存储客户的社交网络信息、购买历史记录，好友列表和感兴趣商品等关联关系数据。通过结合传统神经网络和图深度学习，融合用户兴趣爱好模型和社交网络影响，共同决定用户消费的推荐行为，从而提升用户推荐体验感。

反洗钱

  • 通过关联查询、可视化图分析、图挖掘、机器学习和规则引擎的结合使用，可快速检索关联关系数据，并挖掘隐藏关系并模型化业务经验，帮助金融机构的建立一个可持续、经济可行的反洗钱合规框架。

反欺诈

  • 结合征信、税务、诉讼、工商、企业业务系统数据等多种数据数据源类型，使用 StellarDB 构建并存储关联关系图谱，通过使用 StellarDB 内置图算法或查询功能获得图谱中图相关特征，如出入度、中心度等，基于社区发现、标签扩散等算法，融合机器学习模型，构建可疑团伙发现模型，识别风险客户和集团，降低反欺诈分析人力成本，提升效率。

于今年，社区开发版正式发布StellarDB图数据库，感兴趣的小伙伴们可以下载体验。

相关链接：

  • StellarDB图数据库社区开发版安装教程（含视频教程）
  • 使用图数据库进行人物关系探索Demo示例及教程
  • 使用图数据库进行反洗钱之银行转账流水数据分析
  • 产品下载地址
  • 更多社区版相关资源

跨多种类数据库联合查询实践

实践目的

演示星环数据库产品的异构数据分析能力

演示结论

  • 图数据处理能力支持
  • 支持图数据与关系型数据联邦查询

演示步骤

1. 创建图模型存储的表

config query.lang cypher;
create graph kg_ship_order with schema(:Employee {lastName string,firstName string,title string,titleOfCourtesy string,birthDate localdatetime,hireDate localdatetime,address string,city string,region string,postalCode string,country string,homePhone string,extension long,photo string,notes string,reportsTo int,photoPath string}) (:Customer {companyName string,contactName string,contactTitle string,address string,city string,region string,postalCode string,country string,phone string,fax string}) (:Orders {orderDate localdatetime,requiredDate localdatetime,shippedDate localdatetime,shipVia int,freight double,shipName string,shipAddress string,shipCity string,shipRegion string,shipPostalCode string,shipCountry string}) [:Buy{orderDate localdatetime,requiredDate localdatetime,shippedDate localdatetime,shipVia int,freight double,shipName string,shipAddress string,shipCity string,shipRegion string,shipPostalCode string,shipCountry string}] [:SoldBy{orderDate localdatetime,requiredDate localdatetime,shippedDate localdatetime,shipVia int,freight double,shipName string,shipAddress string,shipCity string,shipRegion string,shipPostalCode string,shipCountry string}] graphproperties: {`graph.shard.number` : 1};

2. 通过SQL批量写入图模型数据

use graph kg_ship_order;
create (Employee1:Employee {__uid: "1" , lastName:"Davolio",firstName:"Nancy",title:"Sales Representative",titleOfCourtesy:"Ms.",birthDate:localdatetime("1948-12-08T00:00:00.000"),hireDate:localdatetime("1992-05-01T00:00:00.000"),address:"507 20th Ave. E. Apt. 2A",city:"Seattle",region:"WA",postalCode:"98122",country:"USA",homePhone:"(206) 555-9857",extension:5467,photo:"0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D20540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000",notes:"Education includes a BA in psychology from Colorado State University in 1970.  She also completed The Art of the Cold Call.  Nancy is a member of Toastmasters International.",reportsTo:2,photoPath:"http://accweb/emmployees/davolio.bmp" } ), (Employee2:Employee {__uid: "2" , lastName:"Fuller",firstName:"Andrew",title:"Vice President Sales",titleOfCourtesy:"Dr.",birthDate:localdatetime("1952-02-19T00:00:00.000"),hireDate:localdatetime("1992-08-14T00:00:00.000"),address:"908 W. Capital Way",city:"Tacoma",region:"WA",postalCode:"98401",country:"USA",homePhone:"(206) 555-9482",extension:3457,photo:"0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D20540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000",notes:"Andrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the University of Dallas in 1981.  He is fluent in French and Italian and reads German.  He joined the company as a sales representative was promoted to sales manager",reportsTo:null,photoPath:"http://accweb/emmployees/fuller.bmp" } ), (Employee3:Employee {__uid: "3" , lastName:"Leverling",firstName:"Janet",title:"Sales Representative",titleOfCourtesy:"Ms.",birthDate:localdatetime("1963-08-30T00:00:00.000"),hireDate:localdatetime("1992-04-01T00:00:00.000"),address:"722 Moss Bay Blvd.",city:"Kirkland",region:"WA",postalCode:"98033",country:"USA",homePhone:"(206) 555-3412",extension:3355,photo:"0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000080540000424D80540000000000007600000028000000C0000000E0000000010004000000000000540000CE0E0000D80E0000000000",notes:"Janet has a BS degree in chemistry from Boston College (1984). She has also completed a certificate program in food retailing management.  Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992.",reportsTo:2,photoPath:"http://accweb/emmployees/leverling.bmp" } ), (Employee4:Employee {__uid: "4" , lastName:"Peacock",firstName:"Margaret",title:"Sales Representative",titleOfCourtesy:"Mrs.",birthDate:localdatetime("1937-09-19T00:00:00.000"),hireDate:localdatetime("1993-05-03T00:00:00.000"),address:"4110 Old Redmond Rd.",city:"Redmond",region:"WA",postalCode:"98052",country:"USA",homePhone:"(206) 555-8122",extension:5176,photo:"0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D20540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000",notes:"Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American Institute of Culinary Arts (1966).  She was assigned to the London office temporarily from July through November 1992.",reportsTo:2,photoPath:"http://accweb/emmployees/peacock.bmp" } ), (Employee5:Employee {__uid: "5" , lastName:"Buchanan",firstName:"Steven",title:"Sales Manager",titleOfCourtesy:"Mr.",birthDate:localdatetime("1955-03-04T00:00:00.000"),hireDate:localdatetime("1993-10-17T00:00:00.000"),address:"14 Garrett Hill",city:"London",region:null,postalCode:"SW1 8JR",country:"UK",homePhone:"(71) 555-4848",extension:3453,photo:"0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D20540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000",notes:"Steven Buchanan graduated from St. Andrews University in Scotland with a BSC degree in 1976.  Upon joining the company as a sales representative in 1992 he spent 6 months in an orientation program at the Seattle office.",reportsTo:2,photoPath:"http://accweb/emmployees/buchanan.bmp" } ), (Employee6:Employee {__uid: "6" , lastName:"Suyama",firstName:"Michael",title:"Sales Representative",titleOfCourtesy:"Mr.",birthDate:localdatetime("1963-07-02T00:00:00.000"),hireDate:localdatetime("1993-10-17T00:00:00.000"),address:"Coventry House Miner Rd.",city:"London",region:null,postalCode:"EC2 7JR",country:"UK",homePhone:"(71) 555-7773",extension:428,photo:"0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D16540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000",notes:"Michael is a graduate of Sussex University (MA Economics 1983) and the University of California at Los Angeles (MBA marketing 1986).  He has also taken the courses Multi-Cultural Selling and Time Management for the Sales Professional.",reportsTo:5,photoPath:"http://accweb/emmployees/davolio.bmp" } ), (Employee7:Employee {__uid: "7" , lastName:"King",firstName:"Robert",title:"Sales Representative",titleOfCourtesy:"Mr.",birthDate:localdatetime("1960-05-29T00:00:00.000"),hireDate:localdatetime("1994-01-02T00:00:00.000"),address:"Edgeham Hollow Winchester Way",city:"London",region:null,postalCode:"RG1 9SP",country:"UK",homePhone:"(71) 555-5598",extension:465,photo:"0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D16540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000",notes:"Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan in 1992 the year he joined the company.",reportsTo:5,photoPath:"http://accweb/emmployees/davolio.bmp" } ), (Employee8:Employee {__uid: "8" , lastName:"Callahan",firstName:"Laura",title:"Inside Sales Coordinator",titleOfCourtesy:"Ms.",birthDate:localdatetime("1958-01-09T00:00:00.000"),hireDate:localdatetime("1994-03-05T00:00:00.000"),address:"4726 11th Ave. N.E.",city:"Seattle",region:"WA",postalCode:"98105",country:"USA",homePhone:"(206) 555-1189",extension:2344,photo:"0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D16540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000",notes:"Laura received a BA in psychology from the University of Washington.  She has also completed a course in business French.  She reads and writes French.",reportsTo:2,photoPath:"http://accweb/emmployees/davolio.bmp" } ), (Employee9:Employee {__uid: "9" , lastName:"Dodsworth",firstName:"Anne",title:"Sales Representative",titleOfCourtesy:"Ms.",birthDate:localdatetime("1966-01-27T00:00:00.000"),hireDate:localdatetime("1994-11-15T00:00:00.000"),address:"7 Houndstooth Rd.",city:"London",region:null,postalCode:"WG2 7LT",country:"UK",homePhone:"(71) 555-4444",extension:452,photo:"0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D16540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000",notes:"Anne has a BA degree in English from St. Lawrence College.  She is fluent in French and German.",reportsTo:5,photoPath:"http://accweb/emmployees/davolio.bmp" } );create (CustomerALFKI:Customer {__uid: "ALFKI" , companyName:"Alfreds Futterkiste",contactName:"Maria Anders",contactTitle:"Sales Representative",address:"Obere Str. 57",city:"Berlin",region:null,postalCode:"12209",country:"Germany",phone:"030-0074321",fax:"030-0076545" } ), (CustomerANATR:Customer {__uid: "ANATR" , companyName:"Ana Trujillo Emparedados y helados",contactName:"Ana Trujillo",contactTitle:"Owner",address:"Avda. de la Constitución 2222",city:"México D.F.",region:null,postalCode:"05021",country:"Mexico",phone:"(5) 555-4729",fax:"(5) 555-3745" } ), (CustomerANTON:Customer {__uid: "ANTON" , companyName:"Antonio Moreno Taquería",contactName:"Antonio Moreno",contactTitle:"Owner",address:"Mataderos  2312",city:"México D.F.",region:null,postalCode:"05023",country:"Mexico",phone:"(5) 555-3932",fax:null } ), (CustomerAROUT:Customer {__uid: "AROUT" , companyName:"Around the Horn",contactName:"Thomas Hardy",contactTitle:"Sales Representative",address:"120 Hanover Sq.",city:"London",region:null,postalCode:"WA1 1DP",country:"UK",phone:"(171) 555-7788",fax:"(171) 555-6750" } ), (CustomerBERGS:Customer {__uid: "BERGS" , companyName:"Berglunds snabbköp",contactName:"Christina Berglund",contactTitle:"Order Administrator",address:"Berguvsvägen  8",city:"Luleå",region:null,postalCode:"S-958 22",country:"Sweden",phone:"0921-12 34 65",fax:"0921-12 34 67" } ), (CustomerBLAUS:Customer {__uid: "BLAUS" , companyName:"Blauer See Delikatessen",contactName:"Hanna Moos",contactTitle:"Sales Representative",address:"Forsterstr. 57",city:"Mannheim",region:null,postalCode:"68306",country:"Germany",phone:"0621-08460",fax:"0621-08924" } ), (CustomerBLONP:Customer {__uid: "BLONP" , companyName:"Blondesddsl père et fils",contactName:"Frédérique Citeaux",contactTitle:"Marketing Manager",address:"24 place Kléber",city:"Strasbourg",region:null,postalCode:"67000",country:"France",phone:"88.60.15.31",fax:"88.60.15.32" } ), (CustomerBOLID:Customer {__uid: "BOLID" , companyName:"Bólido Comidas preparadas",contactName:"Martín Sommer",contactTitle:"Owner",address:"67C Araquil",city:"Madrid",region:null,postalCode:"28023",country:"Spain",phone:"(91) 555 22 82",fax:"(91) 555 91 99" } ), (CustomerBONAP:Customer {__uid: "BONAP" , companyName:"Bon app'",contactName:"Laurence Lebihan",contactTitle:"Owner",address:"12 rue des Bouchers",city:"Marseille",region:null,postalCode:"13008",country:"France",phone:"91.24.45.40",fax:"91.24.45.41" } ), (CustomerBOTTM:Customer {__uid: "BOTTM" , companyName:"Bottom-Dollar Markets",contactName:"Elizabeth Lincoln",contactTitle:"Accounting Manager",address:"23 Tsawassen Blvd.",city:"Tsawassen",region:"BC",postalCode:"T2F 8M4",country:"Canada",phone:"(604) 555-4729",fax:"(604) 555-3745" } ), (CustomerBSBEV:Customer {__uid: "BSBEV" , companyName:"B's Beverages",contactName:"Victoria Ashworth",contactTitle:"Sales Representative",address:"Fauntleroy Circus",city:"London",region:null,postalCode:"EC2 5NT",country:"UK",phone:"(171) 555-1212",fax:null } ), (CustomerCACTU:Customer {__uid: "CACTU" , companyName:"Cactus Comidas para llevar",contactName:"Patricio Simpson",contactTitle:"Sales Agent",address:"Cerrito 333",city:"Buenos Aires",region:null,postalCode:"1010",country:"Argentina",phone:"(1) 135-5555",fax:"(1) 135-4892" } ), (CustomerCENTC:Customer {__uid: "CENTC" , companyName:"Centro comercial Moctezuma",contactName:"Francisco Chang",contactTitle:"Marketing Manager",address:"Sierras de Granada 9993",city:"México D.F.",region:null,postalCode:"05022",country:"Mexico",phone:"(5) 555-3392",fax:"(5) 555-7293" } ), (CustomerCHOPS:Customer {__uid: "CHOPS" , companyName:"Chop-suey Chinese",contactName:"Yang Wang",contactTitle:"Owner",address:"Hauptstr. 29",city:"Bern",region:null,postalCode:"3012",country:"Switzerland",phone:"0452-076545",fax:null } ), (CustomerCOMMI:Customer {__uid: "COMMI" , companyName:"Comércio Mineiro",contactName:"Pedro Afonso",contactTitle:"Sales Associate",address:"23 Av. dos Lusíadas",city:"Sao Paulo",region:"SP",postalCode:"05432-043",country:"Brazil",phone:"(11) 555-7647",fax:null } ), (CustomerCONSH:Customer {__uid: "CONSH" , companyName:"Consolidated Holdings",contactName:"Elizabeth Brown",contactTitle:"Sales Representative",address:"Berkeley Gardens 12  Brewery",city:"London",region:null,postalCode:"WX1 6LT",country:"UK",phone:"(171) 555-2282",fax:"(171) 555-9199" } ), (CustomerDRACD:Customer {__uid: "DRACD" , companyName:"Drachenblut Delikatessen",contactName:"Sven Ottlieb",contactTitle:"Order Administrator",address:"Walserweg 21",city:"Aachen",region:null,postalCode:"52066",country:"Germany",phone:"0241-039123",fax:"0241-059428" } ), (CustomerDUMON:Customer {__uid: "DUMON" , companyName:"Du monde entier",contactName:"Janine Labrune",contactTitle:"Owner",address:"67 rue des Cinquante Otages",city:"Nantes",region:null,postalCode:"44000",country:"France",phone:"40.67.88.88",fax:"40.67.89.89" } ), (CustomerEASTC:Customer {__uid: "EASTC" , companyName:"Eastern Connection",contactName:"Ann Devon",contactTitle:"Sales Agent",address:"35 King George",city:"London",region:null,postalCode:"WX3 6FW",country:"UK",phone:"(171) 555-0297",fax:"(171) 555-3373" } ), (CustomerERNSH:Customer {__uid: "ERNSH" , companyName:"Ernst Handel",contactName:"Roland Mendel",contactTitle:"Sales Manager",address:"Kirchgasse 6",city:"Graz",region:null,postalCode:"8010",country:"Austria",phone:"7675-3425",fax:"7675-3426" } ), (CustomerFAMIA:Customer {__uid: "FAMIA" , companyName:"Familia Arquibaldo",contactName:"Aria Cruz",contactTitle:"Marketing Assistant",address:"Rua Orós 92",city:"Sao Paulo",region:"SP",postalCode:"05442-030",country:"Brazil",phone:"(11) 555-9857",fax:null } ), (CustomerFISSA:Customer {__uid: "FISSA" , companyName:"FISSA Fabrica Inter. Salchichas S.A.",contactName:"Diego Roel",contactTitle:"Accounting Manager",address:"C/ Moralzarzal 86",city:"Madrid",region:null,postalCode:"28034",country:"Spain",phone:"(91) 555 94 44",fax:"(91) 555 55 93" } ), (CustomerFOLIG:Customer {__uid: "FOLIG" , companyName:"Folies gourmandes",contactName:"Martine Rancé",contactTitle:"Assistant Sales Agent",address:"184 chaussée de Tournai",city:"Lille",region:null,postalCode:"59000",country:"France",phone:"20.16.10.16",fax:"20.16.10.17" } ), (CustomerFOLKO:Customer {__uid: "FOLKO" , companyName:"Folk och fä HB",contactName:"Maria Larsson",contactTitle:"Owner",address:"Åkergatan 24",city:"Bräcke",region:null,postalCode:"S-844 67",country:"Sweden",phone:"0695-34 67 21",fax:null } ), (CustomerFRANK:Customer {__uid: "FRANK" , companyName:"Frankenversand",contactName:"Peter Franken",contactTitle:"Marketing Manager",address:"Berliner Platz 43",city:"München",region:null,postalCode:"80805",country:"Germany",phone:"089-0877310",fax:"089-0877451" } ), (CustomerFRANR:Customer {__uid: "FRANR" , companyName:"France restauration",contactName:"Carine Schmitt",contactTitle:"Marketing Manager",address:"54 rue Royale",city:"Nantes",region:null,postalCode:"44000",country:"France",phone:"40.32.21.21",fax:"40.32.21.20" } ), (CustomerFRANS:Customer {__uid: "FRANS" , companyName:"Franchi S.p.A.",contactName:"Paolo Accorti",contactTitle:"Sales Representative",address:"Via Monte Bianco 34",city:"Torino",region:null,postalCode:"10100",country:"Italy",phone:"011-4988260",fax:"011-4988261" } ), (CustomerFURIB:Customer {__uid: "FURIB" , companyName:"Furia Bacalhau e Frutos do Mar",contactName:"Lino Rodriguez",contactTitle:"Sales Manager",address:"Jardim das rosas n. 32",city:"Lisboa",region:null,postalCode:"1675",country:"Portugal",phone:"(1) 354-2534",fax:"(1) 354-2535" } ), (CustomerGALED:Customer {__uid: "GALED" , companyName:"Galería del gastrónomo",contactName:"Eduardo Saavedra",contactTitle:"Marketing Manager",address:"Rambla de Cataluña 23",city:"Barcelona",region:null,postalCode:"08022",country:"Spain",phone:"(93) 203 4560",fax:"(93) 203 4561" } ), (CustomerGODOS:Customer {__uid: "GODOS" , companyName:"Godos Cocina Típica",contactName:"José Pedro Freyre",contactTitle:"Sales Manager",address:"C/ Romero 33",city:"Sevilla",region:null,postalCode:"41101",country:"Spain",phone:"(95) 555 82 82",fax:null } ), (CustomerGOURL:Customer {__uid: "GOURL" , companyName:"Gourmet Lanchonetes",contactName:"André Fonseca",contactTitle:"Sales Associate",address:"Av. Brasil 442",city:"Campinas",region:"SP",postalCode:"04876-786",country:"Brazil",phone:"(11) 555-9482",fax:null } ), (CustomerGREAL:Customer {__uid: "GREAL" , companyName:"Great Lakes Food Market",contactName:"Howard Snyder",contactTitle:"Marketing Manager",address:"2732 Baker Blvd.",city:"Eugene",region:"OR",postalCode:"97403",country:"USA",phone:"(503) 555-7555",fax:null } ), (CustomerGROSR:Customer {__uid: "GROSR" , companyName:"GROSELLA-Restaurante",contactName:"Manuel Pereira",contactTitle:"Owner",address:"5ª Ave. Los Palos Grandes",city:"Caracas",region:"DF",postalCode:"1081",country:"Venezuela",phone:"(2) 283-2951",fax:"(2) 283-3397" } ), (CustomerHANAR:Customer {__uid: "HANAR" , companyName:"Hanari Carnes",contactName:"Mario Pontes",contactTitle:"Accounting Manager",address:"Rua do Paço 67",city:"Rio de Janeiro",region:"RJ",postalCode:"05454-876",country:"Brazil",phone:"(21) 555-0091",fax:"(21) 555-8765" } ), (CustomerHILAA:Customer {__uid: "HILAA" , companyName:"HILARION-Abastos",contactName:"Carlos Hernández",contactTitle:"Sales Representative",address:"Carrera 22 con Ave. Carlos Soublette #8-35",city:"San Cristóbal",region:"Táchira",postalCode:"5022",country:"Venezuela",phone:"(5) 555-1340",fax:"(5) 555-1948" } ), (CustomerHUNGC:Customer {__uid: "HUNGC" , companyName:"Hungry Coyote Import Store",contactName:"Yoshi Latimer",contactTitle:"Sales Representative",address:"City Center Plaza 516 Main St.",city:"Elgin",region:"OR",postalCode:"97827",country:"USA",phone:"(503) 555-6874",fax:"(503) 555-2376" } ), (CustomerHUNGO:Customer {__uid: "HUNGO" , companyName:"Hungry Owl All-Night Grocers",contactName:"Patricia McKenna",contactTitle:"Sales Associate",address:"8 Johnstown Road",city:"Cork",region:"Co. Cork",postalCode:"NULL",country:"Ireland",phone:"2967 542",fax:"2967 3333" } ), (CustomerISLAT:Customer {__uid: "ISLAT" , companyName:"Island Trading",contactName:"Helen Bennett",contactTitle:"Marketing Manager",address:"Garden House Crowther Way",city:"Cowes",region:"Isle of Wight",postalCode:"PO31 7PJ",country:"UK",phone:"(198) 555-8888",fax:null } ), (CustomerKOENE:Customer {__uid: "KOENE" , companyName:"Königlich Essen",contactName:"Philip Cramer",contactTitle:"Sales Associate",address:"Maubelstr. 90",city:"Brandenburg",region:null,postalCode:"14776",country:"Germany",phone:"0555-09876",fax:null } ), (CustomerLACOR:Customer {__uid: "LACOR" , companyName:"La corne d'abondance",contactName:"Daniel Tonini",contactTitle:"Sales Representative",address:"67 avenue de l'Europe",city:"Versailles",region:null,postalCode:"78000",country:"France",phone:"30.59.84.10",fax:"30.59.85.11" } ), (CustomerLAMAI:Customer {__uid: "LAMAI" , companyName:"La maison d'Asie",contactName:"Annette Roulet",contactTitle:"Sales Manager",address:"1 rue Alsace-Lorraine",city:"Toulouse",region:null,postalCode:"31000",country:"France",phone:"61.77.61.10",fax:"61.77.61.11" } ), (CustomerLAUGB:Customer {__uid: "LAUGB" , companyName:"Laughing Bacchus Wine Cellars",contactName:"Yoshi Tannamuri",contactTitle:"Marketing Assistant",address:"1900 Oak St.",city:"Vancouver",region:"BC",postalCode:"V3F 2K1",country:"Canada",phone:"(604) 555-3392",fax:"(604) 555-7293" } ), (CustomerLAZYK:Customer {__uid: "LAZYK" , companyName:"Lazy K Kountry Store",contactName:"John Steel",contactTitle:"Marketing Manager",address:"12 Orchestra Terrace",city:"Walla Walla",region:"WA",postalCode:"99362",country:"USA",phone:"(509) 555-7969",fax:"(509) 555-6221" } ), (CustomerLEHMS:Customer {__uid: "LEHMS" , companyName:"Lehmanns Marktstand",contactName:"Renate Messner",contactTitle:"Sales Representative",address:"Magazinweg 7",city:"Frankfurt a.M.",region:null,postalCode:"60528",country:"Germany",phone:"069-0245984",fax:"069-0245874" } ), (CustomerLETSS:Customer {__uid: "LETSS" , companyName:"Let's Stop N Shop",contactName:"Jaime Yorres",contactTitle:"Owner",address:"87 Polk St. Suite 5",city:"San Francisco",region:"CA",postalCode:"94117",country:"USA",phone:"(415) 555-5938",fax:null } ), (CustomerLILAS:Customer {__uid: "LILAS" , companyName:"LILA-Supermercado",contactName:"Carlos González",contactTitle:"Accounting Manager",address:"Carrera 52 con Ave. Bolívar #65-98 Llano Largo",city:"Barquisimeto",region:"Lara",postalCode:"3508",country:"Venezuela",phone:"(9) 331-6954",fax:"(9) 331-7256" } ), (CustomerLINOD:Customer {__uid: "LINOD" , companyName:"LINO-Delicateses",contactName:"Felipe Izquierdo",contactTitle:"Owner",address:"Ave. 5 de Mayo Porlamar",city:"I. de Margarita",region:"Nueva Esparta",postalCode:"4980",country:"Venezuela",phone:"(8) 34-56-12",fax:"(8) 34-93-93" } ), (CustomerLONEP:Customer {__uid: "LONEP" , companyName:"Lonesome Pine Restaurant",contactName:"Fran Wilson",contactTitle:"Sales Manager",address:"89 Chiaroscuro Rd.",city:"Portland",region:"OR",postalCode:"97219",country:"USA",phone:"(503) 555-9573",fax:"(503) 555-9646" } ), (CustomerMAGAA:Customer {__uid: "MAGAA" , companyName:"Magazzini Alimentari Riuniti",contactName:"Giovanni Rovelli",contactTitle:"Marketing Manager",address:"Via Ludovico il Moro 22",city:"Bergamo",region:null,postalCode:"24100",country:"Italy",phone:"035-640230",fax:"035-640231" } ), (CustomerMAISD:Customer {__uid: "MAISD" , companyName:"Maison Dewey",contactName:"Catherine Dewey",contactTitle:"Sales Agent",address:"Rue Joseph-Bens 532",city:"Bruxelles",region:null,postalCode:"B-1180",country:"Belgium",phone:"(02) 201 24 67",fax:"(02) 201 24 68" } ), (CustomerMEREP:Customer {__uid: "MEREP" , companyName:"Mère Paillarde",contactName:"Jean Fresnière",contactTitle:"Marketing Assistant",address:"43 rue St. Laurent",city:"Montréal",region:"Québec",postalCode:"H1J 1C3",country:"Canada",phone:"(514) 555-8054",fax:"(514) 555-8055" } ), (CustomerMORGK:Customer {__uid: "MORGK" , companyName:"Morgenstern Gesundkost",contactName:"Alexander Feuer",contactTitle:"Marketing Assistant",address:"Heerstr. 22",city:"Leipzig",region:null,postalCode:"04179",country:"Germany",phone:"0342-023176",fax:null } ), (CustomerNORTS:Customer {__uid: "NORTS" , companyName:"North/South",contactName:"Simon Crowther",contactTitle:"Sales Associate",address:"South House 300 Queensbridge",city:"London",region:null,postalCode:"SW7 1RZ",country:"UK",phone:"(171) 555-7733",fax:"(171) 555-2530" } ), (CustomerOCEAN:Customer {__uid: "OCEAN" , companyName:"Océano Atlántico Ltda.",contactName:"Yvonne Moncada",contactTitle:"Sales Agent",address:"Ing. Gustavo Moncada 8585 Piso 20-A",city:"Buenos Aires",region:null,postalCode:"1010",country:"Argentina",phone:"(1) 135-5333",fax:"(1) 135-5535" } ), (CustomerOLDWO:Customer {__uid: "OLDWO" , companyName:"Old World Delicatessen",contactName:"Rene Phillips",contactTitle:"Sales Representative",address:"2743 Bering St.",city:"Anchorage",region:"AK",postalCode:"99508",country:"USA",phone:"(907) 555-7584",fax:"(907) 555-2880" } ), (CustomerOTTIK:Customer {__uid: "OTTIK" , companyName:"Ottilies Käseladen",contactName:"Henriette Pfalzheim",contactTitle:"Owner",address:"Mehrheimerstr. 369",city:"Köln",region:null,postalCode:"50739",country:"Germany",phone:"0221-0644327",fax:"0221-0765721" } ), (CustomerPARIS:Customer {__uid: "PARIS" , companyName:"Paris spécialités",contactName:"Marie Bertrand",contactTitle:"Owner",address:"265 boulevard Charonne",city:"Paris",region:null,postalCode:"75012",country:"France",phone:"(1) 42.34.22.66",fax:"(1) 42.34.22.77" } ), (CustomerPERIC:Customer {__uid: "PERIC" , companyName:"Pericles Comidas clásicas",contactName:"Guillermo Fernández",contactTitle:"Sales Representative",address:"Calle Dr. Jorge Cash 321",city:"México D.F.",region:null,postalCode:"05033",country:"Mexico",phone:"(5) 552-3745",fax:"(5) 545-3745" } ), (CustomerPICCO:Customer {__uid: "PICCO" , companyName:"Piccolo und mehr",contactName:"Georg Pipps",contactTitle:"Sales Manager",address:"Geislweg 14",city:"Salzburg",region:null,postalCode:"5020",country:"Austria",phone:"6562-9722",fax:"6562-9723" } ), (CustomerPRINI:Customer {__uid: "PRINI" , companyName:"Princesa Isabel Vinhos",contactName:"Isabel de Castro",contactTitle:"Sales Representative",address:"Estrada da saúde n. 58",city:"Lisboa",region:null,postalCode:"1756",country:"Portugal",phone:"(1) 356-5634",fax:null } ), (CustomerQUEDE:Customer {__uid: "QUEDE" , companyName:"Que Delícia",contactName:"Bernardo Batista",contactTitle:"Accounting Manager",address:"Rua da Panificadora",city:" 12Rio de Janeiro",region:"RJ",postalCode:"02389-673",country:"Brazil",phone:"(21) 555-4252",fax:"(21) 555-4545" } ), (CustomerQUEEN:Customer {__uid: "QUEEN" , companyName:"Queen Cozinha",contactName:"Lúcia Carvalho",contactTitle:"Marketing Assistant",address:"Alameda dos Canàrios 891",city:"Sao Paulo",region:"SP",postalCode:"05487-020",country:"Brazil",phone:"(11) 555-1189",fax:null } ), (CustomerQUICK:Customer {__uid: "QUICK" , companyName:"QUICK-Stop",contactName:"Horst Kloss",contactTitle:"Accounting Manager",address:"Taucherstraße 10",city:"Cunewalde",region:null,postalCode:"01307",country:"Germany",phone:"0372-035188",fax:null } ), (CustomerRANCH:Customer {__uid: "RANCH" , companyName:"Rancho grande",contactName:"Sergio Gutiérrez",contactTitle:"Sales Representative",address:"Av. del Libertador 900",city:"Buenos Aires",region:null,postalCode:"1010",country:"Argentina",phone:"(1) 123-5555",fax:"(1) 123-5556" } ), (CustomerRATTC:Customer {__uid: "RATTC" , companyName:"Rattlesnake Canyon Grocery",contactName:"Paula Wilson",contactTitle:"Assistant Sales Representative",address:"2817 Milton Dr.",city:"Albuquerque",region:"NM",postalCode:"87110",country:"USA",phone:"(505) 555-5939",fax:"(505) 555-3620" } ), (CustomerREGGC:Customer {__uid: "REGGC" , companyName:"Reggiani Caseifici",contactName:"Maurizio Moroni",contactTitle:"Sales Associate",address:"Strada Provinciale 124",city:"Reggio Emilia",region:null,postalCode:"42100",country:"Italy",phone:"0522-556721",fax:"0522-556722" } ), (CustomerRICAR:Customer {__uid: "RICAR" , companyName:"Ricardo Adocicados",contactName:"Janete Limeira",contactTitle:"Assistant Sales Agent",address:"Av. Copacabana 267",city:"Rio de Janeiro",region:"RJ",postalCode:"02389-890",country:"Brazil",phone:"(21) 555-3412",fax:null } ), (CustomerRICSU:Customer {__uid: "RICSU" , companyName:"Richter Supermarkt",contactName:"Michael Holz",contactTitle:"Sales Manager",address:"Grenzacherweg 237",city:"Genève",region:null,postalCode:"1203",country:"Switzerland",phone:"0897-034214",fax:null } ), (CustomerROMEY:Customer {__uid: "ROMEY" , companyName:"Romero y tomillo",contactName:"Alejandra Camino",contactTitle:"Accounting Manager",address:"Gran Vía 1",city:"Madrid",region:null,postalCode:"28001",country:"Spain",phone:"(91) 745 6200",fax:"(91) 745 6210" } ), (CustomerSANTG:Customer {__uid: "SANTG" , companyName:"Santé Gourmet",contactName:"Jonas Bergulfsen",contactTitle:"Owner",address:"Erling Skakkes gate 78",city:"Stavern",region:null,postalCode:"4110",country:"Norway",phone:"07-98 92 35",fax:"07-98 92 47" } ), (CustomerSAVEA:Customer {__uid: "SAVEA" , companyName:"Save-a-lot Markets",contactName:"Jose Pavarotti",contactTitle:"Sales Representative",address:"187 Suffolk Ln.",city:"Boise",region:"ID",postalCode:"83720",country:"USA",phone:"(208) 555-8097",fax:null } ), (CustomerSEVES:Customer {__uid: "SEVES" , companyName:"Seven Seas Imports",contactName:"Hari Kumar",contactTitle:"Sales Manager",address:"90 Wadhurst Rd.",city:"London",region:null,postalCode:"OX15 4NB",country:"UK",phone:"(171) 555-1717",fax:"(171) 555-5646" } ), (CustomerSIMOB:Customer {__uid: "SIMOB" , companyName:"Simons bistro",contactName:"Jytte Petersen",contactTitle:"Owner",address:"Vinbæltet 34",city:"Kobenhavn",region:null,postalCode:"1734",country:"Denmark",phone:"31 12 34 56",fax:"31 13 35 57" } ), (CustomerSPECD:Customer {__uid: "SPECD" , companyName:"Spécialités du monde",contactName:"Dominique Perrier",contactTitle:"Marketing Manager",address:"25 rue Lauriston",city:"Paris",region:null,postalCode:"75016",country:"France",phone:"(1) 47.55.60.10",fax:"(1) 47.55.60.20" } ), (CustomerSPLIR:Customer {__uid: "SPLIR" , companyName:"Split Rail Beer & Ale",contactName:"Art Braunschweiger",contactTitle:"Sales Manager",address:"P.O. Box 555",city:"Lander",region:"WY",postalCode:"82520",country:"USA",phone:"(307) 555-4680",fax:"(307) 555-6525" } ), (CustomerSUPRD:Customer {__uid: "SUPRD" , companyName:"Suprêmes délices",contactName:"Pascale Cartrain",contactTitle:"Accounting Manager",address:"Boulevard Tirou 255",city:"Charleroi",region:null,postalCode:"B-6000",country:"Belgium",phone:"(071) 23 67 22 20",fax:"(071) 23 67 22 21" } ), (CustomerTHEBI:Customer {__uid: "THEBI" , companyName:"The Big Cheese",contactName:"Liz Nixon",contactTitle:"Marketing Manager",address:"89 Jefferson Way Suite 2",city:"Portland",region:"OR",postalCode:"97201",country:"USA",phone:"(503) 555-3612",fax:null } ), (CustomerTHECR:Customer {__uid: "THECR" , companyName:"The Cracker Box",contactName:"Liu Wong",contactTitle:"Marketing Assistant",address:"55 Grizzly Peak Rd.",city:"Butte",region:"MT",postalCode:"59801",country:"USA",phone:"(406) 555-5834",fax:"(406) 555-8083" } ), (CustomerTOMSP:Customer {__uid: "TOMSP" , companyName:"Toms Spezialitäten",contactName:"Karin Josephs",contactTitle:"Marketing Manager",address:"Luisenstr. 48",city:"Münster",region:null,postalCode:"44087",country:"Germany",phone:"0251-031259",fax:"0251-035695" } ), (CustomerTORTU:Customer {__uid: "TORTU" , companyName:"Tortuga Restaurante",contactName:"Miguel Angel Paolino",contactTitle:"Owner",address:"Avda. Azteca 123",city:"México D.F.",region:null,postalCode:"05033",country:"Mexico",phone:"(5) 555-2933",fax:null } ), (CustomerTRADH:Customer {__uid: "TRADH" , companyName:"Tradição Hipermercados",contactName:"Anabela Domingues",contactTitle:"Sales Representative",address:"Av. Inês de Castro 414",city:"Sao Paulo",region:"SP",postalCode:"05634-030",country:"Brazil",phone:"(11) 555-2167",fax:"(11) 555-2168" } ), (CustomerTRAIH:Customer {__uid: "TRAIH" , companyName:"Trail's Head Gourmet Provisioners",contactName:"Helvetius Nagy",contactTitle:"Sales Associate",address:"722 DaVinci Blvd.",city:"Kirkland",region:"WA",postalCode:"98034",country:"USA",phone:"(206) 555-8257",fax:"(206) 555-2174" } ), (CustomerVAFFE:Customer {__uid: "VAFFE" , companyName:"Vaffeljernet",contactName:"Palle Ibsen",contactTitle:"Sales Manager",address:"Smagsloget 45",city:"Århus",region:null,postalCode:"8200",country:"Denmark",phone:"86 21 32 43",fax:"86 22 33 44" } ), (CustomerVICTE:Customer {__uid: "VICTE" , companyName:"Victuailles en stock",contactName:"Mary Saveley",contactTitle:"Sales Agent",address:"2 rue du Commerce",city:"Lyon",region:null,postalCode:"69004",country:"France",phone:"78.32.54.86",fax:"78.32.54.87" } ), (CustomerVINET:Customer {__uid: "VINET" , companyName:"Vins et alcools Chevalier",contactName:"Paul Henriot",contactTitle:"Accounting Manager",address:"59 rue de l'Abbaye",city:"Reims",region:null,postalCode:"51100",country:"France",phone:"26.47.15.10",fax:"26.47.15.11" } ), (CustomerWANDK:Customer {__uid: "WANDK" , companyName:"Die Wandernde Kuh",contactName:"Rita Müller",contactTitle:"Sales Representative",address:"Adenauerallee 900",city:"Stuttgart",region:null,postalCode:"70563",country:"Germany",phone:"0711-020361",fax:"0711-035428" } ), (CustomerWARTH:Customer {__uid: "WARTH" , companyName:"Wartian Herkku",contactName:"Pirkko Koskitalo",contactTitle:"Accounting Manager",address:"Torikatu 38",city:"Oulu",region:null,postalCode:"90110",country:"Finland",phone:"981-443655",fax:"981-443655" } ), (CustomerWELLI:Customer {__uid: "WELLI" , companyName:"Wellington Importadora",contactName:"Paula Parente",contactTitle:"Sales Manager",address:"Rua do Mercado 12",city:"Resende",region:"SP",postalCode:"08737-363",country:"Brazil",phone:"(14) 555-8122",fax:null } ), (CustomerWHITC:Customer {__uid: "WHITC" , companyName:"White Clover Markets",contactName:"Karl Jablonski",contactTitle:"Owner",address:"305 - 14th Ave. S. Suite 3B",city:"Seattle",region:"WA",postalCode:"98128",country:"USA",phone:"(206) 555-4112",fax:"(206) 555-4115" } ), (CustomerWILMK:Customer {__uid: "WILMK" , companyName:"Wilman Kala",contactName:"Matti Karttunen",contactTitle:"Owner/Marketing Assistant",address:"Keskuskatu 45",city:"Helsinki",region:null,postalCode:"21240",country:"Finland",phone:"90-224 8858",fax:"90-224 8858" } ), (CustomerWOLZA:Customer {__uid: "WOLZA" , companyName:"Wolski  Zajazd",contactName:"Zbyszek Piestrzeniewicz",contactTitle:"Owner",address:"ul. Filtrowa 68",city:"Warszawa",region:null,postalCode:"01-012",country:"Poland",phone:"(26) 642-7012",fax:"(26) 642-7012" } );create (Orders10248:Orders {__uid: "10248" , orderDate:localdatetime("1996-07-04T00:00:00.000"),requiredDate:localdatetime("1996-08-01T00:00:00.000"),shippedDate:localdatetime("1996-07-16T00:00:00.000"),shipVia:3,freight:32.38,shipName:"Vins et alcools Chevalier",shipAddress:"59 rue de l'Abbaye",shipCity:"Reims",shipRegion:null,shipPostalCode:"51100",shipCountry:"France" } );match (a:Employee{__uid:"1"}),(b:Employee{__uid:"2"}) create (a)-[f:Buy]-(b);

3. 通过cypher语言查询图数据

select * from $cypher<<'use graph kg_ship_order;match (a:Employee {__uid:"1"}),(b:Employee {__uid:"2"}) return tostring(a.__uid),tostring(b.__uid);'>> as t1;

4. 通过SQL查询MPP和图表的关联结果

--创建HOLO表并导入数据
config query.lang sql;
use default;
drop table default.holo_table;
create table holo_table (lastname string, firstname string, height double) stored as holodesk;
insert into holo_table select 'e1','holo1',0.9291935091360196 from system.dual;
insert into holo_table select 'Fuller','Andrew',0.9291935091360196 from system.dual;
insert into holo_table select 'Fuller','Andrew',0.9291935091360196 from system.dual;

5. 通过SQL查询MPP和图表的关联结果

1） 内连接
select * from $cypher<<'use graph kg_ship_order;match (e:Employee) return toString(e.lastName) as lastName, toLocaldatetime(e.birthDate) as birthDate, toInteger(e.reportsTo) as reportsTo, toLong(e.extension) as extension;'>> as ship2 join holo_table on ship2.lastname=holo_table.lastname;
2） 外连接
set inceptor.cross.join.enabled=true;select * from $cypher<<'use graph kg_ship_order;match (e:Employee) return toString(e.lastName) as lastName, toLocaldatetime(e.birthDate) as birthDate, toInteger(e.reportsTo) as reportsTo, toLong(e.extension) as extension;'>> as ship1 left outer join holo_table;
select * from $cypher<<'use graph kg_ship_order;match (e:Employee) return toString(e.lastName) as lastName, toLocaldatetime(e.birthDate) as birthDate, toInteger(e.reportsTo) as reportsTo, toLong(e.extension) as extension;'>> as ship1 right outer join holo_table;
select * from $cypher<<'use graph kg_ship_order;match (e:Employee) return toString(e.lastName) as lastName, toLocaldatetime(e.birthDate) as birthDate, toInteger(e.reportsTo) as reportsTo, toLong(e.extension) as extension;'>> as ship1 full outer join holo_table;

3） 不等价连接
select * from $cypher<<'use graph kg_ship_order;match (e:Employee) return toString(e.lastName) as lastName, toString(e.firstName) as firstName, toLocaldatetime(e.birthDate) as birthDate, toInteger(e.reportsTo) as reportsTo, toLong(e.extension) as extension;'>> as ship1 join holo_table on ship1.lastname=holo_table.lastname where ship1.extension > holo_table.height;

4） 将图和表进行join操作，并测试是否支持min、max、sum、count、avg等聚合函数
select sum(height) from $cypher<<'use graph kg_ship_order;match (e:Employee) return toString(e.lastName) as lastName, toLocaldatetime(e.birthDate) as birthDate, toInteger(e.reportsTo) as reportsTo, toLong(e.extension) as extension;'>> as ship1 join holo_table on ship1.lastname=holo_table.lastname;select max(height) from $cypher<<'use graph kg_ship_order;match (e:Employee) return toString(e.lastName) as lastName, toLocaldatetime(e.birthDate) as birthDate, toInteger(e.reportsTo) as reportsTo, toLong(e.extension) as extension;'>> as ship1 join holo_table on ship1.lastname=holo_table.lastname;select min(height) from $cypher<<'use graph kg_ship_order;match (e:Employee) return toString(e.lastName) as lastName, toLocaldatetime(e.birthDate) as birthDate, toInteger(e.reportsTo) as reportsTo, toLong(e.extension) as extension;'>> as ship1 join holo_table on ship1.lastname=holo_table.lastname;select count(height) from $cypher<<'use graph kg_ship_order;match (e:Employee) return toString(e.lastName) as lastName, toLocaldatetime(e.birthDate) as birthDate, toInteger(e.reportsTo) as reportsTo, toLong(e.extension) as extension;'>> as ship1 join holo_table on ship1.lastname=holo_table.lastname;select avg(height) from $cypher<<'use graph kg_ship_order;match (e:Employee) return toString(e.lastName) as lastName, toLocaldatetime(e.birthDate) as birthDate, toInteger(e.reportsTo) as reportsTo, toLong(e.extension) as extension;'>> as ship1 join holo_table on ship1.lastname=holo_table.lastname;

如果上述内容对您有提供帮助，欢迎多多点赞支持~😎如果有更多想要了解的场景测试，也欢迎多多留言~感谢您的阅读🤝

本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如若转载，请注明出处：http://www.xdnf.cn/news/34805.html

如若内容造成侵权/违法违规/事实不符，请联系一条长河网进行投诉反馈，一经查实，立即删除！

相关文章

Ansible自动化运维

Ansible自动化运维

1 ansible介绍和架构 1.1 什么是ansible ansible是新出现的自动化运维工具&#xff0c;基于Python开发&#xff0c;集合了众多运维工具&#xff08;puppet、chef、func、fabric&#xff09;的优点&#xff0c;实现了批量系统配置、批量程序部署、批量运行命令等功能。 ansible…
阅读更多...
玩FPGA不乏味

玩FPGA不乏味

玩FPGA不乏味 Hello&#xff0c;大家好&#xff0c;之前给大家分享了大约一百多个关于FPGA的开源项目&#xff0c;涉及PCIe、网络、RISC-V、视频编码等等&#xff0c;这次给大家带来的是不枯燥的娱乐项目&#xff0c;主要偏向老的游戏内核使用FPGA进行硬解&#xff0c;涉及的内…
阅读更多...
工商业光伏系统踏勘、设计、施工全流程讲解

工商业光伏系统踏勘、设计、施工全流程讲解

随着全球能源结构的转型和环保意识的提升&#xff0c;光伏发电作为一种清洁、可再生的能源形式&#xff0c;正越来越受到工商业领域的青睐。商场、学校、医院、各类工厂等地&#xff0c;安装光伏发电系统不仅能降低运营成本&#xff0c;还可以为企业树立良好的环保形象。 一、前…
阅读更多...
mongo开启慢日志及常用命令行操作、数据备份

mongo开启慢日志及常用命令行操作、数据备份

mongo开启慢日志及常用命令行操作、数据备份 1.常用命令行操作2.mongo备份3.通过命令临时开启慢日志记录4.通过修改配置开启慢日志记录 1.常用命令行操作 连接命令行 格式&#xff1a;mongo -u用户名 -p密码 --host 主机地址 --port 端口号 库名&#xff1b; 如&#xff1a;连…
阅读更多...
Vue跨标签通讯(本地存储)(踩坑)

Vue跨标签通讯(本地存储)(踩坑)

我司有一个需求【用户指引】 需求是根标签有一个用户指引总开关&#xff0c;可以控制页面所有的用户指引是否在页面进入后初始是否默认打开&#xff0c;但是有些页面会新开标签这就设计到跨标签通讯了 我采取的方案是本地存储 重点:首先本地存储在页面是同源(即域名协议端口三…
阅读更多...
Scrapy解析JSON响应v

Scrapy解析JSON响应v

在 Scrapy 中解析 JSON 响应非常常见&#xff0c;特别是当目标网站的 API 返回 JSON 数据时。Scrapy 提供了一些工具和方法来轻松处理 JSON 响应。 1、问题背景 Scrapy中如何解析JSON响应&#xff1f; 有一只爬虫(点击查看源代码)&#xff0c;它可以完美地完成常规的HTML页面…
阅读更多...
机器学习生物医学

机器学习生物医学

Nature与Science重磅&#xff01;AI与生物医药迎来百年来最重磅进展&#xff01;https://mp.weixin.qq.com/s/Vw3Jm4vVKP14_UH2jqwsxA 第一天 机器学习及生物医学中应用简介 1. 机器学习及生物医学中应用简介 2. 机器学习基本概念介绍 3. 常用机器学习模型介绍&#xff0…
阅读更多...
ISIS五

ISIS五

L1路由器的次优路径问题 路由渗透 可以打标签 等价路由上面下面都把骨干区域引入非骨干 强制ATT位不置位为1 attached-bit advertise never 在AR2上禁止ATT置位为1 在AR3没有禁止呀还是有默认路由 ISIS选路机制&#xff1a; L1的路由优于L2的路由 星号bit 叫DU-bit 知道…
阅读更多...
BFC的理解

BFC的理解

BFC的理解 BFC是什么&#xff1f;BFC如何触发&#xff1f;BFC的作用问题解决Margin重叠问题Margin塌陷问题高度塌陷 BFC是什么&#xff1f; BFC是块级格式上下文&#xff08;Block Formatting Context&#xff09;&#xff0c;是CSS布局的一个概念&#xff0c;在BFC布局里面的…
阅读更多...
C++入门基础

C++入门基础

一、C的第一个程序 C兼容C语⾔绝大多数的语法&#xff0c;所以C语言实现的hello world依旧可以运行&#xff0c;C中需要把定义⽂件 代码后缀改为.cpp&#xff0c;vs编译器看到是.cpp就会调⽤C编译器编译&#xff0c;linux下要⽤g编译&#xff0c;不再是gcc #include<stdio.h…
阅读更多...
VMware 安装国产操作系统UOS过程

VMware 安装国产操作系统UOS过程

VMware是一个虚拟化的平台&#xff0c;在这个平台上能训练操作系统&#xff08;客户端版本和服务器端版本&#xff09;&#xff0c;在真机的条件下虚拟出更多的应用场景。&#xff08;如果你的硬件设备足够强悍&#xff0c;可以通常这个平台虚拟出256个终端&#xff08;可能会更…
阅读更多...
仿蝠鲼软体机器人实现高速多模态游动

仿蝠鲼软体机器人实现高速多模态游动

近期&#xff0c;华南理工大学周奕彤老师研究团队最新成果"Manta Ray-Inspired Soft Robotic Swimmer for High-speed and Multi-modal Swimming"被机器人领域会议 IEEE/RSJ International Conference on Intelligent Robots and Systems&#xff08;IROS 2024&#…
阅读更多...
稀土阻燃剂：电子设备的安全守护者

稀土阻燃剂：电子设备的安全守护者

稀土阻燃剂是一类以稀土元素为基础的阻燃材料&#xff0c;广泛应用于电子设备中&#xff0c;主要用于提高材料的阻燃性能和热稳定性&#xff0c;以满足现代电子设备对安全性和可靠性的要求。稀土阻燃剂在电子设备中的应用具有以下特点&#xff1a; 1. 电路板&#xff1a;稀土阻…
阅读更多...
Issue id: AppLinkUrlError 应用intent-filter 配置深链接 URL 问题分析 | AndroidManifest

Issue id: AppLinkUrlError 应用intent-filter 配置深链接 URL 问题分析 | AndroidManifest

AndroidManifest.xml 配置文件中&#xff0c;对 activity 组件进行声明的时候&#xff0c;独立应用在 IDE 显示 intent-filter 报错&#xff0c;但不影响实际编译&#xff0c;因为是系统应用&#xff0c;肯定会有此 URL 的存在。 AOSP 源码&#xff1a; <activity android:…
阅读更多...
QT 中 sqlite 数据库使用

QT 中 sqlite 数据库使用

一、前提 --pro文件添加sql模块QT core gui sql二、使用 说明 --用于与数据库建立连接QSqlDatabase--执行各种sql语句QSqlQuery--提供数据库特定的错误信息QSqlError查看qt支持的驱动 QStringList list QSqlDatabase::drivers();qDebug()<<list;连接 sqlite3 数据库 …
阅读更多...
扫二维码进小程序的指定页面

扫二维码进小程序的指定页面

草料二维码解码器 微信开发者工具 获取二维码解码的参数->是否登陆->跳转 options.q onLoad: function (options) {// console.log("options",options.q)if (options && options.q) {// 解码二维码携带的链接信息let qrUrl decodeURIComponent(optio…
阅读更多...
微信小程序介绍-以及写项目流程（重要）

微信小程序介绍-以及写项目流程（重要）

前言&#xff1a;本篇文章介绍微信小程序以及项目介绍&#xff1a; 文章介绍&#xff1a;介绍了微信小程序常用的指令、组件、api。tips&#xff1a;最好按照官方文档来进行学习&#xff0c;大致可以我的目录来学习&#xff0c;对于写项目是没有问题的 微信小程序官方文档https…
阅读更多...
Apache Dolphinscheduler可视化 DAG 工作流任务调度系统

Apache Dolphinscheduler可视化 DAG 工作流任务调度系统

Apache Dolphinscheduler 关于 一个分布式易扩展的可视化 DAG 工作流任务调度系统。致力于解决数据处理流程中错综复杂的依赖关系&#xff0c;使调度系统在数据处理流程中开箱即用。 DolphinScheduler 的主要特性如下&#xff1a; 易于部署&#xff0c;提供四种部署方式&am…
阅读更多...
“原批教育家”原批之星鲁健的杰作——原批俱乐部

“原批教育家”原批之星鲁健的杰作——原批俱乐部

伟大的原批教育家——原批之星&#xff0c;名为鲁健&#xff0c;是一位在南京邮电大学智能科学与技术专业中崭露头角的杰出人物。他不仅以其卓越的黑客技术和对网络正义的执着而闻名&#xff0c;更是“远古四神”之一&#xff0c;以其对原批之力的深刻理解和不同见解&#xff0…
阅读更多...
github深度学习项目复现教程

github深度学习项目复现教程

如何找感兴趣的项目&#xff1f; 使用github或papers with code搜索关键词“deep learning”等&#xff0c;最受欢迎的是stars数最多的 查看readme 是否清晰地描述了项目目标、使用的技术、安装步骤和运行方法 是否包含依赖项、所需数据集和训练模型等信息 1、准备环境 如…
阅读更多...
最新文章

Copyright @ 2022~2023