资源描述：
《云计算大数据处理-datacude与hive对比测试》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、云计算大数据处理■分布式数据库Datacube与Hive对比测试1.测试平台配置对比:hivedatacube控制节点数量冶）11处理节点数量冶）99cpulntelE5-26202.0G/15M/6ClntelE5-26202.0G/15M/6C内存32G32G网络千兆以太网千兆以太网硬稲3Tx23Tx2软件版本hive-0.9.0-cdh4.1.2datacube-1.02•功能对比测试:项目hivedatacube支持分布式存储计算是是无单点故障是是支持sql语句查询是支持单、多条记录入库是是支持文件入库是是可管理万亿条记录是是支持实时入库、索引是是支持跨平台是是支持实时查询
2、7*24h系统稳定性是是可扩展性是是高性价比是是支持监控管理功能是是3.建表语句:建表1：MPPOWltRCIIRVI:createtableE_MP_POWER_CURVE(IDBIGINT,DATATYPEINT,DATA_POINT_FLAGINT,DATA_WHOLE_FLAGSTRING,PlDOUBLE,P2DOUBLE,P3DOUBLE,P4DOUBLE,P5DOUBLE,P6DOUBLE,P7DOUBLE,P8DOUBLE,P9DOUBLE,PIODOUBLE,PllDOUBLE,P12DOUBLE,P13DOUBLE,P14DOUBLE,P15DOUBLE,P16
3、DOUBLE,P17DOUBLE,P18DOUBLE,P19DOUBLE,P20DOUBLE,P21DOUBLE,P22DOUBLE,P23DOUBLE,P24DOUBLE,P25DOUBLE,P26DOUBLE,P27DOUBLE,P28DOUBLE,P29DOUBLE,P30DOUBLE,P31DOUBLE,P32DOUBLE,P33DOUBLE,P34DOUBLE,P35DOUBLE,P36DOUBLE,P37DOUBLE,P38DOUBLE,P39DOUBLE,P40DOUBLE,P41DOUBLE,P42DOUBLE,P43DOUBLE,P44DOUBLE,P45DOUB
4、LE,P46DOUBLE,P47DOUBLE,P48DOUBLE,P49DOUBLE,P50DOUBLE,P51DOUBLE,P52DOUBLE,P53DOUBLE,P54DOUBLE,P55DOUBLE,P56DOUBLE,P57DOUBLE,P58DOUBLE,P59DOUBLE,P60DOUBLE,P61DOUBLE,P62DOUBLE,P63DOUBLE,P64DOUBLE,P65DOUBLE,P66DOUBLE,P67DOUBLE,P68DOUBLE,P69DOUBLE,P70DOUBLE,P71DOUBLE,P72DOUBLE,P73DOUBLE,P74DOUBLE,P
5、75DOUBLE,P76DOUBLE,P77DOUBLE,P78DOUBLE,P79DOUBLE,P80DOUBLE,P81DOUBLE,P82DOUBLE,P83DOUBLE,P84DOUBLE,P85DOUBLE,P86DOUBLE,P87DOUBLE,P88DOUBLE,P89DOUBLE,P90DOUBLE,P91DOUBLE,P92DOUBLE,P93DOUBLE,P94DOUBLE,P95DOUBLE,P96DOUBLE,PAIDOUBLE,PA2DOUBLE,PA3DOUBLE,PA4DOUBLE,PA5DOUBLE,PA6DOUBLE,PA7DOUBLE,PA8DO
6、UBLE,PA9DOUBLE,PA10DOUBLE,PA11DOUBLE,PA12DOUBLE,PA13DOUBLE,PAUDOUBLE,PA15DOUBLE,PA16DOUBLE,PA17DOUBLE,PA18DOUBLE,PA19DOUBLE,PA20DOUBLE,PA21DOUBLE,PA22DOUBLE,PA23DOUBLE,PA24DOUBLE,PA25DOUBLE,PA26DOUBLE,PA27DOUBLE,PA28DOUBLE,PA29DOUBLE,PA30DOUBLE,PA31DOUBLE,PA32DOUBLE,PA33DOUBLE,PA34DOUBLE,PA35D
7、OUBLE,PA36DOUBLE,PA37DOUBLE,PA38DOUBLE,PA39DOUBLE,DOUBLE,DOUBLE,PA40PA45PA50PA55DOUBLE,DOUBLE,PA61PA66DOUBLE,DOUBLE,PA72PA77DOUBLE,DOUBLE,PA83PA88DOUBLE,DOUBLE,PA94DOUBLE,PA41DOUBLE,PA46DOUBLE,PA51PA56DOUBLE,DOUBLE,PA62PA67DOUBLE,DOUBLE
