发布时间:2015-04-16 08:38:10
Sometime a user wants to add a shard (i.e., go from 3 shards to 4). What is the process? Clients need to re-connect to all 4 shards — close the DistibutedEngine that is connected to 3 shards and reconnect to 4. The moving/rebalancing of the data is the application’s responsibility. There is no r.........【阅读全文】
发布时间:2015-04-09 09:48:30
If creating a table with the same name, then the old table it renamed to XXX$n where "XXX" is the original name and "n" is a version number. You can then access it using this name XXX$n and copy data to the new table with the requested transformation (if the schemas are not the same).&n.........【阅读全文】
发布时间:2015-04-02 18:25:10
eXtremeDB除了通过API和SQL方式导入数据到数据库之外,还可以直接从csv文件中加载数据,例如: 点击(此处)折叠或打开insert into hist select * from '/home/test.csv' as hist where mod(seqnumber, %#)=%@;.........【阅读全文】
发布时间:2015-03-27 10:28:56
当使用xSQL命令行工具来创建eXtremeDB数据库或Sharding时候,如果数据库大小小于等于1M,将会出现Runtimeerror,如下所示: terminate called after throwing an instance of 'McoSql::RuntimeError' what(): Runtime error: Unknown error code 520022.........【阅读全文】
发布时间:2015-03-16 10:21:56
eXtremeDB支持SQL,也可以使用group by子句,但是在使用group by的过程中,有一些需要注意的地方。1. 在group by子句中,所使用的字段必须是在select子句中出现过的字段。2. 在group by子句中,如果使用表别名来引用字段,需要格外注意。例如:select t1.dmdm,count (t1.dmdm) from rbase t1 group by t1.dmdm limit 10;.........【阅读全文】