Re: [orientdb] OrientDB relationship betwen to classes results same row

I have the same question and I don't think the stackoverflow post answered my question. I have data from two classes that are connected by edges. Lets say that in class A I have name and last name, and in class B I have username (this is not really the case). When I execute a query using uniona

[orientdb] Re: Connect spark to orientdb

We recently developed the spark-orientdb connector that you can use for your purpose. You can find it on GitHub: spark-orientdb-connector You can use both OrientDB Document approach and Graph approach directly from the Spark Context with the

Re: [orientdb] SQL Select fields that have no data (null) in result set

Yes, photo is declared in the schema. On Wednesday, September 9, 2015 at 2:33:46 AM UTC-4, Enrico Risa wrote: > > Hi Scott > > is the field photo declared in the schema? > > 2015-09-08 17:32 GMT+02:00 Scott Wruble > > : > >> If I have a vertex, users, that has the following properties: firstname

[orientdb] 2.1.1 broke calculations in sql

I'm trying to move from 2.0.2 to 2.1.1, this query worked in 2.0.2 select hostname, date().asLong(), $agent.lastCommunicationTime[0].asLong() , date().asLong() - $agent.lastCommunicationTime[0].asLong(), $agent.version as agentVersion, $agent.lastCommunicationTime as lastCommunicat

[orientdb] Re: 2.1 broke my time series

This is still causing me grief. Isn't there any way to get a LINK MAP (i.e. Map) from a vertex? The problem with using vertex.getRecord().field("propName") is that any changes to the map are not persisted to the vertex. I have to do a vertex.setProperty("propName", map) to persist it but I'm no

[orientdb] OClass.createProperty WITH vs WITHOUT OClass Parameter (PERFORMANCE)

Hi all, I have been experimenting with an OrientDB setup (version 2.1.0) and noticed a very large difference in performance when passing in an OType parameter to a LINKSET vs leaving it out. Example: OClass logItem = schema.createClass("log_item"); logItem.createProperty("timestamp", OType.DATE

Re: [orientdb] Re: I'm wondering if OrientDB can handle my database

Good to know. My real scenery: 1 billion records Percona InnoDB table file size (ibd file): 300 GB table fields: about 16 (mixed string and integer et al) index: about 10 fields Hope this would give you an idea about MySQL On Friday, 11 September 2015 16:53:01 UTC+1, scott molinari

Re: [orientdb] Re: I'm wondering if OrientDB can handle my database

MongoDB definitely has compression (now) and I think OrientDB has compression too. In the 2.0 release announcement it says the binary protocol compresses the data, but then it says the snappy compression is turned off by default. So, not sure what all that means. Scott -- --- You received t

[orientdb] select * from CLASS doesn't give back empty fields

Hi If I run this query SELECT * FROM *CLASS* I don't give back the empty fields. For example in the class I have a schema name,place,order and if the order is empty I give just the name and the place, but I give SELECT * ? So how can I give all the fields even a field is empty? I use orient

Re: [orientdb] Re: I'm wondering if OrientDB can handle my database

actually, i missed - it is 200 billion records, so 200 * 255 * 4 ~= 204000 billion bytes, i.e. 204 PB if there is no compression :D On Friday, 11 September 2015 12:56:13 UTC+1, Milen Dyankov wrote: > > rofl > > you wish it was that simple, don't you ;) > > On Fri, Sep 11, 2015 at 1:53 PM, James

Re: [orientdb] Re: I'm wondering if OrientDB can handle my database

rofl you wish it was that simple, don't you ;) On Fri, Sep 11, 2015 at 1:53 PM, James Wang wrote: > about: > 2 * 255 * 4 ~= 2040 Billion Bytes > > :D > > On Friday, 11 September 2015 12:30:17 UTC+1, Milen Dyankov wrote: >> >> well yea ;) what I meant was for the example given in the original >>

Re: [orientdb] Re: I'm wondering if OrientDB can handle my database

about: 2 * 255 * 4 ~= 2040 Billion Bytes :D On Friday, 11 September 2015 12:30:17 UTC+1, Milen Dyankov wrote: > > well yea ;) what I meant was for the example given in the original request: > > ... records, each having 2 fields: A, and B, both strings of no more than >> 255 characters ... > > >

Re: [orientdb] Re: I'm wondering if OrientDB can handle my database

well yea ;) what I meant was for the example given in the original request: ... records, each having 2 fields: A, and B, both strings of no more than > 255 characters ... On Fri, Sep 11, 2015 at 1:23 PM, James Wang wrote: > That would depend on your db/table structures, I think > > On Friday,

Re: [orientdb] Re: I'm wondering if OrientDB can handle my database

That would depend on your db/table structures, I think On Friday, 11 September 2015 12:18:25 UTC+1, Milen Dyankov wrote: > > Just out of curiosity, can someone estimate how much of disk space would > be needed to store this amount of data in MongoDB vs OrientDB? > > > On Fri, Sep 11, 2015 at 1:09

Re: [orientdb] Re: I'm wondering if OrientDB can handle my database

Just out of curiosity, can someone estimate how much of disk space would be needed to store this amount of data in MongoDB vs OrientDB? On Fri, Sep 11, 2015 at 1:09 PM, scott molinari < scottamolin...@googlemail.com> wrote: > If you are only storing documents and don't really need the graph > fu

[orientdb] Re: I'm wondering if OrientDB can handle my database

If you are only storing documents and don't really need the graph functionality OrientDB offers (and what makes it so special), then you might want to go with MongoDB. Scott -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe fro

Re: [orientdb] Re: I'm wondering if OrientDB can handle my database

Sir, It was more than 3 months ago. I vaguely remember that I did the testing in remote mode (so I can do select queries at the same time - not sure if I could do importing data and select at the same time in plocal mode). And the ETL run on the same machine as the server. My table structur