RE: query statement return empty

2015-07-30 Thread
on all nodes. From: 鄢来琼 Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" Date: Thursday, July 30, 2015 at 6:02 PM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" Subject: query statement return empty Hi ALL The result of “s

答复: query statement return empty

2015-07-30 Thread
Using java/C# rewrite the test case, the results are consistency. Is there any problem for the python driver? 发件人: 鄢来琼 发送时间: Friday, July 31, 2015 9:03 AM 收件人: 'user@cassandra.apache.org' 主题: query statement return empty Hi ALL The result of “select * from t_test where id = 1” statem

query statement return empty

2015-07-30 Thread
Hi ALL The result of “select * from t_test where id = 1” statement is not consistency, Could you tell me why? test case, I = 0; While I < 5: result = cassandra_session.execute(“select ratio from t_test where id = 1”) print result testing result: [Row(ratio=Decimal('0.000'))] [] [Row(ratio=De

log all the query statement

2015-04-01 Thread
Hi all, Cassandra 2.1.2 is used in my project, but some node is down after executing query some statements. Could I configure the Cassandra to log all the executed statement? Hope the log file can be used to identify the problem. Thanks. Peter

Re: Is Table created in all the nodes if the default consistency level used

2015-03-17 Thread
ut rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!” - Hunter Thompson Daemeon C.M. Reiydelle USA (+1) 415.501.0198 London (+44) (0) 20 8144 9872 On Mon, Mar 16, 2015 at 11:51 PM, 鄢来琼 mailto:laiqiong@gtafe.com>> wro

Re: Is Table created in all the nodes if the default consistency level used

2015-03-16 Thread
ter and Table_Test will be created in all nodes 4. If your System_auth KS is set less than number of nodes, you will face AUTH issues. Naidu Saladi From: 鄢来琼 mailto:laiqiong@gtafe.com>> To: "user@cassandra.apache.org<mailto:user@cassandra.apache.

Re: Is Table created in all the nodes if the default consistency level used

2015-03-16 Thread
Cassandra is used in a message process system. The table will be created at a fixed time each day. We want the table can be created before the message arrived. So I want to guarantee table is created in all the nodes. Peter 发件人: 鄢来琼 发送时间: 2015年3月16日 15:14 收件人: user@cassandra.apache.org 主题: Re

Re: Is Table created in all the nodes if the default consistency level used

2015-03-16 Thread
72 On Sun, Mar 15, 2015 at 8:11 PM, 鄢来琼 mailto:laiqiong@gtafe.com>> wrote: Could you tell me whether the meta data of the new table are build in all the nodes after execute the following statement. cassandra_session.execute_async( “““CREATE TABLE Table_test( ID uuid,

Is Table created in all the nodes if the default consistency level used

2015-03-15 Thread
Could you tell me whether the meta data of the new table are build in all the nodes after execute the following statement. cassandra_session.execute_async( “““CREATE TABLE Table_test( ID uuid, Time timestamp, Value double, Date timestamp, PRIMARY KEY ((ID,Date)

how to clear data from disk

2015-03-09 Thread
Hi ALL, After drop table, I found the data is not removed from disk, I should reduce the gc_grace_seconds before the drop operation. I have to wait for 10 days, but there is not enough disk. Could you tell me there is method to clear the data from disk quickly? Thank you very much! Peter

答复:

2014-12-24 Thread
Yeah, I also have the question. My solution is not delete the row, but insert the right row to a new table. Thanks & Regards, Peter YAN 发件人: Sávio S. Teles de Oliveira [mailto:savio.te...@cuia.com.br] 发送时间: 2014年8月26日 4:25 收件人: user@cassandra.apache.org 主题: We're using cassandra 2.0.9 with data

Re: UPDATE statement is failed

2014-12-10 Thread
for each statement. If condition is meet, the latest data is read and written into the normal table. But the reading of latest data is failed sometimes. Is there any suggestions. Thanks & Regards, 鄢来琼 / Peter YAN, Staff Software Engineer, 发件人: Eric Stevens [mailto:migh...@gmail.com] 发送时间: 201

re: UPDATE statement is failed

2014-12-07 Thread
insert a new row after executing UPDATE statement, then delete all the redundant rows. I also found that the UPDATE statement may be failed if it follows the DELETE statement immediately. The SELECT statement is used to check the last UPDATE statement is executed correctly. Peter 发件人: 鄢来琼

re: UPDATE statement is failed

2014-12-02 Thread
The system setting is as the following: Cluster replication: replication = {'class': 'NetworkTopologyStrategy', 'GTA_SZ_DC1':2} Totally, 5 Nodes, OS of Nodes are windows. Thanks & Regards, 鄢来琼 / Peter YAN, Staff Software Engineer, A3 Dept., G

UPDATE statement is failed

2014-12-02 Thread
160, VOLUME = 3500, AMOUNT = 28560.000, MARKET = 1, SECURITYID = 20103592 WHERE SYMBOL = '600256' AND TRADETIME = '2014-11-27 10:00:00'; #the result of READ [Row(tradetime=datetime.datetime(2014, 11, 27, 2, 0), openprice=Decimal('8.460'), highprice=Decimal(&

答复: can not query data from cassandra

2014-08-20 Thread
.png@01CF5897.E1268DE0] 发件人: 鄢来琼 [mailto:laiqiong@gtafe.com] 发送时间: 2014年8月20日 14:13 收件人: user@cassandra.apache.org 主题: can not query data from cassandra HI ALL, I setup Cassandra on a linux host. I have insert some data into “mykeyspace.cffex_l23” table. The following error are raised during

can not query data from cassandra

2014-08-19 Thread
ColumnFamily='sstable_activity') liveRatio is 14.591601139687077 (just-counted was 14.591). calculation took 6ms for 120 cells Thanks and regards, 深圳市国泰安信息技术有限公司 A3开发部 资深软件工程师 鄢来琼 手机:18620306659 邮箱:laiqiong@gtafe.com 地址:深圳市南山区南头检查站关口二路智恒产业园19栋3楼

cannot login cassandra

2014-08-17 Thread
org.jboss.netty.handler.execution.ChannelUpstreamEventRunnable.doRun(ChannelUpstreamEventRunnable.java:43) What’s the problem? How to fix it? Any comments from you are appreciated! Thanks and regards, 深圳市国泰安信息技术有限公司 鄢来琼 手机:18620306659 邮箱:laiqiong@gtafe.com 地址:深圳市南山区南头检查站关口二路智恒产业园19栋3楼 http://www.gtafe.com/ [说明: cid:image001