Menu
▾
▴
luciddb-users — Mailing list for users of LucidDB
You can subscribe to this list here.
| 2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(28) |
Jun
(2) |
Jul
(10) |
Aug
(1) |
Sep
(7) |
Oct
|
Nov
(1) |
Dec
(7) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008 |
Jan
(5) |
Feb
(7) |
Mar
(10) |
Apr
(12) |
May
(30) |
Jun
(21) |
Jul
(19) |
Aug
(17) |
Sep
(25) |
Oct
(46) |
Nov
(14) |
Dec
(11) |
| 2009 |
Jan
(5) |
Feb
(36) |
Mar
(17) |
Apr
(20) |
May
(75) |
Jun
(143) |
Jul
(29) |
Aug
(41) |
Sep
(38) |
Oct
(71) |
Nov
(17) |
Dec
(56) |
| 2010 |
Jan
(48) |
Feb
(31) |
Mar
(56) |
Apr
(24) |
May
(7) |
Jun
(18) |
Jul
(2) |
Aug
(34) |
Sep
(17) |
Oct
(1) |
Nov
|
Dec
(18) |
| 2011 |
Jan
(12) |
Feb
(19) |
Mar
(25) |
Apr
(11) |
May
(26) |
Jun
(16) |
Jul
(2) |
Aug
(10) |
Sep
(8) |
Oct
(1) |
Nov
|
Dec
(5) |
| 2012 |
Jan
(1) |
Feb
(3) |
Mar
(3) |
Apr
|
May
(2) |
Jun
|
Jul
(3) |
Aug
(1) |
Sep
(2) |
Oct
|
Nov
(2) |
Dec
|
|
From: Matt B. <mat...@ya...> - 2011-09-12 16:43:41
|
Hi Nick, thanks, that did it! I overlooked that http somehow. thanks again, Matt The Mondrian XML: No suitable driver found for jdbc:luciddb://localhostMatt, the URL that Dan and I sent over looked like this: jdbc:luciddb:http://localhost NOT jdbc:luciddb://localhost Can you please try to use the correct URL format and let us know if that works? The rest of your Mondrian setup looks ok at first glance. Nick |
|
From: Dan K. <da...@th...> - 2011-09-12 16:41:39
|
I think it should be jdbc:luciddb:http://localhost From: Matt Becker [mailto:mat...@ya...] Sent: Monday, September 12, 2011 12:12 PM To: Mailing list for users of LucidDB Subject: Re: [luciddb-users] issue with connect string in mondrian datasources.xml Hi guys, i changed that, still no dice.. it's saying the driver can't be found: The Mondrian XML: No suitable driver found for jdbc:luciddb://localhost in my xml connection. Here's my new connection info in my /usr/local/tomcat/webapps/mondrian/WEB-INF/datasources.xml: <DataSourceInfo>Provider=mondrian;Jdbc=jdbc:luciddb://localhost;JdbcUser='LUCIDDB_ANALYTICS';Catalog=/WEB-INF/queries/analytics_schema.xml;JdbcDrivers=org.luciddb.jdbc.LucidDbClientDriver;</DataSourceInfo> I've definitely got the drivers copied to driver locations: /usr/local/tomcat/webapps/mondrian/WEB-INF/lib/LucidDbClient.jar /usr/share/java/LucidDbClient.jar anyone have a sample connection string that works with the barebones mondrian install, as above? thanks, Matt ________________________________ I could be mistaken but I think JdbcDrivers=com.lucidera.jdbc.LucidDbRmiDriver should be org.luciddb.jdbc.LucidDbClientDriver. I agree with Dan - it's likely a driver/URL mismatch which was incorrectly on http://pub.eigenbase.org/wiki/LucidDbMondrianReplication I've updated that Wiki article to include the new JDBC Driver name and URL. Sorry for the issue with the old driver information still lingering on that page JDBC driver class: org.luciddb.jdbc.LucidDbClientDrive JDBC URL: jdbc:luciddb:http://localhost Nick |
|
From: Matt B. <mat...@ya...> - 2011-09-12 16:12:27
|
Hi guys, i changed that, still no dice.. it's saying the driver can't be found: The Mondrian XML: No suitable driver found for jdbc:luciddb://localhost in my xml connection. Here's my new connection info in my /usr/local/tomcat/webapps/mondrian/WEB-INF/datasources.xml: <DataSourceInfo>Provider=mondrian;Jdbc=jdbc:luciddb://localhost;JdbcUser='LUCIDDB_ANALYTICS';Catalog=/WEB-INF/queries/analytics_schema.xml;JdbcDrivers=org.luciddb.jdbc.LucidDbClientDriver;</DataSourceInfo> I've definitely got the drivers copied to driver locations: /usr/local/tomcat/webapps/mondrian/WEB-INF/lib/LucidDbClient.jar /usr/share/java/LucidDbClient.jar anyone have a sample connection string that works with the barebones mondrian install, as above? thanks, Matt ________________________________ I could be mistaken but I think JdbcDrivers=com.lucidera.jdbc.LucidDbRmiDriver should be org.luciddb.jdbc.LucidDbClientDriver.I agree with Dan - it's likely a driver/URL mismatch which was incorrectly on http://pub.eigenbase.org/wiki/LucidDbMondrianReplication I've updated that Wiki article to include the new JDBC Driver name and URL. Sorry for the issue with the old driver information still lingering on that page JDBC driver class: org.luciddb.jdbc.LucidDbClientDrive JDBC URL: jdbc:luciddb:http://localhost Nick |
|
From: Nicholas G. <ngo...@dy...> - 2011-09-08 21:39:22
|
> I could be mistaken but I think JdbcDrivers=com.lucidera.jdbc.LucidDbRmiDriver should be org.luciddb.jdbc.LucidDbClientDriver. I agree with Dan - it's likely a driver/URL mismatch which was incorrectly on > http://pub.eigenbase.org/wiki/LucidDbMondrianReplication I've updated that Wiki article to include the new JDBC Driver name and URL. Sorry for the issue with the old driver information still lingering on that page JDBC driver class: org.luciddb.jdbc.LucidDbClientDrive JDBC URL: jdbc:luciddb:http://localhost Nick |
|
From: Dan K. <da...@th...> - 2011-09-08 21:05:36
|
Perhaps you could include the error message you are seeing? I could be mistaken but I think JdbcDrivers=com.lucidera.jdbc.LucidDbRmiDriver should be org.luciddb.jdbc.LucidDbClientDriver. - dan From: Matt Becker [mailto:mat...@ya...] Sent: Thursday, September 08, 2011 4:34 PM To: luc...@li... Subject: [luciddb-users] issue with connect string in mondrian datasources.xml Hi guys, I'm trying to use Lucid directly with my Mondrian cube, the data is already there, i followed the guide here: http://pub.eigenbase.org/wiki/LucidDbMondrianReplication and i am able to connect to my database from the sqllineClient like this: bin/sqllineClient -n LUCIDDB_ANALYTICS select count(*) from "fact_analytics"; +---------+ | EXPR$0 | +---------+ | 18219 | +---------+ 1 row selected (0.089 seconds) My mondrian bare-bones install is currently functional with mysql and my OLAP cube in there. When I try to switch to Lucid, I'm using this connect string in my datasources.xml: <DataSourceInfo>Provider=mondrian;Jdbc=jdbc:luciddb://localhost?user=LUCIDDB_ANALYTICS;Catalog=/WEB-INF/queries/analytics_schema.xml;JdbcDrivers=com.lucidera.jdbc.LucidDbRmiDriver;</DataSourceInfo> The driver works fine, I tested with the standalone sqlline client in debian, it can connect fine: # sqlline -u jdbc:luciddb:http://localhost -d org.luciddb.jdbc.LucidDbClientDriver -n LUCIDDB_ANALYTICS Connecting to jdbc:luciddb:http://localhost - Virtual JDBC-Driver successfully registered - Couldn't load HSQL-Driver, caching deactivated - VJdbc-URL: servlet:http://localhost:8034/vjdbc,FarragoDBMS - VJdbc in Servlet-Mode, using URL http://localhost:8034/vjdbc - Connecting to datasource FarragoDBMS Connected to: LucidDB (version 0.9.3) Driver: LucidDbJdbcDriver (version 0.9) Autocommit status: true Transaction isolation: TRANSACTION_REPEATABLE_READ sqlline version 1.0.2 by Marc Prud'hommeaux 0: jdbc:luciddb:http://localhost> select count(*) from "fact_analytics" ; +---------+ | EXPR$0 | +---------+ | 18219 | +---------+ 1 row selected (0.07 seconds) 0: jdbc:luciddb:http://localhost> However, from my mondrian install, the connect string above fails. Here's my current (working) mysql connect string for datasources.xml: <DataSourceInfo>Provider=mondrian;Jdbc=jdbc:mysql://localhost/analytics?user=root&password=password;Catalog=/WEB-INF/queries/analytics_schema.xml;JdbcDrivers=com.mysql.jdbc.Driver;</DataSourceInfo> If you can give me some feedback on what's wrong with my luciddb connect string that would be great. I can provide more details as well. thanks, Matt |
|
From: Matt B. <mat...@ya...> - 2011-09-08 20:34:47
|
Hi guys, I'm trying to use Lucid directly with my Mondrian cube, the data is already there, i followed the guide here: http://pub.eigenbase.org/wiki/LucidDbMondrianReplication and i am able to connect to my database from the sqllineClient like this: bin/sqllineClient -n LUCIDDB_ANALYTICS select count(*) from "fact_analytics"; +---------+ | EXPR$0 | +---------+ | 18219 | +---------+ 1 row selected (0.089 seconds) My mondrian bare-bones install is currently functional with mysql and my OLAP cube in there. When I try to switch to Lucid, I'm using this connect string in my datasources.xml: <DataSourceInfo>Provider=mondrian;Jdbc=jdbc:luciddb://localhost?user=LUCIDDB_ANALYTICS;Catalog=/WEB-INF/queries/analytics_schema.xml;JdbcDrivers=com.lucidera.jdbc.LucidDbRmiDriver;</DataSourceInfo> The driver works fine, I tested with the standalone sqlline client in debian, it can connect fine: # sqlline -u jdbc:luciddb:http://localhost -d org.luciddb.jdbc.LucidDbClientDriver -n LUCIDDB_ANALYTICS Connecting to jdbc:luciddb:http://localhost - Virtual JDBC-Driver successfully registered - Couldn't load HSQL-Driver, caching deactivated - VJdbc-URL: servlet:http://localhost:8034/vjdbc,FarragoDBMS - VJdbc in Servlet-Mode, using URL http://localhost:8034/vjdbc - Connecting to datasource FarragoDBMS Connected to: LucidDB (version 0.9.3) Driver: LucidDbJdbcDriver (version 0.9) Autocommit status: true Transaction isolation: TRANSACTION_REPEATABLE_READ sqlline version 1.0.2 by Marc Prud'hommeaux 0: jdbc:luciddb:http://localhost> select count(*) from "fact_analytics" ; +---------+ | EXPR$0 | +---------+ | 18219 | +---------+ 1 row selected (0.07 seconds) 0: jdbc:luciddb:http://localhost> However, from my mondrian install, the connect string above fails. Here's my current (working) mysql connect string for datasources.xml: <DataSourceInfo>Provider=mondrian;Jdbc=jdbc:mysql://localhost/analytics?user=root&password=password;Catalog=/WEB-INF/queries/analytics_schema.xml;JdbcDrivers=com.mysql.jdbc.Driver;</DataSourceInfo> If you can give me some feedback on what's wrong with my luciddb connect string that would be great. I can provide more details as well. thanks, Matt |
|
From: Kevin S. <kse...@dy...> - 2011-08-22 19:39:44
|
Hey Matt. I usually make the schema_name option identical to the database name at the end of the URL. What happens when you try that? On Mon, Aug 22, 2011 at 10:02 AM, Matt Becker <mat...@ya...>wrote: > Hi Nicholas, > > I verified these permissions existed in mysql, and also added and tried a > few other users. > No dice. > We currently have mondrian (same server as luciddb) connecting to mysql > using the root password, it's working fine. > > Our mondrian connection in the jsp looks like this: > <%@ page session="true" contentType="text/html; charset=ISO-8859-1" %> > <%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %> > <%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %> > > <jp:mondrianQuery id="query01" jdbcDriver="com.mysql.jdbc.Driver" > jdbcUrl="jdbc:mysql://localhost/analytics_olap?user=root&password=mypassword" > catalogUri="/WEB-INF/queries/analytics_schema.xml" jdbcUser="root" > jdbcPassword="mypassword" connectionPooling="false"> > Select > { [Measures].[Clicks], [Measures].[Impressions] } ON COLUMNS, > Crossjoin( { [Week].[25] } , { [Day of Week].[All Days of > Week].Children } ) ON ROWS > From > [Analytics] > Where > ([Year].[2011], [Asset Type].[Banner]) > </jp:mondrianQuery> > > <c:set var="title01" scope="session">Test Query uses Mondrian OLAP</c:set> > > > >>> > > Matt, > > Are you able to connect, via Squirrel (or Pentaho Reporting)? > > Remember, MySQL has different usernames for root@'localhost' vs root (via > non IP sockets) vs 'root'@'%' etc. > > You can also try adding additional root passwords > grant all on *.* to 'root'@'%' identified by 'password'; > grant all on *.* to 'root'@'locahost' identified by 'password'; > > > > On Aug 19, 2011, at 1:04 PM, Matt Becker wrote: > > hi guys, > > playing with lucid db, i have an OLAP cube in mysql 5.1 on debian squeeze > x64 that i'm trying to connect to. > bin/lucidDbServer starts up fine: > # bin/lucidDbServer > Server personality: LucidDB > Loading database... > Starting network... > Server now listening for HTTP connections on port 8034; enter !quit to stop > > > bin/lucidDBClient starts up fine: > bin/sqllineClient > Connecting to jdbc:luciddb:http://localhost > Connected to: LucidDB (version 0.9.3) > Driver: LucidDbJdbcDriver (version 0.9) > Autocommit status: true > Transaction isolation: TRANSACTION_REPEATABLE_READ > sqlline version 1.0.8-eb by Marc Prud'hommeaux > 0: jdbc:luciddb:http://localhost> > > > when i try to connect to my foodmart db in mysql 5.1 (with correct > password) it fails with incorrect password: > 0: jdbc:luciddb:http://localhost> create or replace server mysql_test > . . . . . . . . . . . . . . . . > foreign data wrapper sys_jdbc options( > . . . . . . . . . . . . . . . . > driver_class 'com.mysql.jdbc.Driver', > . . . . . . . . . . . . . . . . > login_timeout '10', > . . . . . . . . . . . . . . . . > validation_query 'select 1', > . . . . . . . . . . . . . . . . > url 'jdbc:mysql://localhost:3306/skynet', > > . . . . . . . . . . . . . . . . > user_name 'root', > . . . . . . . . . . . . . . . . > password 'mypassword', > . . . . . . . . . . . . . . . . > fetch_size '-2147483648', > . . . . . . . . . . . . . . . . > table_types 'TABLE', > . . . . . . . . . . . . . . . . > schema_name 'DEFAULT'); > Error: Access denied for user 'root'@'localhost' (using password: YES) > (state=28000,code=1045) > > I've tried this with two different mysql-java jar files, > mysql-connector-java-5.0.7-bin.jar and mysql-connector-java-5.0.8-bin.jar > (copied to lib directory, removed trace directory install/install.sh rerun, > restarted lucidDbServer). > > I'm not sure what to do now. Password is definitely correct. > > portion from Trace.log for the above command: > Aug 19, 2011 2:46:56 PM net.sf.farrago.db.FarragoDbSession prepare > INFO: create or replace server mysql_test > foreign data wrapper sys_jdbc options( > driver_class 'com.mysql.jdbc.Driver', > login_timeout '10', > validation_query 'select 1', > url 'jdbc:mysql://localhost:3306/skynet', > user_name 'root', > password 'mypassword', > fetch_size '-2147483648', > table_types 'TABLE', > schema_name 'DEFAULT') > Aug 19, 2011 2:46:56 PM net.sf.farrago.db.FarragoDbSession commitImpl > INFO: commit > Aug 19, 2011 2:46:56 PM org.eigenbase.util.EigenbaseException <init> > SEVERE: org.eigenbase.util.EigenbaseException: Failed to initialize data > server > Aug 19, 2011 2:46:56 PM org.eigenbase.util.EigenbaseException <init> > SEVERE: org.eigenbase.util.EigenbaseException: Failed to validate > definition for data server "SYS_BOOT"."MYSQL_TEST" > Aug 19, 2011 2:46:56 PM net.sf.farrago.ddl.DdlValidator validate > INFO: Revalidate exception on MYSQL_TEST: > org.eigenbase.util.EigenbaseException: Failed to validate definition for > data server "SYS_BOOT"."MYSQL_TEST"; org.eigenbase.util.EigenbaseException: > Failed to initialize data server; java.sql.SQLException: Access denied for > user 'root'@'localhost' (using password: YES) > Aug 19, 2011 2:46:56 PM net.sf.farrago.db.FarragoDbSession rollbackImpl > INFO: rollback > Aug 19, 2011 2:46:56 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException > SEVERE: Failed to validate definition for data server > "SYS_BOOT"."MYSQL_TEST" > Aug 19, 2011 2:46:56 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException > SEVERE: Failed to initialize data server > Aug 19, 2011 2:46:56 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException > SEVERE: Access denied for user 'root'@'localhost' (using password: YES) > > thanks, > > Matt > > > > > ------------------------------------------------------------------------------ > uberSVN's rich system and user administration capabilities and model > configuration take the hassle out of deploying and managing Subversion and > the tools developers use with it. Learn more about uberSVN and get a free > download at: http://p.sf.net/sfu/wandisco-dev2dev > > _______________________________________________ > luciddb-users mailing list > luc...@li... > https://lists.sourceforge.net/lists/listinfo/luciddb-users > > |
|
From: Matt B. <mat...@ya...> - 2011-08-22 19:12:24
|
hi Nicholas, figured it out.. i had two mysql daemons running, one on 3307 and one on 3306 :-) They each had different mysql root passwords i guess.. forgot about that. Also I tested with the sqlline command line client from linux repositories (not the luciddb one) to narrow things down. Everything's working now. thanks, Matt >>> Hi Nicholas, I verified these permissions existed in mysql, and also added and tried a few other users. No dice. We currently have mondrian (same server as luciddb) connecting to mysql using the root password, it's working fine. Our mondrian connection in the jsp looks like this: ... |
|
From: Matt B. <mat...@ya...> - 2011-08-22 17:02:14
|
Hi Nicholas, I verified these permissions existed in mysql, and also added and tried a few other users. No dice. We currently have mondrian (same server as luciddb) connecting to mysql using the root password, it's working fine. Our mondrian connection in the jsp looks like this: <%@ page session="true" contentType="text/html; charset=ISO-8859-1" %> <%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %> <%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %> <jp:mondrianQuery id="query01" jdbcDriver="com.mysql.jdbc.Driver" jdbcUrl="jdbc:mysql://localhost/analytics_olap?user=root&password=mypassword" catalogUri="/WEB-INF/queries/analytics_schema.xml" jdbcUser="root" jdbcPassword="mypassword" connectionPooling="false"> Select { [Measures].[Clicks], [Measures].[Impressions] } ON COLUMNS, Crossjoin( { [Week].[25] } , { [Day of Week].[All Days of Week].Children } ) ON ROWS From [Analytics] Where ([Year].[2011], [Asset Type].[Banner]) </jp:mondrianQuery> <c:set var="title01" scope="session">Test Query uses Mondrian OLAP</c:set> >>> Matt, Are you able to connect, via Squirrel (or Pentaho Reporting)? Remember, MySQL has different usernames for root@'localhost' vs root (via non IP sockets) vs 'root'@'%' etc. You can also try adding additional root passwords grant all on *.* to 'root'@'%' identified by 'password'; grant all on *.* to 'root'@'locahost' identified by 'password'; On Aug 19, 2011, at 1:04 PM, Matt Becker wrote: hi guys, > > >playing with lucid db, i have an OLAP cube in mysql 5.1 on debian squeeze x64 that i'm trying to connect to. > >bin/lucidDbServer starts up fine: > ># bin/lucidDbServer >Server personality: LucidDB >Loading database... >Starting network... >Server now listening for HTTP connections on port 8034; enter !quit to stop > > > > >bin/lucidDBClient starts up fine: >bin/sqllineClient >Connecting to jdbc:luciddb:http://localhost >Connected to: LucidDB (version 0.9.3) >Driver: LucidDbJdbcDriver (version 0.9) >Autocommit status: true >Transaction isolation: TRANSACTION_REPEATABLE_READ >sqlline version 1.0.8-eb by Marc Prud'hommeaux >0: jdbc:luciddb:http://localhost> > > > > >when i try to connect to my foodmart db in mysql 5.1 (with correct password) it fails with incorrect password: >0: jdbc:luciddb:http://localhost> create or replace server mysql_test >. . . . . . . . . . . . . . . . > foreign data wrapper sys_jdbc options( >. . . . . . . . . . . . . . . . > driver_class 'com.mysql.jdbc.Driver', >. . . . . . . . . . . . . . . . > login_timeout '10', >. . . . . . . . . . . . . . . . > validation_query 'select 1', >. . . . . . . . . . . . . . . . > url 'jdbc:mysql://localhost:3306/skynet', >. . . . . . . . . . . . . . . . > user_name 'root', >. . . . . . . . . . . . . . . . > password 'mypassword', >. . . . . . . . . . . . . . . . > fetch_size '-2147483648', >. . . . . . . . . . . . . . . . > table_types 'TABLE', >. . . . . . . . . . . . . . . . > schema_name 'DEFAULT'); >Error: Access denied for user 'root'@'localhost' (using password: YES) (state=28000,code=1045) > > >I've tried this with two different mysql-java jar files, mysql-connector-java-5.0.7-bin.jar and mysql-connector-java-5.0.8-bin.jar (copied to lib directory, removed trace directory install/install.sh rerun, restarted lucidDbServer). > > >I'm not sure what to do now. Password is definitely correct. > > > >portion from Trace.log for the above command: >Aug 19, 2011 2:46:56 PM net.sf.farrago.db.FarragoDbSession prepare >INFO: create or replace server mysql_test >foreign data wrapper sys_jdbc options( >driver_class 'com.mysql.jdbc.Driver', >login_timeout '10', >validation_query 'select 1', >url 'jdbc:mysql://localhost:3306/skynet', >user_name 'root', >password 'mypassword', >fetch_size '-2147483648', >table_types 'TABLE', >schema_name 'DEFAULT') >Aug 19, 2011 2:46:56 PM net.sf.farrago.db.FarragoDbSession commitImpl >INFO: commit >Aug 19, 2011 2:46:56 PM org.eigenbase.util.EigenbaseException <init> >SEVERE: org.eigenbase.util.EigenbaseException: Failed to initialize data server >Aug 19, 2011 2:46:56 PM org.eigenbase.util.EigenbaseException <init> >SEVERE: org.eigenbase.util.EigenbaseException: Failed to validate definition for data server "SYS_BOOT"."MYSQL_TEST" >Aug 19, 2011 2:46:56 PM net.sf.farrago.ddl.DdlValidator validate > >INFO: Revalidate exception on MYSQL_TEST: org.eigenbase.util.EigenbaseException: Failed to validate definition for data server "SYS_BOOT"."MYSQL_TEST"; org.eigenbase.util.EigenbaseException: Failed to initialize data server; java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) >Aug 19, 2011 2:46:56 PM net.sf.farrago.db.FarragoDbSession rollbackImpl >INFO: rollback >Aug 19, 2011 2:46:56 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException >SEVERE: Failed to validate definition for data server "SYS_BOOT"."MYSQL_TEST" >Aug 19, 2011 2:46:56 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException >SEVERE: Failed to initialize data server >Aug 19, 2011 2:46:56 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException >SEVERE: Access denied for user 'root'@'localhost' (using password: YES) > > > >thanks, > >Matt > > |
|
From: Nicholas G. <ngo...@dy...> - 2011-08-19 20:36:19
|
Matt, Are you able to connect, via Squirrel (or Pentaho Reporting)? Remember, MySQL has different usernames for root@'localhost' vs root (via non IP sockets) vs 'root'@'%' etc. You can also try adding additional root passwords grant all on *.* to 'root'@'%' identified by 'password'; grant all on *.* to 'root'@'locahost' identified by 'password'; On Aug 19, 2011, at 1:04 PM, Matt Becker wrote: > hi guys, > > playing with lucid db, i have an OLAP cube in mysql 5.1 on debian squeeze x64 that i'm trying to connect to. > bin/lucidDbServer starts up fine: > # bin/lucidDbServer > Server personality: LucidDB > Loading database... > Starting network... > Server now listening for HTTP connections on port 8034; enter !quit to stop > > > bin/lucidDBClient starts up fine: > bin/sqllineClient > Connecting to jdbc:luciddb:http://localhost > Connected to: LucidDB (version 0.9.3) > Driver: LucidDbJdbcDriver (version 0.9) > Autocommit status: true > Transaction isolation: TRANSACTION_REPEATABLE_READ > sqlline version 1.0.8-eb by Marc Prud'hommeaux > 0: jdbc:luciddb:http://localhost> > > > when i try to connect to my foodmart db in mysql 5.1 (with correct password) it fails with incorrect password: > 0: jdbc:luciddb:http://localhost> create or replace server mysql_test > . . . . . . . . . . . . . . . . > foreign data wrapper sys_jdbc options( > . . . . . . . . . . . . . . . . > driver_class 'com.mysql.jdbc.Driver', > . . . . . . . . . . . . . . . . > login_timeout '10', > . . . . . . . . . . . . . . . . > validation_query 'select 1', > . . . . . . . . . . . . . . . . > url 'jdbc:mysql://localhost:3306/skynet', > . . . . . . . . . . . . . . . . > user_name 'root', > . . . . . . . . . . . . . . . . > password 'mypassword', > . . . . . . . . . . . . . . . . > fetch_size '-2147483648', > . . . . . . . . . . . . . . . . > table_types 'TABLE', > . . . . . . . . . . . . . . . . > schema_name 'DEFAULT'); > Error: Access denied for user 'root'@'localhost' (using password: YES) (state=28000,code=1045) > > I've tried this with two different mysql-java jar files, mysql-connector-java-5.0.7-bin.jar and mysql-connector-java-5.0.8-bin.jar (copied to lib directory, removed trace directory install/install.sh rerun, restarted lucidDbServer). > > I'm not sure what to do now. Password is definitely correct. > > portion from Trace.log for the above command: > Aug 19, 2011 2:46:56 PM net.sf.farrago.db.FarragoDbSession prepare > INFO: create or replace server mysql_test > foreign data wrapper sys_jdbc options( > driver_class 'com.mysql.jdbc.Driver', > login_timeout '10', > validation_query 'select 1', > url 'jdbc:mysql://localhost:3306/skynet', > user_name 'root', > password 'mypassword', > fetch_size '-2147483648', > table_types 'TABLE', > schema_name 'DEFAULT') > Aug 19, 2011 2:46:56 PM net.sf.farrago.db.FarragoDbSession commitImpl > INFO: commit > Aug 19, 2011 2:46:56 PM org.eigenbase.util.EigenbaseException <init> > SEVERE: org.eigenbase.util.EigenbaseException: Failed to initialize data server > Aug 19, 2011 2:46:56 PM org.eigenbase.util.EigenbaseException <init> > SEVERE: org.eigenbase.util.EigenbaseException: Failed to validate definition for data server "SYS_BOOT"."MYSQL_TEST" > Aug 19, 2011 2:46:56 PM net.sf.farrago.ddl.DdlValidator validate > INFO: Revalidate exception on MYSQL_TEST: org.eigenbase.util.EigenbaseException: Failed to validate definition for data server "SYS_BOOT"."MYSQL_TEST"; org.eigenbase.util.EigenbaseException: Failed to initialize data server; java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) > Aug 19, 2011 2:46:56 PM net.sf.farrago.db.FarragoDbSession rollbackImpl > INFO: rollback > Aug 19, 2011 2:46:56 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException > SEVERE: Failed to validate definition for data server "SYS_BOOT"."MYSQL_TEST" > Aug 19, 2011 2:46:56 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException > SEVERE: Failed to initialize data server > Aug 19, 2011 2:46:56 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException > SEVERE: Access denied for user 'root'@'localhost' (using password: YES) > > thanks, > > Matt > ------------------------------------------------------------------------------ > Get a FREE DOWNLOAD! and learn more about uberSVN rich system, > user administration capabilities and model configuration. Take > the hassle out of deploying and managing Subversion and the > tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2_______________________________________________ > luciddb-users mailing list > luc...@li... > https://lists.sourceforge.net/lists/listinfo/luciddb-users |
|
From: Matt B. <mat...@ya...> - 2011-08-19 20:04:29
|
hi guys, playing with lucid db, i have an OLAP cube in mysql 5.1 on debian squeeze x64 that i'm trying to connect to. bin/lucidDbServer starts up fine: # bin/lucidDbServer Server personality: LucidDB Loading database... Starting network... Server now listening for HTTP connections on port 8034; enter !quit to stop bin/lucidDBClient starts up fine: bin/sqllineClient Connecting to jdbc:luciddb:http://localhost Connected to: LucidDB (version 0.9.3) Driver: LucidDbJdbcDriver (version 0.9) Autocommit status: true Transaction isolation: TRANSACTION_REPEATABLE_READ sqlline version 1.0.8-eb by Marc Prud'hommeaux 0: jdbc:luciddb:http://localhost> when i try to connect to my foodmart db in mysql 5.1 (with correct password) it fails with incorrect password: 0: jdbc:luciddb:http://localhost> create or replace server mysql_test . . . . . . . . . . . . . . . . > foreign data wrapper sys_jdbc options( . . . . . . . . . . . . . . . . > driver_class 'com.mysql.jdbc.Driver', . . . . . . . . . . . . . . . . > login_timeout '10', . . . . . . . . . . . . . . . . > validation_query 'select 1', . . . . . . . . . . . . . . . . > url 'jdbc:mysql://localhost:3306/skynet', . . . . . . . . . . . . . . . . > user_name 'root', . . . . . . . . . . . . . . . . > password 'mypassword', . . . . . . . . . . . . . . . . > fetch_size '-2147483648', . . . . . . . . . . . . . . . . > table_types 'TABLE', . . . . . . . . . . . . . . . . > schema_name 'DEFAULT'); Error: Access denied for user 'root'@'localhost' (using password: YES) (state=28000,code=1045) I've tried this with two different mysql-java jar files, mysql-connector-java-5.0.7-bin.jar and mysql-connector-java-5.0.8-bin.jar (copied to lib directory, removed trace directory install/install.sh rerun, restarted lucidDbServer). I'm not sure what to do now. Password is definitely correct. portion from Trace.log for the above command: Aug 19, 2011 2:46:56 PM net.sf.farrago.db.FarragoDbSession prepare INFO: create or replace server mysql_test foreign data wrapper sys_jdbc options( driver_class 'com.mysql.jdbc.Driver', login_timeout '10', validation_query 'select 1', url 'jdbc:mysql://localhost:3306/skynet', user_name 'root', password 'mypassword', fetch_size '-2147483648', table_types 'TABLE', schema_name 'DEFAULT') Aug 19, 2011 2:46:56 PM net.sf.farrago.db.FarragoDbSession commitImpl INFO: commit Aug 19, 2011 2:46:56 PM org.eigenbase.util.EigenbaseException <init> SEVERE: org.eigenbase.util.EigenbaseException: Failed to initialize data server Aug 19, 2011 2:46:56 PM org.eigenbase.util.EigenbaseException <init> SEVERE: org.eigenbase.util.EigenbaseException: Failed to validate definition for data server "SYS_BOOT"."MYSQL_TEST" Aug 19, 2011 2:46:56 PM net.sf.farrago.ddl.DdlValidator validate INFO: Revalidate exception on MYSQL_TEST: org.eigenbase.util.EigenbaseException: Failed to validate definition for data server "SYS_BOOT"."MYSQL_TEST"; org.eigenbase.util.EigenbaseException: Failed to initialize data server; java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) Aug 19, 2011 2:46:56 PM net.sf.farrago.db.FarragoDbSession rollbackImpl INFO: rollback Aug 19, 2011 2:46:56 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException SEVERE: Failed to validate definition for data server "SYS_BOOT"."MYSQL_TEST" Aug 19, 2011 2:46:56 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException SEVERE: Failed to initialize data server Aug 19, 2011 2:46:56 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException SEVERE: Access denied for user 'root'@'localhost' (using password: YES) thanks, Matt |
|
From: Marc B. <mar...@sq...> - 2011-08-04 21:16:58
|
I'll have to try it again and let you know. On Thu, Aug 4, 2011 at 1:36 PM, Nicholas Goodman < ngo...@ba...> wrote: > Marc, > > Are the tables actually present in the catalog, just not showing in > "!tables"? > > What does > > select * from sys_root.dba_schemas > > yield? > > Also, what schema did you use? If it's one of the system schema (SYS_BOOT, > SYS_ROOT, etc) objects there would. > > Kevin has been testing using the dist build trying to repro your situation. > > Nick > > On Aug 4, 2011, at 1:28 PM, Marc Berkowitz wrote: > > I mean the tables in my user schema are not listed by *!tables* after I > run install/catalog.sql. > > > > > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > The must-attend event for mobile developers. Connect with experts. > Get tools for creating Super Apps. See the latest technologies. > Sessions, hands-on labs, demos & much more. Register early & save! > http://p.sf.net/sfu/rim-blackberry-1 > _______________________________________________ > luciddb-users mailing list > luc...@li... > https://lists.sourceforge.net/lists/listinfo/luciddb-users > > |
|
From: Nicholas G. <ngo...@ba...> - 2011-08-04 21:02:18
|
Marc, Are the tables actually present in the catalog, just not showing in "!tables"? What does select * from sys_root.dba_schemas yield? Also, what schema did you use? If it's one of the system schema (SYS_BOOT, SYS_ROOT, etc) objects there would. Kevin has been testing using the dist build trying to repro your situation. Nick On Aug 4, 2011, at 1:28 PM, Marc Berkowitz wrote: > I mean the tables in my user schema are not listed by !tables after I run install/catalog.sql. |
|
From: Marc B. <mar...@sq...> - 2011-08-04 20:28:56
|
I mean the tables in my user schema are not listed by *!tables* after I run install/catalog.sql. But they did appear just before I ran that script as the last step of the LucidDbUpgrade process. It seems to be that the upgrade has discarded my 78G of data. (I have tried this all again, after making small changes to catalog.sql, notably removing *create or replace schema ...; *but it did not help.) [ Kevin Secretan wrote:] > Hey Marc. The testHarness stuff is indeed a mistake. I thought I fixed that > earlier, but I guess not. I recently committed a fix. We'll be merging > dy/dev up this week, but if you'd like to try again with this build go > ahead:http://build.dynamobi.com/job/build_eigenbase_release/label=lin64/lastSuccessfulBuild/artifact/bootstrap/dist/luciddb-0.9.4RC32.tar.bz2 > > I wasn't able to reproduce losing schemas or tables. Are you saying some > didn't come through from the old version, or did you make some new ones on > 0.9.4 before the upgrade that didn't stick around? > > [Marc Berkowitz wrote:] > I tried to copy the contents of an old version of luciddb to a new version, > following the instruction on the eigenwiki pagehttp://pub.eigenbase.org/wiki/LucidDbUpgrade. > > There the last step is to connect to the new server with sqlline and run * > install/catalog.sql, > *Before I do so I can see my user schema listed from the command *!tables, > *but after running this step my schema has disappeared. > > |
|
From: Kevin S. <kse...@dy...> - 2011-08-02 01:17:04
|
Hey Marc. The testHarness stuff is indeed a mistake. I thought I fixed that earlier, but I guess not. I recently committed a fix. We'll be merging dy/dev up this week, but if you'd like to try again with this build go ahead: http://build.dynamobi.com/job/build_eigenbase_release/label=lin64/lastSuccessfulBuild/artifact/bootstrap/dist/luciddb-0.9.4RC32.tar.bz2 I wasn't able to reproduce losing schemas or tables. Are you saying some didn't come through from the old version, or did you make some new ones on 0.9.4 before the upgrade that didn't stick around? On Sat, Jul 30, 2011 at 5:39 PM, Marc Berkowitz < mar...@sq...> wrote: > Just noticed that *luciddb/initsql/createTestHarness.sql* was included > in *install/catalog.sql* (as unpacked from the dist file). > Is this a mistake? > > > On Sat, Jul 30, 2011 at 5:36 PM, Marc Berkowitz < > mar...@sq...> wrote: > >> I tried to copy the contents of an old version of luciddb to a new >> version, following the instruction on the eigenwiki page >> http://pub.eigenbase.org/wiki/LucidDbUpgrade. >> >> There the last step is to connect to the new server with sqlline and run >> *install/catalog.sql, >> *Before I do so I can see my user schema listed from the command * >> !tables, >> *but after running this step my schema has disappeared. >> It looks to me that *catalog.sql* has clobbered the previous *sys_root*schema. >> >> My old version is version 0.9.3 and my new version is built from >> //open/dev@14393. >> > > > > ------------------------------------------------------------------------------ > Got Input? Slashdot Needs You. > Take our quick survey online. Come on, we don't ask for help often. > Plus, you'll get a chance to win $100 to spend on ThinkGeek. > http://p.sf.net/sfu/slashdot-survey > > _______________________________________________ > luciddb-users mailing list > luc...@li... > https://lists.sourceforge.net/lists/listinfo/luciddb-users > > |
|
From: Marc B. <mar...@sq...> - 2011-07-31 01:08:53
|
Just noticed that *luciddb/initsql/createTestHarness.sql* was included in *install/catalog.sql* (as unpacked from the dist file). Is this a mistake? On Sat, Jul 30, 2011 at 5:36 PM, Marc Berkowitz < mar...@sq...> wrote: > I tried to copy the contents of an old version of luciddb to a new version, > following the instruction on the eigenwiki page > http://pub.eigenbase.org/wiki/LucidDbUpgrade. > > There the last step is to connect to the new server with sqlline and run > *install/catalog.sql, > *Before I do so I can see my user schema listed from the command *!tables, > *but after running this step my schema has disappeared. > It looks to me that *catalog.sql* has clobbered the previous *sys_root*schema. > > My old version is version 0.9.3 and my new version is built from > //open/dev@14393. > |
|
From: Marc B. <mar...@sq...> - 2011-07-31 01:03:32
|
I tried to copy the contents of an old version of luciddb to a new version, following the instruction on the eigenwiki page http://pub.eigenbase.org/wiki/LucidDbUpgrade. There the last step is to connect to the new server with sqlline and run * install/catalog.sql, *Before I do so I can see my user schema listed from the command *!tables, *but after running this step my schema has disappeared. It looks to me that *catalog.sql* has clobbered the previous *sys_root*schema. My old version is version 0.9.3 and my new version is built from //open/dev@14393. |
|
From: Nicholas G. <ngo...@dy...> - 2011-06-22 23:49:18
|
Well, you'll need a connection to be able to run this, but these two views are very similar: http://pub.eigenbase.org/wiki/LucidDbSystemViews#DBA_SESSIONS http://pub.eigenbase.org/wiki/LucidDbSystemViews#DBA_SQL_STATEMENTS Hope this helps! On Jun 22, 2011, at 4:42 PM, briantd wrote: > Is there a command similar to mysql's "show full processlist" that can help > me see what the server is up to? I just recently restarted it, and used > bin/sqllineClient to connect. |
|
From: Dan K. <da...@th...> - 2011-06-22 23:48:06
|
Brian, I think "SELECT * FROM SYS_ROOT.DBA_SQL_STATEMENTS" will achieve what you are after. http://pub.eigenbase.org/wiki/LucidDbSystemViews#DBA_SQL_STATEMENTS Also you can see what is going on in luciddb/trace/Trace.log Pretty sure the DynamoBI admin console has some cool functionality for monitoring performance metrics and the like, however I am not too familiar with it myself. - Dan -----Original Message----- From: briantd [mailto:br...@gm...] Sent: Wednesday, June 22, 2011 7:43 PM To: luc...@li... Subject: [luciddb-users] Best way to see what luciddb server is doing? Is there a command similar to mysql's "show full processlist" that can help me see what the server is up to? I just recently restarted it, and used bin/sqllineClient to connect. Upon entering "!tables", it hung over a minute, but is responsive now. daemon.log didn't say anything on the matter. So I was wondering if there's something else I could have done to see what was going on. Thanks, -Brian -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/Best-way-to-see-what-luciddb-server-is-doing-tp6506581p6506581.html Sent from the luciddb-users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Data protection magic? Nope - It's vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev _______________________________________________ luciddb-users mailing list luc...@li... https://lists.sourceforge.net/lists/listinfo/luciddb-users |
|
From: briantd <br...@gm...> - 2011-06-22 23:42:51
|
Is there a command similar to mysql's "show full processlist" that can help me see what the server is up to? I just recently restarted it, and used bin/sqllineClient to connect. Upon entering "!tables", it hung over a minute, but is responsive now. daemon.log didn't say anything on the matter. So I was wondering if there's something else I could have done to see what was going on. Thanks, -Brian -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/Best-way-to-see-what-luciddb-server-is-doing-tp6506581p6506581.html Sent from the luciddb-users mailing list archive at Nabble.com. |
|
From: Julian H. <jul...@sq...> - 2011-06-21 17:17:04
|
LucidDB doesn't support substituting strings into queries. Oracle used to
call these 'lexical parameters', and they are dangerous because they allow
SQL injection. I don't know what MySQL calls them, or whether you are
expanding ${myParam} manually in your client. Due to the SQL injection risk,
I don't recommend using them.
Also be warned that the SQL-standard behavior of null values in an IN clause
(especially a NOT IN clause) is not intuitive, due to 3-value logic.
For your example, try
WHERE myColumn IS NOT DISTINCT FROM ?1
"IS NOT DISTINCT FROM" is similar to "=", except that it equates null
values.
Julian
_____
From: Dan Kinsley [mailto:da...@th...]
Sent: Tuesday, June 21, 2011 6:03 AM
To: Mailing list for users of LucidDB
Subject: Re: [luciddb-users] "IN" clause in JOIN
Julian,
Thanks for the reply, I have created LDB-243
<http://issues.eigenbase.org/browse/LDB-243> .
While we are on the issue of IN clauses, perhaps someone could answer a
followup question.
In MySQL, for reports that had multivalued parameters I would assume an
empty parameter meant no filter, so I would use the following SQL:
WHERE CONCAT(${myParam}) IS NULL OR myColumn IN(${myParam})
I am struggling to find an equivalent functionality in LucidDB. I very well
could be missing something obvious, but would appreciate any help anyone
could provide with this.
Thanks again,
Dan
From: Julian Hyde [mailto:jul...@sq...]
Sent: Monday, June 20, 2011 5:40 PM
To: 'Mailing list for users of LucidDB'
Subject: Re: [luciddb-users] "IN" clause in JOIN
You've definitely found a bug. Can you please log it? I can't think of an
obvious workaround without looking at the code.
To alias columns, use the syntax 'AS t (c1, c2, ...)'. Viz:
SELECT *
FROM (VALUES 1, 2, 3) AS a (c1)
JOIN (VALUES 1, 2, 3, 4) AS b (c1)
ON a.c1 = b.c1
AND b.c1 IN (1, 2)
This is standard SQL syntax, but not many vendors support it yet.
Julian
_____
From: Dan Kinsley [mailto:da...@th...]
Sent: Monday, June 20, 2011 1:26 PM
To: luc...@li...
Subject: [luciddb-users] "IN" clause in JOIN
Hi guys,
I am currently migrating to LucidDB from MySQL and think I may have found a
bug.
Consider the following query:
SELECT
*
FROM
(VALUES(1),(2),(3) ) a
INNER JOIN (VALUES(1),(2),(3),(4) ) b ON a.EXPR$0 = b.EXPR$0
WHERE
b.EXPR$0 IN(1,2)
Now if you move the IN part into the INNER JOIN like so:
SELECT
*
FROM
(VALUES(1),(2),(3) ) a
LEFT JOIN (VALUES(1),(2),(3),(4) ) b ON a.EXPR$0 = b.EXPR$0 AND b.EXPR$0
IN(1,2)
I received the error:
Error Executing Query: java.lang.NullPointerException: null
The Trace.log file shows:
SEVERE: Internal error: while converting `A`.`EXPR$0` = `B`.`EXPR$0` AND
`B`.`EXPR$0` IN (1, 2)
I am running LucidDB 0.9.3. Has anyone else experienced this issue? Also
sorry if this has already been addressed.
Thanks,
Dan Kinsley
ps - Not a real issue but is there a way to alias the column names returned
from VALUES?
|
|
From: Dan K. <da...@th...> - 2011-06-21 13:02:50
|
Julian, Thanks for the reply, I have created LDB-243<http://issues.eigenbase.org/browse/LDB-243>. While we are on the issue of IN clauses, perhaps someone could answer a followup question... In MySQL, for reports that had multivalued parameters I would assume an empty parameter meant no filter, so I would use the following SQL: WHERE CONCAT(${myParam}) IS NULL OR myColumn IN(${myParam}) I am struggling to find an equivalent functionality in LucidDB. I very well could be missing something obvious, but would appreciate any help anyone could provide with this. Thanks again, Dan From: Julian Hyde [mailto:jul...@sq...] Sent: Monday, June 20, 2011 5:40 PM To: 'Mailing list for users of LucidDB' Subject: Re: [luciddb-users] "IN" clause in JOIN You've definitely found a bug. Can you please log it? I can't think of an obvious workaround without looking at the code. To alias columns, use the syntax 'AS t (c1, c2, ...)'. Viz: SELECT * FROM (VALUES 1, 2, 3) AS a (c1) JOIN (VALUES 1, 2, 3, 4) AS b (c1) ON a.c1 = b.c1 AND b.c1 IN (1, 2) This is standard SQL syntax, but not many vendors support it yet. Julian ________________________________ From: Dan Kinsley [mailto:da...@th...] Sent: Monday, June 20, 2011 1:26 PM To: luc...@li... Subject: [luciddb-users] "IN" clause in JOIN Hi guys, I am currently migrating to LucidDB from MySQL and think I may have found a bug. Consider the following query: SELECT * FROM (VALUES(1),(2),(3) ) a INNER JOIN (VALUES(1),(2),(3),(4) ) b ON a.EXPR$0 = b.EXPR$0 WHERE b.EXPR$0 IN(1,2) Now if you move the IN part into the INNER JOIN like so: SELECT * FROM (VALUES(1),(2),(3) ) a LEFT JOIN (VALUES(1),(2),(3),(4) ) b ON a.EXPR$0 = b.EXPR$0 AND b.EXPR$0 IN(1,2) I received the error: Error Executing Query: java.lang.NullPointerException: null The Trace.log file shows: SEVERE: Internal error: while converting `A`.`EXPR$0` = `B`.`EXPR$0` AND `B`.`EXPR$0` IN (1, 2) I am running LucidDB 0.9.3. Has anyone else experienced this issue? Also sorry if this has already been addressed. Thanks, Dan Kinsley ps - Not a real issue but is there a way to alias the column names returned from VALUES? |
|
From: Julian H. <jul...@sq...> - 2011-06-20 22:38:19
|
You've definitely found a bug. Can you please log it? I can't think of an obvious workaround without looking at the code. To alias columns, use the syntax 'AS t (c1, c2, ...)'. Viz: SELECT * FROM (VALUES 1, 2, 3) AS a (c1) JOIN (VALUES 1, 2, 3, 4) AS b (c1) ON a.c1 = b.c1 AND b.c1 IN (1, 2) This is standard SQL syntax, but not many vendors support it yet. Julian _____ From: Dan Kinsley [mailto:da...@th...] Sent: Monday, June 20, 2011 1:26 PM To: luc...@li... Subject: [luciddb-users] "IN" clause in JOIN Hi guys, I am currently migrating to LucidDB from MySQL and think I may have found a bug. Consider the following query: SELECT * FROM (VALUES(1),(2),(3) ) a INNER JOIN (VALUES(1),(2),(3),(4) ) b ON a.EXPR$0 = b.EXPR$0 WHERE b.EXPR$0 IN(1,2) Now if you move the IN part into the INNER JOIN like so: SELECT * FROM (VALUES(1),(2),(3) ) a LEFT JOIN (VALUES(1),(2),(3),(4) ) b ON a.EXPR$0 = b.EXPR$0 AND b.EXPR$0 IN(1,2) I received the error: Error Executing Query: java.lang.NullPointerException: null The Trace.log file shows: SEVERE: Internal error: while converting `A`.`EXPR$0` = `B`.`EXPR$0` AND `B`.`EXPR$0` IN (1, 2) I am running LucidDB 0.9.3. Has anyone else experienced this issue? Also sorry if this has already been addressed. Thanks, Dan Kinsley ps - Not a real issue but is there a way to alias the column names returned from VALUES? |
|
From: Dan K. <da...@th...> - 2011-06-20 20:46:04
|
Hi guys, I am currently migrating to LucidDB from MySQL and think I may have found a bug. Consider the following query: SELECT * FROM (VALUES(1),(2),(3) ) a INNER JOIN (VALUES(1),(2),(3),(4) ) b ON a.EXPR$0 = b.EXPR$0 WHERE b.EXPR$0 IN(1,2) Now if you move the IN part into the INNER JOIN like so: SELECT * FROM (VALUES(1),(2),(3) ) a LEFT JOIN (VALUES(1),(2),(3),(4) ) b ON a.EXPR$0 = b.EXPR$0 AND b.EXPR$0 IN(1,2) I received the error: Error Executing Query: java.lang.NullPointerException: null The Trace.log file shows: SEVERE: Internal error: while converting `A`.`EXPR$0` = `B`.`EXPR$0` AND `B`.`EXPR$0` IN (1, 2) I am running LucidDB 0.9.3. Has anyone else experienced this issue? Also sorry if this has already been addressed. Thanks, Dan Kinsley ps - Not a real issue but is there a way to alias the column names returned from VALUES? |
|
From: Juan P. B. <jpb...@gm...> - 2011-06-15 01:48:07
|
I'm importing record from text files. To do that I used LucidDbFlatFileWrapper, created a server and imported the schema to a local schema. I change to that schema, and issue a count on a table and I get an error: 0: jdbc:luciddb:http://localhost> select COUNT(*) from "kk-mail_log_bounced"; Error: Row text was too large (state=,code=0) How can I correct this? Below are the Commands I used ---------------------------------------------- CREATE SERVER file_dump_maillogs FOREIGN DATA WRAPPER SYS_FILE_WRAPPER OPTIONS ( DIRECTORY '/home/jp/maillogs_may/salida', FILE_EXTENSION 'txt', CONTROL_FILE_EXTENSION 'bcp', FIELD_DELIMITER '|', LINE_DELIMITER '\n', QUOTE_CHAR '"', WITH_HEADER 'NO'); create schema MAIL_LOGS_TXT; import foreign schema BCP from server file_dump_maillogs into MAIL_LOGS_TXT; set schema 'MAIL_LOGS_TXT'; select count(*) from "kk-mail_log_bounced"; ---------------------------- Thanks Juan Pablo |
17 messages has been excluded from this view by a project administrator.
