Presto 0.100 cassandra connector issue

61 views
Skip to first unread message

Vali Malinoiu

unread,
Apr 9, 2015, 7:42:34 AM4/9/15
to presto...@googlegroups.com
Even if i am able to connect with the CQL utility i can't connect with presto 

com.datastax.driver.core.exceptions.AuthenticationException: Authentication error on host /10.40.10.4:9042: Username and/or password are incorrect

at com.datastax.driver.core.Connection.waitForAuthCompletion(Connection.java:222) ~[na:na]

at com.datastax.driver.core.Connection.authenticateV2(Connection.java:191) ~[na:na]

at com.datastax.driver.core.Connection.initializeTransport(Connection.java:151) ~[na:na]

at com.datastax.driver.core.Connection.<init>(Connection.java:113) ~[na:na]

at com.datastax.driver.core.Connection$Factory.open(Connection.java:503) ~[na:na]

at com.datastax.driver.core.ControlConnection.tryConnect(ControlConnection.java:219) ~[na:na]

at com.datastax.driver.core.ControlConnection.reconnectInternal(ControlConnection.java:172) ~[na:na]

at com.datastax.driver.core.ControlConnection.connect(ControlConnection.java:80) ~[na:na]

at com.datastax.driver.core.Cluster$Manager.init(Cluster.java:1154) ~[na:na]

at com.datastax.driver.core.Cluster.init(Cluster.java:154) ~[na:na]

at com.datastax.driver.core.Cluster.connect(Cluster.java:230) ~[na:na]

at com.facebook.presto.cassandra.CassandraSession$1.load(CassandraSession.java:95) ~[na:na]

at com.facebook.presto.cassandra.CassandraSession$1.load(CassandraSession.java:90) ~[na:na]

at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache.get(LocalCache.java:3937) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824) ~[guava-18.0.jar:na]

at com.facebook.presto.cassandra.CassandraSession.getSession(CassandraSession.java:115) ~[na:na]

at com.facebook.presto.cassandra.CassandraSession.executeWithSession(CassandraSession.java:435) ~[na:na]

at com.facebook.presto.cassandra.CassandraSession.getAllSchemas(CassandraSession.java:159) ~[na:na]

at com.facebook.presto.cassandra.CachingCassandraSchemaProvider.lambda$loadAllSchemas$0(CachingCassandraSchemaProvider.java:184) ~[na:na]

at com.facebook.presto.cassandra.CachingCassandraSchemaProvider$$Lambda$241/182185521.call(Unknown Source) ~[na:na]

at com.facebook.presto.cassandra.RetryDriver.run(RetryDriver.java:85) ~[na:na]

at com.facebook.presto.cassandra.CachingCassandraSchemaProvider.loadAllSchemas(CachingCassandraSchemaProvider.java:184) ~[na:na]

at com.facebook.presto.cassandra.CachingCassandraSchemaProvider.access$000(CachingCassandraSchemaProvider.java:51) ~[na:na]

at com.facebook.presto.cassandra.CachingCassandraSchemaProvider$1.load(CachingCassandraSchemaProvider.java:109) ~[na:na]

at com.facebook.presto.cassandra.CachingCassandraSchemaProvider$1.load(CachingCassandraSchemaProvider.java:104) ~[na:na]

at com.google.common.cache.CacheLoader$1.load(CacheLoader.java:189) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache.get(LocalCache.java:3937) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824) ~[guava-18.0.jar:na]

at com.facebook.presto.cassandra.CachingCassandraSchemaProvider.getCacheValue(CachingCassandraSchemaProvider.java:297) ~[na:na]

at com.facebook.presto.cassandra.CachingCassandraSchemaProvider.getCaseSensitiveSchemaName(CachingCassandraSchemaProvider.java:224) ~[na:na]

at com.facebook.presto.cassandra.CachingCassandraSchemaProvider.lambda$loadAllTables$1(CachingCassandraSchemaProvider.java:198) ~[na:na]

at com.facebook.presto.cassandra.CachingCassandraSchemaProvider$$Lambda$240/1345026897.call(Unknown Source) ~[na:na]

at com.facebook.presto.cassandra.RetryDriver.run(RetryDriver.java:85) ~[na:na]

at com.facebook.presto.cassandra.CachingCassandraSchemaProvider.loadAllTables(CachingCassandraSchemaProvider.java:197) ~[na:na]

at com.facebook.presto.cassandra.CachingCassandraSchemaProvider.access$100(CachingCassandraSchemaProvider.java:51) ~[na:na]

at com.facebook.presto.cassandra.CachingCassandraSchemaProvider$2.load(CachingCassandraSchemaProvider.java:122) ~[na:na]

at com.facebook.presto.cassandra.CachingCassandraSchemaProvider$2.load(CachingCassandraSchemaProvider.java:117) ~[na:na]

at com.google.common.cache.CacheLoader$1.load(CacheLoader.java:189) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache.get(LocalCache.java:3937) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941) ~[guava-18.0.jar:na]

at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824) ~[guava-18.0.jar:na]

at com.facebook.presto.cassandra.CachingCassandraSchemaProvider.getCacheValue(CachingCassandraSchemaProvider.java:297) ~[na:na]

at com.facebook.presto.cassandra.CachingCassandraSchemaProvider.getAllTables(CachingCassandraSchemaProvider.java:190) ~[na:na]

at com.facebook.presto.cassandra.CassandraMetadata.listTables(CassandraMetadata.java:129) ~[na:na]

at com.facebook.presto.metadata.MetadataManager.listTables(MetadataManager.java:245) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.connector.informationSchema.InformationSchemaPageSourceProvider.getTablesList(InformationSchemaPageSourceProvider.java:193) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.connector.informationSchema.InformationSchemaPageSourceProvider.buildTables(InformationSchemaPageSourceProvider.java:175) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.connector.informationSchema.InformationSchemaPageSourceProvider.getInformationSchemaTable(InformationSchemaPageSourceProvider.java:125) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.connector.informationSchema.InformationSchemaPageSourceProvider.getInternalTable(InformationSchemaPageSourceProvider.java:116) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.connector.informationSchema.InformationSchemaPageSourceProvider.createPageSource(InformationSchemaPageSourceProvider.java:87) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.split.PageSourceManager.createPageSource(PageSourceManager.java:48) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.operator.ScanFilterAndProjectOperator.addSplit(ScanFilterAndProjectOperator.java:105) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.operator.Driver.processNewSource(Driver.java:259) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.operator.Driver.processNewSources(Driver.java:224) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.operator.Driver.access$300(Driver.java:53) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.operator.Driver$DriverLockResult.close(Driver.java:508) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.operator.Driver.updateSource(Driver.java:202) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.execution.SqlTaskExecution$DriverSplitRunnerFactory.createDriver(SqlTaskExecution.java:464) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.execution.SqlTaskExecution$DriverSplitRunnerFactory.access$1500(SqlTaskExecution.java:431) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:557) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.execution.TaskExecutor$PrioritizedSplitRunner.process(TaskExecutor.java:505) ~[presto-main-0.100.jar:0.100]

at com.facebook.presto.execution.TaskExecutor$Runner.run(TaskExecutor.java:639) ~[presto-main-0.100.jar:0.100]

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_40]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_40]

at java.lang.Thread.run(Thread.java:745) [na:1.8.0_40]

Dain Sundstrom

unread,
Apr 9, 2015, 12:40:36 PM4/9/15
to presto...@googlegroups.com
On Apr 9, 2015, at 4:42 AM, Vali Malinoiu <0x4...@gmail.com> wrote:

> Even if i am able to connect with the CQL utility i can't connect with presto
>
> com.datastax.driver.core.exceptions.AuthenticationException: Authentication error on host /10.40.10.4:9042: Username and/or password are incorrect
>

My guess is the cassandra.username and cassandra.password are not set correctly in your catalog properties file.

-dain

Reply all
Reply to author
Forward
0 new messages