Showing posts with label cassandra. Show all posts
Showing posts with label cassandra. Show all posts

Thursday, May 30, 2013

DSE cassandra: dangerous command apt-get upgrade

there 're an error when upgrade version 1.1.11. to version 1.2.4 in cassandra
si por algun casual se te ocurre actualizar el sistema de cassandra de la version 1.1.11 a la version 1.2.4, te encontraras con el siguiente error
INFO [main] 2012-04-17 12:12:02,065 AbstractCassandraDaemon.java (line 105) Logging initialized
INFO [main] 2012-04-17 12:12:02,123 DatabaseDescriptor.java (line 116) Loading settings from file:/home/vensocia/datastax/resources/cassandra/conf/cassandra.yaml
ERROR [main] 2012-04-17 12:12:02,216 DatabaseDescriptor.java (line 448) Fatal configuration error error
while parsing a block mapping
in "", line 10, column 1:
cluster_name: 'Test Cluster'
^
expected , but found BlockMappingStart
dont modify the file cassandra.yaml
No te vuelvas loco modificando el fichero cassandra.yaml. Tienes dos opciones sigue las instrucciones de http://www.datastax.com/docs/datastax_enterprise2.0/upgrading_dse o revierte los cambios. execute command to show cassandra version
ejecuta el comando para ver que versión de cassandra tienes
dpkg -s cassandra
and make a rollback
y vuelve a dejarlo todo como estaba con la instruccion
sudo apt-get install dsc1.1 

Tuesday, October 30, 2012

Cassandra keys in Unix/linux server and client in java windows

In this link talk about to count in rows in cassandra. But there a little problem when Unix database and client java Windows. The serialize UUID dont work.
byte[] start = null;
byte[] lastEnd = null;
int count = 0;
while (true) {
RangeSlicesQuery rsq = HFactory
 .createRangeSlicesQuery(keyspaceOperator,
       me.prettyprint.cassandra.serializers.BytesArraySerializer.get(), StringSerializer.get(),
 StringSerializer.get());
 rsq.setColumnFamily("columnFamily");
 rsq.setColumnNames("uuid","idUser","timestamp","urlPageVisited","processed");
 rsq.setKeys(start, null);
 rsq.setReturnKeysOnly(); // Return column names instead of values
 rsq.setRowCount(3); // Arbitrary default
 OrderedRows rows = rsq.execute().get();
 int rowCount = rows.getCount();

if (rowCount == 0) {
 break;
} else {
 start = rows.peekLast().getKey();

 if (lastEnd != null && Arrays.equals(start,lastEnd) ) { // modify this line
  break;
 }
 count += rowCount - 1;
 lastEnd = start;
}
  if (count > 0) {
   count += 1;
  }
  System.out.print("count de la tabla " + count);
  return count;
 }
change the UUID identify. Put byte[]

Thursday, October 25, 2012

Kundera not implement getCriteriaBuilder


I have cassandra intalled a computer.... I try create a template to make dinamics query with JPA. This is implemente.



    public <E extends Object> List<E> getAll(E e){
   
          CriteriaBuilder cb = em.getCriteriaBuilder();
         
          CriteriaQuery<E> q = cb.createQuery((Class<E>) e);
          Root<E> c = q.from((Class<E>) e);
          return (List<E>) q.select(c);
    }

But when I executed this progran throw a exception

NotImplementedException: TODO
    at com.impetus.kundera.persistence.EntityManagerFactoryImpl.getCriteriaBuilder(EntityManagerFactoryImpl.java:199)
    at com.impetus.kundera.persistence.EntityManagerImpl.getCriteriaBuilder(EntityManagerImpl.java:682)

Thursday, September 6, 2012

Install cassandra database

To install cassandra database distribution http://www.datastax.com/download/community

Dont work in 32 bit architecture. java Heap space  error
To see web service
http://<publicIP>:8888/opscenter/

Ubuntu 12, 64 bit

Before
**** remove version of java openjdk and install java oracle
sudo apt-ger purge openjdk*
java 7
sudo add-apt-repository ppa:webupd8team/java
sudo apt-get install oracle-java7-installer

****openssl python
sudo apt-get install libssl0.9.8
sudo apt-get install sysstat
sudo apt-get install python-cql

****Install cassandra, DataStax Community distribution of Cassandra. Read more in http://www.datastax.com/docs/1.1/install/install_deb
sudo apt-get install dsc1.1

****install web service. Read more in http://www.datastax.com/docs/opscenter/install/install_deb
sudo apt-get install opscenter-free

***web service configure
sudo vi /etc/opscenter/opscenterd.conf
***add in file
[cassandra]
seed_hosts=publicIP
[logging]
level=INFO
[jmx]
port =7199


***configure cassadra
sudo vi /etc/cassandra/cassandra.yaml
***change IP and localhost for publiIP

***start cassandra
sudo service cassandra start

***node cassandra
nodetool ring -h publicIP

**start web
sudo service opscenterd start

*** check web service
wget http://publicIP:8888/

***to see log
/var/log/opscenter/opscenterd.log


*** to start client cassandra
cassandra-cli -h publicIP -p 9160

***to see  log of  cassandra
/var/log/cassandra/output.log
/var/log/cassandra/system.log


***  delete database cassandra if you want , stop service before
sudo bash -c '/var/lib/cassandra/data/system/*'