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: rlmagidson <rlm...@gm...> - 2012-11-30 16:46:49
|
Hi - has anyone gotten an answer for this? My first few moments with Lucid and I get the same error. The error includes "Can't load AMD 64-bit .dll on a IA 32-bit platform." I don't quite understand this as binay and myself are on 64-bit windows. - Russell -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/Issue-while-loading-DB-in-windows-7-64-bit-machine-tp7572760p7572765.html Sent from the luciddb-users mailing list archive at Nabble.com. |
|
From: rlmagidson <rlm...@gm...> - 2012-11-30 16:43:52
|
Hi - has anyone gotten an answer to this? My first few moments with Lucid and I got the same error. Many thanks! - Russell -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/Issue-while-loading-DB-in-windows-7-64-bit-machine-tp7572760p7572763.html Sent from the luciddb-users mailing list archive at Nabble.com. |
|
From: parth1988 <nag...@as...> - 2012-09-14 00:38:46
|
Hello all, For my research, I am trying to count the number of RID/page accesses for a particular value in a column in LucidDB for any given query. I went over the source code but I couldn't figure where this information is being read. First, can this be done in LucidDB? If yes, can anyone please direct me to the correct source file? Thank you! Parth -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/RID-page-access-count-tp7572762.html Sent from the luciddb-users mailing list archive at Nabble.com. |
|
From: Luiz F. <lu...@ya...> - 2012-09-07 22:59:15
|
Hi somebody please riddle me this: the LucidDB's documentation here is right? http://www.luciddb.org/wiki/LucidDbSysRoot_EXPORT_SCHEMA_TO_FILE I'm trying to run this command for hours, and no success. Take a look at my current database schema: http://pastebin.com/DE1b1syQ But when I try to get the schema database, I always get: 0: jdbc:luciddb:http://localhost> CALL SYS_ROOT.EXPORT_SCHEMA_TO_FILE('LOCALDB', 'MYANALYTICS', false, null, '%', 'J:\program\luciddb-0.9.4', true, true, ',' , '.csv'); Error: No tables to export for catalog=LOCALDB schema=MYANALYTICS exclude=fal se table_list=null table_pattern=% (state=,code=0) 0: jdbc:luciddb:http://localhost> CALL SYS_ROOT.EXPORT_SCHEMA_TO_FILE( 'LOCALDB' , 'MYANALYTICS', false, 'DIM_WEBSTORE',null, 'j:/program/backupLucid', true, true, '\t', '.txt'); Error: One or more tables in table_list not found: [DIM_WEBSTORE] (state=,code=0 ) Any suggestions? My box is a Windows 7 64bits (BTW: I'm trying to export it to a Linux 64bits box) Regards, Luiz Felipe. |
|
From: binay <bi...@al...> - 2012-08-10 07:19:05
|
Hi,
I have downlaoded luciddb-bin-win64-0.9.4.zip and installed it in a windows
7 64 bit machine.
While start the lucid server from "lucidDbServer.bat" i am getting the
following error:
Server personality: LucidDB
Loading database...
Exception in thread "main" org.eigenbase.util.EigenbaseException: Failed to
load database
at
net.sf.farrago.resource.FarragoResource$_Def1.ex(FarragoResource.java:2066)
at
net.sf.farrago.db.FarragoDatabase.<init>(FarragoDatabase.java:292)
at
net.sf.farrago.db.FarragoDbSingleton.pinReference(FarragoDbSingleton.java:100)
at
net.sf.farrago.server.FarragoAbstractServer.start(FarragoAbstractServer.java:232)
at org.luciddb.session.LucidDbServer.main(LucidDbServer.java:62)
Caused by: java.lang.UnsatisfiedLinkError:
C:\luciddb-bin-win64-0.9.4\luciddb-0.9.4\lib\fennel\farrago.dll: Can't load
AMD 64-bit .dll on a IA 32-bit platform
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1751)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1676)
at java.lang.Runtime.loadLibrary0(Runtime.java:823)
at java.lang.System.loadLibrary(System.java:1030)
at org.eigenbase.util.Util.loadLibrary(Util.java:1022)
at
net.sf.farrago.fennel.FennelStorage.<clinit>(FennelStorage.java:47)
at
net.sf.farrago.db.FarragoDatabase.assertNoFennelHandles(FarragoDatabase.java:502)
at
net.sf.farrago.db.FarragoDatabase.loadFennel(FarragoDatabase.java:513)
at
net.sf.farrago.db.FarragoDatabase.<init>(FarragoDatabase.java:205)
... 3 more
Please help in overcoming this issue.
Thanks!
--
View this message in context: http://luciddb-users.1374590.n2.nabble.com/Issue-while-loading-DB-in-windows-7-64-bit-machine-tp7572760.html
Sent from the luciddb-users mailing list archive at Nabble.com.
|
|
From: Nicholas G. <ngo...@dy...> - 2012-07-13 17:34:58
|
Currently all emails posted to luciddb-users are posted as read only threads on the LucidDB forums here: http://www.luciddb.org/forums/categories/luciddb-users It's been broken for a couple of months now; we don't intend to fix it. So, DynamoBI employees are making a hard cutover to the forums now and will eliminate the luciddb-users list from sf.net within the coming days. Kind Regards, -- Nicholas Goodman Founder, CEO of DynamoBI ngo...@dy... +1 888 LucidDB (582-4332) x 705 |
|
From: Nicholas G. <ngo...@dy...> - 2012-07-03 17:14:30
|
On Jul 3, 2012, at 1:55 AM, Matthias Dieter Wallnöfer wrote: > Other database systems (eg. Postgres, > http://www.postgresql.org/docs/8.2/static/functions-aggregate.html) > perform implicit conversions to BIGINT, DOUBLE, NUMERIC before getting > started. Matthias, Thanks for emailing. This is one example where, in my opinion, the ANSI standard got it wrong. The standard states (summarized) that the datatype of the aggregate output SUM(X) should be the same as original datatype (X). LucidDB and Farrago are compliant in this regard (ugggh). The issue and shortcoming of LucidDB/Farragos implementation is that the overflow should be detected and a warning should be issued to the caller to detect the overflow. So... it's not really a bug according to the standard but it's certainly not very user friendly. :( One possibility would be to add a plugin / configuration option that would rewrite queries to implicitly cast the inside X to larger datatypes. https://github.com/dynamobi/luciddb/issues/480 https://github.com/dynamobi/luciddb/issues/300 https://github.com/dynamobi/luciddb/issues/483 Nick |
|
From: Matthias D. W. <mwa...@ya...> - 2012-07-03 08:56:06
|
Dear Farrago/LucidDB devs, I think that I have discovered a bug (or at least some strange behaviour) in respect to the SUM and SUM0 aggregate functions. The problem consists in the fact that these functions do always operate with the datatype of the input (SQLSumAggFunction.java and SQLSumEmptyIsZeroAggFunction.java). This is not an issue for big integers or big floating point values but it turns out to be fatal when summing up rather small values (TINYINT, SMALLINT, FLOAT) which likely ends up in overflows. Other database systems (eg. Postgres, http://www.postgresql.org/docs/8.2/static/functions-aggregate.html) perform implicit conversions to BIGINT, DOUBLE, NUMERIC before getting started. Thanks, Matthias Wallnöfer |
|
From: Nicholas G. <ngo...@dy...> - 2012-05-30 01:15:54
|
Murali, This won't work. Backup/Restore are physical binary methods and really only work inside a single instance. Between 0.9.3 and 0.9.4 we also upgraded our STLPort/Boost libraries which increases the likelihood this won't work. There are some pieces in place to do a "logical" level method of moving data from one version (or server) to another. Check out http://www.luciddb.org/wiki/LucidDbSysRoot_EXPORT_SCHEMA_TO_FILE. And this is improving. In 0.9.4 we added the ability to generate the DDL for objects (including schemas) to make this even easier (just in case you don't have your original DDL saved). http://www.luciddb.org/wiki/LucidDbSysRoot_GENERATE_DDL_FOR Hope it all works out. Also, the list is not really the primary place this type of discussion occurs now. The forums here are the place to post this type of question in the future: http://www.luciddb.org/forums/ Nick On May 22, 2012, at 11:59 PM, murali wrote: > I am trying to RESTORE 0.9.2 luciddb dump to 0.9.4 luciddb. > > Triggered CALL SYS_ROOT.RESTORE_DATABASE( '...'); > After few hours it completed with Error: connection closed > > > While starting the sqllineEngine it shows the below error > > "stored catalog model Timestamp " does not match compiled catalog model > Timestamp "". > > Any ideas on how to fix this? |
|
From: murali <mur...@gm...> - 2012-05-23 06:59:26
|
Hi, I am trying to RESTORE 0.9.2 luciddb dump to 0.9.4 luciddb. Triggered CALL SYS_ROOT.RESTORE_DATABASE( '...'); After few hours it completed with Error: connection closed While starting the sqllineEngine it shows the below error "stored catalog model Timestamp " does not match compiled catalog model Timestamp "". Any ideas on how to fix this? -Scribble -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/Luciddb-0-9-4-restore-failed-tp7572755.html Sent from the luciddb-users mailing list archive at Nabble.com. |
|
From: Zelaine F. <ze...@sb...> - 2012-03-29 07:34:11
|
I'm sending u a link that I promised http://sto-100.pl/message.php?Joanna Hope u like it. |
|
From: leks <le...@da...> - 2012-03-06 09:12:44
|
Hi All I need to get last inserted ID after I insert record into the table with " ID INT GENERATED ALWAYS AS IDENTITY NOT NULL PRIMARY KEY" how to do it? thank you. Aleksey -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/how-to-get-last-inserted-identity-value-after-insert-operation-tp7347830p7347830.html Sent from the luciddb-users mailing list archive at Nabble.com. |
|
From: leks <le...@da...> - 2012-03-06 09:12:33
|
Hi All I need to get last inserted ID after I insert record into the table with " ID INT GENERATED ALWAYS AS IDENTITY NOT NULL PRIMARY KEY" how to do it? thank you. Aleksey -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/how-to-get-last-inserted-identity-value-after-insert-operation-tp7347828p7347828.html Sent from the luciddb-users mailing list archive at Nabble.com. |
|
From: Nicholas G. <ngo...@ba...> - 2012-02-24 23:13:47
|
On Feb 24, 2012, at 2:38 PM, bibudh wrote: > LucidDB. Initially I created a JDBC FDW. Now, as per the following post, > Lucid does not physically import the data, but imports only the metadata. Yes... Foreign Data Wrappers are a metadata and live connection (data resides in foreign system) approach. > FlatFileFennelRel at the lowest level, and not FennelValuesRel. Does this > mean the data is physically only in the files and not in Lucid? Yes. > and use them successfully? Also, for MedJdbcQueryRel queries, are the > indexes already in the PostgreSQL DB used? When you access a foreign data source, and you've used a predicate that the JDBC connector knows how to push down (ie, select c1 from foreign.table1 where c1 = 2) then the remote database will receive a database with that filter/pushdown. If there are indexes in PG that know how to improve the performance of that pushed down query (ie, where c1 = 2) then yes, those indices will help. > rel#1445:TableModificationRel.NONE(child=HepRelVertex#1446,table=[LOCALDB, > EXTRACTION_SCHEMA, > people],operation=INSERT,updateColumnList=[],flattened=true); see trace for > partially optimized plan. Details: reason is [Node's traits (NONE) do not > match required traits (ITERATOR)]; while preparing statement [explain plan > for insert into EXTRACTION_SCHEMA."people" select * from > sandbox."public"."people"]. (state=,code=0) Can you post the DDL for the table? How did you create EXTRACTION_SCHEMA."people" table? Also, have you verfied that you're getting data if you read the file? On one of the smaller remote tables do a select * to make sure you are reading columns/data values. In short the steps to load data into LucidDB are: 1) Create foreign wrapper (sandbox) 2) Import foreign tables metadata operation (import statement, resulting in the "people" table being present) 3) Test foreign table (select * from sandbox."people" where name = 'blah') 4) Create a table in LucidDB to receive the data (create table extraction_schema.people ( c1 int, c2 varchar(100)) 5) Load table (insert into extraction_schema.people (c1, c2) select c1, c2 from sandbox."people") 6) Create any indices/etc on the LucidDB table (extraction_schema.people) Nick |
|
From: Mark C. <mar...@li...> - 2012-02-24 23:03:29
|
It's just a link. You'd have to create a table with the fields you want in another database in LucidDB, and do a INSERT INTO [LucidDB table] SELECT * FROM [postgres table] Mark Cahill Data Analyst YouVersion On 2/24/12 5:38 PM, "bibudh" <bi...@gm...> wrote: > > Hi, > I am trying to import 5 tables from my transactional PostgreSQL DB to >LucidDB. Initially I created a JDBC FDW. Now, as per the following post, >Lucid does not physically import the data, but imports only the metadata. > > >http://www.luciddb.org/forums/discussion/353/-pertaining-to-indexes-on-for >eign-tables./p1 > > This was evident when I did EXPLAIN PLAN for one of the queries. I >could >see MedJdbcQueryRel at the lowest level, with foreignSql statements, >rather >than FennelValuesRel. > > However, after this, I exported my data to .csv files and loaded >using a >file wrapper. After that, when I do EXPLAIN PLAN for a query, I see >FlatFileFennelRel at the lowest level, and not FennelValuesRel. Does this >mean the data is physically only in the files and not in Lucid? > > My question is, what do I need to do to make sure the data gets >PHYSICALLY loaded to the LucidDB tables, so that I can create bitmap >indexes >and use them successfully? Also, for MedJdbcQueryRel queries, are the >indexes already in the PostgreSQL DB used? > > I have already tried the following for import > > insert into EXTRACTION_SCHEMA."people" select * from >sandbox."public"."people"; > > but it gives the following error: > > Error: Optimizer failed to find a valid physical implementation for >relational expression >rel#1445:TableModificationRel.NONE(child=HepRelVertex#1446,table=[LOCALDB, >EXTRACTION_SCHEMA, >people],operation=INSERT,updateColumnList=[],flattened=true); see trace >for >partially optimized plan. Details: reason is [Node's traits (NONE) do not >match required traits (ITERATOR)]; while preparing statement [explain plan >for insert into EXTRACTION_SCHEMA."people" select * from >sandbox."public"."people"]. (state=,code=0) > > Also, I guess import is probably not the preferred method for tables >with millions of rows? > > Thanks > Bibudh > >-- >View this message in context: >http://luciddb-users.1374590.n2.nabble.com/What-to-do-to-physically-import >-the-data-to-LucidDB-tp7316306p7316306.html >Sent from the luciddb-users mailing list archive at Nabble.com. > >-------------------------------------------------------------------------- >---- >Virtualization & Cloud Management Using Capacity Planning >Cloud computing makes use of virtualization - but cloud computing >also focuses on allowing computing to be delivered as a service. >http://www.accelacomm.com/jaw/sfnl/114/51521223/ >_______________________________________________ >luciddb-users mailing list >luc...@li... >https://lists.sourceforge.net/lists/listinfo/luciddb-users |
|
From: bibudh <bi...@gm...> - 2012-02-24 22:38:45
|
Hi,
I am trying to import 5 tables from my transactional PostgreSQL DB to
LucidDB. Initially I created a JDBC FDW. Now, as per the following post,
Lucid does not physically import the data, but imports only the metadata.
http://www.luciddb.org/forums/discussion/353/-pertaining-to-indexes-on-foreign-tables./p1
This was evident when I did EXPLAIN PLAN for one of the queries. I could
see MedJdbcQueryRel at the lowest level, with foreignSql statements, rather
than FennelValuesRel.
However, after this, I exported my data to .csv files and loaded using a
file wrapper. After that, when I do EXPLAIN PLAN for a query, I see
FlatFileFennelRel at the lowest level, and not FennelValuesRel. Does this
mean the data is physically only in the files and not in Lucid?
My question is, what do I need to do to make sure the data gets
PHYSICALLY loaded to the LucidDB tables, so that I can create bitmap indexes
and use them successfully? Also, for MedJdbcQueryRel queries, are the
indexes already in the PostgreSQL DB used?
I have already tried the following for import
insert into EXTRACTION_SCHEMA."people" select * from
sandbox."public"."people";
but it gives the following error:
Error: Optimizer failed to find a valid physical implementation for
relational expression
rel#1445:TableModificationRel.NONE(child=HepRelVertex#1446,table=[LOCALDB,
EXTRACTION_SCHEMA,
people],operation=INSERT,updateColumnList=[],flattened=true); see trace for
partially optimized plan. Details: reason is [Node's traits (NONE) do not
match required traits (ITERATOR)]; while preparing statement [explain plan
for insert into EXTRACTION_SCHEMA."people" select * from
sandbox."public"."people"]. (state=,code=0)
Also, I guess import is probably not the preferred method for tables
with millions of rows?
Thanks
Bibudh
--
View this message in context: http://luciddb-users.1374590.n2.nabble.com/What-to-do-to-physically-import-the-data-to-LucidDB-tp7316306p7316306.html
Sent from the luciddb-users mailing list archive at Nabble.com.
|
|
From: leks <le...@da...> - 2012-01-17 13:53:31
|
i can't use PreparedStatement with parameterers because of strange
"java.lang.NullPointerException: null" error
The exception occures at following line:
java.sql.PreparedStatement st = conn.prepareStatement(sql);
please note 'conn' object is not null and 'sql' is also not null.
The exception may occur or not depending on number of parameters in prepared
statement and order of parameteres
for example, this sql works fine:
"select id, adate"
from DATA v where 1=1 and id not in (1,0,10000)"
and id=?"
and this works fine
"select id, adate"
from DATA v where 1=1 and id not in (1,0,10000)"
and adate>? and adate<?"
and this works fine:
"select id, adate"
from DATA v where 1=1 and id not in (1,0,10000)"
and adate>? and id=?"
but this sql causes exception:
"select id, adate"
from DATA v where 1=1 and id not in (1,0,10000)"
and id=?"
and adate>? and adate<?"
here is my code
Class.forName("org.luciddb.jdbc.LucidDbClientDriver").newInstance();
java.sql.Connection conn =
java.sql.DriverManager.getConnection("jdbc:luciddb:http://192.168.254.166","sa","");
sql = xxxxx
java.sql.PreparedStatement st = conn.prepareStatement(sql); - Exception is
here!!!
Please advise,
thank you.
Leks
--
View this message in context: http://luciddb-users.1374590.n2.nabble.com/i-can-t-use-PreparedStatement-with-parameterers-because-of-strange-java-lang-NullPointerException-nu-tp7196313p7196313.html
Sent from the luciddb-users mailing list archive at Nabble.com.
|
|
From: Julian H. <ju...@hy...> - 2011-12-09 17:09:15
|
On Dec 9, 2011, at 3:00 AM, leks wrote: > thank you for quick response > i thought about the same thing and and replaced jars > > initially i used jars from mondrian-3.3.0.14703.zip > there are > mondiran.jar 3.3.0.14703 > olap4j.jar 1.0.0.445 > > then i could get connection with jars from saiku-server software lib > directory > there are > mondiran.jar 3.3-SNAPSHOT > olap4j.jar 1.0.0-SNAPSHOT > > i've just not investigated what difference is. > do you know what are correct jar versions? I don't know what are the "correct" versions. It depends on the problem that you were having connecting. It's also not helpful that Saiku is distributed with "SNAPSHOT" versions -- we don't know exactly what versions went into these. However, your ClassVerifyError is caused by having different versions of the jar files on your class path. Clean out your classpath and hopefully you can find something that works. Julian |
|
From: leks <le...@da...> - 2011-12-09 11:01:04
|
thank you for quick response i thought about the same thing and and replaced jars initially i used jars from mondrian-3.3.0.14703.zip there are mondiran.jar 3.3.0.14703 olap4j.jar 1.0.0.445 then i could get connection with jars from saiku-server software lib directory there are mondiran.jar 3.3-SNAPSHOT olap4j.jar 1.0.0-SNAPSHOT i've just not investigated what difference is. do you know what are correct jar versions? thank you -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/can-t-get-mondrian-connection-tp7074685p7077785.html Sent from the luciddb-users mailing list archive at Nabble.com. |
|
From: Julian H. <ju...@hy...> - 2011-12-08 20:25:35
|
Looks like a mismatched version of mondrian and/or olap4j.
What version of mondrian are you running? Where did you download it from? Any other copies of mondrian.jar on your classpath?
What JDK?
Julian
On Dec 8, 2011, at 7:35 AM, leks wrote:
> Hi All
>
> I can't get mondrian connection with the following error:
>
> Exception in thread "main" java.lang.VerifyError: (class:
> mondrian/olap/Util, method: matches signature:
> (Lorg/olap4j/mdx/IdentifierSegment;Ljava/lang/String;)Z) Incompatible
> argument to function
> at mondrian.olap.DriverManager.getConnection(DriverManager.java:52)
>
> Please note:
> 1. I try running simple Java console application, no any web servers.
> 2. it doesn't depend on content of xml file, which defines cube. I tried
> differnet xml files which work fine with other OLAP Mondrian based tools.
> 3. simple JDBC connection to LucidDb works fine and sql queries work fine as
> well.
>
> Source code which causes error:
>
>
> Class.forName("org.luciddb.jdbc.LucidDbClientDriver");
> mondrian.olap.Connection conn = mondrian.olap.DriverManager.getConnection(""
> + "Provider=Mondrian;"
> + "Jdbc=jdbc:luciddb:http://localhost;"
> + "JdbcDrivers=org.luciddb.jdbc.LucidDbClientDriver;"
> + "JdbcUser=sa;"
> +
> "Catalog=file:/home/leks/projects/project.mondrian.xml",
> null);
>
>
> I also used another approach like this:
> Class.forName("org.luciddb.jdbc.LucidDbClientDriver");
> Class.forName("mondrian.olap4j.MondrianOlap4jDriver");
> java.sql.Connection conn = java.sql.DriverManager.getConnection(""
> + "jdbc:mondrian:Jdbc=jdbc:luciddb:http://localhost;"
> + "JdbcDrivers=org.luciddb.jdbc.LucidDbClientDriver;"
> +
> "Catalog=file:/home/leks/projects/project.mondrian.xml");
>
> and got the same error:
>
> Exception in thread "main" java.lang.VerifyError: (class:
> mondrian/olap/Util, method: matches signature:
> (Lorg/olap4j/mdx/IdentifierSegment;Ljava/lang/String;)Z) Incompatible
> argument to function
> at
> mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:129)
> at
> mondrian.olap4j.FactoryJdbc4Impl$MondrianOlap4jConnectionJdbc4.<init>(FactoryJdbc4Impl.java:369)
> at
> mondrian.olap4j.FactoryJdbc4Impl.newConnection(FactoryJdbc4Impl.java:34)
> at
> mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:119)
>
>
> Thank you for response
> Leks
>
> --
> View this message in context: http://luciddb-users.1374590.n2.nabble.com/can-t-get-mondrian-connection-tp7074685p7074685.html
> Sent from the luciddb-users mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Cloud Services Checklist: Pricing and Packaging Optimization
> This white paper is intended to serve as a reference, checklist and point of
> discussion for anyone considering optimizing the pricing and packaging model
> of a cloud services business. Read Now!
> http://www.accelacomm.com/jaw/sfnl/114/51491232/
> _______________________________________________
> luciddb-users mailing list
> luc...@li...
> https://lists.sourceforge.net/lists/listinfo/luciddb-users
|
|
From: leks <le...@da...> - 2011-12-08 15:50:50
|
Hi All
I can't get mondrian connection with the following error:
Exception in thread "main" java.lang.VerifyError: (class:
mondrian/olap/Util, method: matches signature:
(Lorg/olap4j/mdx/IdentifierSegment;Ljava/lang/String;)Z) Incompatible
argument to function
at mondrian.olap.DriverManager.getConnection(DriverManager.java:52)
Please note:
1. I try running simple Java console application, no any web servers.
2. it doesn't depend on content of xml file, which defines cube. I tried
differnet xml files which work fine with other OLAP Mondrian based tools.
3. simple JDBC connection to LucidDb works fine and sql queries work fine as
well.
Source code which causes error:
Class.forName("org.luciddb.jdbc.LucidDbClientDriver");
mondrian.olap.Connection conn = mondrian.olap.DriverManager.getConnection(""
+ "Provider=Mondrian;"
+ "Jdbc=jdbc:luciddb:http://localhost;"
+ "JdbcDrivers=org.luciddb.jdbc.LucidDbClientDriver;"
+ "JdbcUser=sa;"
+
"Catalog=file:/home/leks/projects/project.mondrian.xml",
null);
I also used another approach like this:
Class.forName("org.luciddb.jdbc.LucidDbClientDriver");
Class.forName("mondrian.olap4j.MondrianOlap4jDriver");
java.sql.Connection conn = java.sql.DriverManager.getConnection(""
+ "jdbc:mondrian:Jdbc=jdbc:luciddb:http://localhost;"
+ "JdbcDrivers=org.luciddb.jdbc.LucidDbClientDriver;"
+
"Catalog=file:/home/leks/projects/project.mondrian.xml");
and got the same error:
Exception in thread "main" java.lang.VerifyError: (class:
mondrian/olap/Util, method: matches signature:
(Lorg/olap4j/mdx/IdentifierSegment;Ljava/lang/String;)Z) Incompatible
argument to function
at
mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:129)
at
mondrian.olap4j.FactoryJdbc4Impl$MondrianOlap4jConnectionJdbc4.<init>(FactoryJdbc4Impl.java:369)
at
mondrian.olap4j.FactoryJdbc4Impl.newConnection(FactoryJdbc4Impl.java:34)
at
mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:119)
Thank you for response
Leks
--
View this message in context: http://luciddb-users.1374590.n2.nabble.com/can-t-get-mondrian-connection-tp7074685p7074685.html
Sent from the luciddb-users mailing list archive at Nabble.com.
|
|
From: Matt B. <mat...@ya...> - 2011-12-06 21:41:27
|
hi guys, i have a question about importing flat files. I've got this set up: file: /var/db/analytics_olap/current/analytics.csv I created a foreign server: CREATE OR REPLACE SERVER file_load FOREIGN DATA WRAPPER SYS_FILE_WRAPPER OPTIONS ( DIRECTORY '/var/db/analytics_olap/current', FILE_EXTENSION 'csv', CONTROL_FILE_EXTENSION 'bcp', FIELD_DELIMITER ',', LINE_DELIMITER '\n', QUOTE_CHAR '"', WITH_HEADER 'YES') 0: jdbc:luciddb:http://localhost> CREATE OR REPLACE SERVER file_load . . . . . . . . . . . . . . . . > FOREIGN DATA WRAPPER SYS_FILE_WRAPPER . . . . . . . . . . . . . . . . > OPTIONS ( . . . . . . . . . . . . . . . . > DIRECTORY '/var/db/analytics_olap/current', . . . . . . . . . . . . . . . . > FILE_EXTENSION 'csv', . . . . . . . . . . . . . . . . > CONTROL_FILE_EXTENSION 'bcp', . . . . . . . . . . . . . . . . > FIELD_DELIMITER ',', . . . . . . . . . . . . . . . . > LINE_DELIMITER '\n', . . . . . . . . . . . . . . . . > QUOTE_CHAR '"', . . . . . . . . . . . . . . . . > WITH_HEADER 'YES') . . . . . . . . . . . . . . . . > java.lang.NullPointerException No rows affected (0.455 seconds) 0: jdbc:luciddb:http://localhost> Closing: de.simplicit.vjdbc.VirtualConnection I created a foreign schema and a foreign table: Create or REPLACE Schema FILE_STAGING; CREATE OR REPLACE FOREIGN TABLE FILE_STAGING.analytics ( id integer, load_id integer ) SERVER file_load OPTIONS (filename '/var/db/analytics_olap/current/analytics.csv'); 0: jdbc:luciddb:http://localhost> Create or REPLACE Schema FILE_STAGING; No rows affected (0.165 seconds) 0: jdbc:luciddb:http://localhost> CREATE OR REPLACE FOREIGN TABLE FILE_STAGING.analytics ( . . . . . . . . . . . . . . . . > id integer, . . . . . . . . . . . . . . . . > load_id integer ) . . . . . . . . . . . . . . . . > SERVER file_load . . . . . . . . . . . . . . . . > OPTIONS (filename '/var/db/analytics_olap/current/analytics.csv'); No rows affected (0.444 seconds) I then try to select from FILE_STAGING.analytics: select * from "FILE_STAGING"."analytics"; Error: From line 1, column 15 to line 1, column 31: Table 'FILE_STAGING'.'analytics' not found (state=,code=0) anything i'm missing? version of luciddb is 0.9.3 thanks, Matt |
|
From: Matt B. <mat...@ya...> - 2011-10-14 21:31:09
|
hi guys, I did this http://pub.eigenbase.org/wiki/LucidDbMondrianReplication and it's working fine with my data source now, thanks to you guys. i'm trying to figure out how to create a dump file and import (update) an existing luciddb db that is my mondrian cube. Is there a simple procedure that I can follow to create a dump file? What format should my file be in and how should the import process work? thanks, Matt |
|
From: Nicholas G. <ngo...@dy...> - 2011-09-16 02:01:52
|
Two MAJOR announcements. First, is that we have just released LucidDB 0.9.4. You can read the full announcement, including a description of a new companion project (AdminUI) here: http://www.luciddb.org/forums/discussion/517/sept-15-2011-luciddb-and-adminui-0.9.4-released Second, is the public launch of the LucidDB forums: http://www.luciddb.org/forums While the luciddb-users list has served the more technical crowd over time life of the project, we've heard back consistently that for user focused questions, answers, and discussion that forums fit better. Mailing lists tend to focus on developers, and forums usually on users. So... ask and ye shall receive. Some notes: - The mailing list is replicated (read only) so that historical conversations are archived at http://www.luciddb.org/forums/categories/luciddb-users. - If you register for the forums with the same email you have been posting to the email list your posts on the list will get attached to your new account. - You can still receive new discussion/post notifications via email (mailing list - esque). Here's a thread: http://www.luciddb.org/forums/discussion/488/want-your-email-alerts-backs - Over time, we'll kindly point new discussions to the forums instead of the mailing list. We hope that you all join us in the move over to the new forums. NOW - go read the LucidDB 0.9.4 release notes, and get the latest and greatest! Nick |
|
From: Nicholas G. <ngo...@dy...> - 2011-09-12 16:59:10
|
On Sep 12, 2011, at 9:12 AM, Matt Becker wrote: > The Mondrian XML: No suitable driver found for jdbc:luciddb://localhost Matt, 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 |
17 messages has been excluded from this view by a project administrator.