前言

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

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

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

基础背景介绍

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;

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