Cassandra DB. com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured table person

12,394

Table names are case sensitive.

Share:
12,394
Taxist Samael
Author by

Taxist Samael

Software engineer. Ex software tester:)

Updated on June 04, 2022

Comments

  • Taxist Samael
    Taxist Samael almost 2 years

    The keyspace and 'person' table are exist

    Hello, I'm new with Cassandra, so I'm just trying to execute select query from my java code, but I got an exception that the table is not exist (but it exists. Check the link above). Please help me figure out what could be a cause of this problem. Thank you in advance.

    public class DS_Cassandra implements DS 
    {
        Cluster cluster;
        Session session;
        private static final Logger log = Logger.getLogger( DS_Cassandra.class.getName() );
    
        public DS_Cassandra() 
        {
            cluster = Cluster.builder().addContactPoint("127.0.0.1").build();
            session = cluster.connect("testing");
        }
    
        @Override
        public ArrayList<Person> read() 
        {
            ArrayList<Person> list = new ArrayList<Person>();
            ResultSet results = session.execute("SELECT * FROM person"); //and here exception happened
    
    
    
    2016-03-02 22:06:26 INFO  NettyUtil:83 - Did not find Netty's native epoll transport in the classpath, defaulting to NIO.
    2016-03-02 22:06:26 INFO  DCAwareRoundRobinPolicy:95 - Using data-center name 'datacenter1' for DCAwareRoundRobinPolicy (if this is incorrect, please provide the correct datacenter name with DCAwareRoundRobinPolicy constructor)
    2016-03-02 22:06:26 INFO  Cluster:1475 - New Cassandra host /127.0.0.1:9042 added
    Exception in thread "main" com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured table person
        at com.datastax.driver.core.exceptions.InvalidQueryException.copy(InvalidQueryException.java:50)
        at com.datastax.driver.core.DriverThrowables.propagateCause(DriverThrowables.java:37)
        at com.datastax.driver.core.DefaultResultSetFuture.getUninterruptibly(DefaultResultSetFuture.java:245)
        at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:63)
        at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:39)...