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');