Cassandra

JAVA_HOME=/usr/java/jdk1.7.0_45
PATH=$PATH:$JAVA_HOME/bin/

export JAVA_HOME
export PATH



sudo update-alternatives --install "/usr/bin/java" "java" "/usr/java/jdk1.7.0_45/bin/java" 1
sudo update-alternatives --install "/usr/bin/javac" "javac" "/usr/java/jdk1.7.0_45/bin/javac" 1
sudo update-alternatives --install "/usr/bin/javaws" "javaws" "/usr/java/jdk1.7.0_45/bin/javaws" 1
sudo update-alternatives --set java /usr/java/jdk1.7.0_45/bin/java
sudo update-alternatives --set javac /usr/java/jdk1.7.0_45/bin/javac
sudo update-alternatives --set javaws /usr/java/jdk1.7.0_45/bin/javaws


CREATE KEYSPACE message
         WITH REPLICATION = {'class' : 'SimpleStrategy', 'replication_factor': 1};



CREATE TABLE UserActivity (
  userid text,
  txntime timeuuid,
  instid int,
  insttype text,
  txnamount int,
  txncounter int,
  txntype text,
  PRIMARY KEY (userid, txntime)
)

CREATE INDEX instId ON useractivity (instid);
CREATE INDEX instType ON useractivity (insttype);
CREATE INDEX txntype ON useractivity (txntype);

INSERT INTO UserActivity(userId, txntype, instId, instType,txntime,txnAmount,txnCounter)
VALUES ('1', 'LOAD', 1, 'CC',now(),100,1);
INSERT INTO UserActivity(userId, txntype, instId, instType,txntime,txnAmount,txnCounter)
VALUES ('1', 'LOAD', 1, 'CC',now(),100,1);

INSERT INTO Counter(userId, txntype, instId, instType,txntime,txnAmount,txnCounter) VALUES ('1', 'LOAD', 1, 'CC',now(),100,1);


 select * from useractivity where userid='1404' and txntype='LOAD' and insttype='DC' and txntime>minTimeuuid('2013-08-08 18:43:58+0530') and txntime<= maxTimeuuid('2014-01-08 18:43:58+0530');

select * from useractivity where userid='1404' and txntime>minTimeuuid('2013-08-08 18:43:58+0530') and txntime<= maxTimeuuid('2014-01-08 18:43:58+0530');


select value from UserActivity where userid = '" + key + "' and txntime < maxTimeuuid('2014-01-10 00:05+0000') AND txntime > minTimeuuid('2013-01-10 10:00+0000');

select value from UserActivity where userid = '100' and txntime < maxTimeuuid('2014-01-10 00:05+0000') AND txntime > minTimeuuid('2013-01-10 10:00+0000');