Hi Diaa,
if you are implementing your functions in Javascript you can refer to this
http://orientdb.com/docs/last/Functions.html
To implement functions in Java, instead, you have to implement OSQLFunction
interface and register functions in the database using
the less, it should be possible to do such transactions also on
remote. So that it is possible for multiple worker to upload data to the
database.
Any ideas how to make this faster?
Regards,
Sven
Am Dienstag, 21. April 2015 17:11:19 UTC+2 schrieb Luigi Dell'Aquila:
much *F*aster of course
much *F*aster of course, not *m*aster...
2015-04-21 17:10 GMT+02:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com:
Ok, I saw the remote only now. If you want to go much master you should
use plocal (this avoids network overhead).
If you need other clients to connect to the db in remote mode
Hi Sven,
how are you connected to the db (remote or plocal)?
Could you post the details of your db schema, in terms of classes,
properties and index definitions?
Thanks
Luigi
2015-04-21 17:03 GMT+02:00 Sven Hodapp sven.hod...@gmail.com:
Hi together,
for my project I want to import a lot
Luigi Dell'Aquila luigi.dellaqu...@gmail.com:
Hi Sven,
how are you connected to the db (remote or plocal)?
Could you post the details of your db schema, in terms of classes,
properties and index definitions?
Thanks
Luigi
2015-04-21 17:03 GMT+02:00 Sven Hodapp sven.hod...@gmail.com
Hi cr0xfyre,
how are you measuring these times? Are you reading the query EXPLAIN?
I ask because this could be just the time Studio takes to render the
results, a query like this should take a few tens milliseconds to execute.
Luigi
2015-04-21 13:01 GMT+02:00 cr0xfyre achi...@gmail.com:
Hi
Hi Valeri,
composed indexes in some cases can be used also in basic queries, eg. if
you have an index defined on properties A, B and C, the following will use
the index too:
select from Foo where A = 1
It is only true if the fields in the query are a prefix of the index
itself (eg. properties
Hi Caleb,
which API are you using?
You can get this result just with a SELECT FROM a FETCHPLAN *:-1
2015-04-19 12:07 GMT+02:00 cloveret...@gmail.com:
Hi all,
Suppose that I have a tree like this:
- d
|
- b
||
a--- - e
|
- c - f
Hi Mahesh,
I will give you two examples, one with documents and links and the other
with vertices and edges.
Ex1:
You have a class Person with a link property father that points to
another person
you can do
traverse father from (select from Person where name = 'Bill') while $depth
3
you will
Hi,
no, it's not the expected behavior, query execution is supposed to return
the same results in single node and in distributed.
Could you please open an issue and (if you can) provide a simple test case?
Thanks
2015-04-17 11:41 GMT+02:00 ccasen...@axway.com:
Anyone to help ?
--
---
Hi Vitor,
I'm looking at that (actually thanks to this I found a regression on
2.1-snapshot and I'm fixing it too).
I'll give you a feedback ASAP
Luigi
2015-04-14 21:08 GMT+02:00 Vitor Enes Duarte vitorenesdua...@gmail.com:
Sorry to push this.
Is this an issue or am I missing something?
Hi Stefano,
this cannot work, because the document structure you have under the hood is
this:
(dataset vertex record) --(lives edge record)-- (collection vertex record)
so the out_lives will not contain a collectionid, but one or more record
ids of edges that then point to the collection.
I
Hi Patrick
a way to do this is the following
SELECT FROM (SELECT expand(out(Owns)) from #16:1) where out(Located)
contains #17:0
another way is with the intersect, that is supposed to work... I see that
at the beginning of main select there is a spare parenthesis, maybe that's
the problem. If
Hi Jeff,
this functionality is not currently in our roadmap.
You could open a feature request on OrientDB issue tracker, we will take it
into consideration
Regards
Luigi
2015-04-07 19:44 GMT+02:00 jwcarp...@gmail.com:
Hi, I don't believe it is currently possible in OrientDB to create
Hi Muley,
could you please try it with 2.1-SNAPSHOT or develop branch? I think it was
fixed it this release.
Luigi
2015-04-08 8:13 GMT+02:00 Muley savi.mu...@gmail.com:
Hi,
The problem is with single quote only. The same query is working properly
for normal string searching
full error
Hi,
current query executor cannot handle multiple indexes for multiple AND
clauses.
To do this you have to use a simple trick: execute two subqueries with LET
assignment and then use intersect() function.
eg.
select intersect($a, $b)
let
$a = (subquery1),
$b = (subquery2)
2015-04-04 14:10
Hi Elliot,
I noticed that in some cases traversedElement() acts in a strange way when
used in outer queries (referring to inner query traversal). I'd like to go
deeper into this, could you please:
1) try with select traversedElement(-2) ... and let me know what happens
2) post the full stack
Hi Mihai,
This use case is typical for a graph database, so I think OrientDB is a
perfect fit. You already have Dijkstra function, so you can use it or
modify it to create your own custom logic.
About connected subgraphs, you will be able to find what you need with very
simple TRAVERSE queries
Hi Kun,
MATLAB also supports HTTP/REST
http://it.mathworks.com/help/matlab/ref/webread.html
You can use it to query OrientDB
http://www.orientechnologies.com/docs/last/OrientDB-REST.html
Regards
Luigi
2015-04-04 22:01 GMT+02:00 Mattox Beckman mattoxbeck...@gmail.com:
Matlab seems to have a
Hi,
which OrientDB version?
Thanks
Luigi
2015-04-06 14:24 GMT+02:00 Muley savi.mu...@gmail.com:
HI,
I'm trying to search for a string from java application.My search string
is for ex : abc's and my search query is
select * from ( select expand( out('ProfileMasterTagEdge') ) from
Hi Mahesh,
an embedded database has a physical representation of data in files
(clusters) and a partial memory copy of them (disk cache).
When you read data, if they are not in memory, cluster pages are loaded
from files to disk cache.
When you insert/update records, they are written in disk
at 11:52:32 AM UTC-4, Luigi Dell'Aquila wrote:
Hi Fabio,
OrientDB Studio is open source, you can find source code here:
https://github.com/orientechnologies/orientdb-studio
It would be great if you could improve the standard behavior and become
an OrientDB contributor!
Regards
Luigi
2015
Hi
in OrientDB you can obtain schema information with
select expand(classes) from metadata:schema
or from java API with db.getMetadata().getSchema() and this will give you
all the information about classes, properties and indexes
You can also add custom metadata to classes and properties using
should have been an RTFM question :)
On Wednesday, April 1, 2015 at 7:52:10 AM UTC-4, Luigi Dell'Aquila wrote:
Hi Cameron
Studio at this time does not have an internal structure for plugins and
there are no plans for that, but you know, many decisions come from
community needs, so if it's
IMHO it's merely a bug, edge creation should check that both ends are
vertices
Luigi
2015-03-26 13:12 GMT+01:00 MrFT frederik.til...@vsko.be:
http://stackoverflow.com/questions/28781749/am-i-supposed-to-be-able-to-create-edges-between-two-edges-and-or-an-edge-and-a
Am I supposed to be
Hi Kun,
the answer to your question is no, in a single cluster you will find only
instances of a single class (that are also instances of its superclasses of
course).
Luigi
2015-03-25 22:35 GMT+01:00 Kun Liu liukunofc...@gmail.com:
Hi All,
I am new to OrientDB and learning it now. I wonder
Hi David,
you can just let V and E extend OTriggered, or define your hooks in Java if
you want to avoid it.
Regards
Luigi
2015-03-26 0:40 GMT+01:00 David Carr dcarr...@gmail.com:
After a bit of trial and error, I have been able to get hooks working on
custom classes extended from the
is a
class exists (using SQL)?
Thanks,
Patrick
On Monday, March 23, 2015 at 1:31:49 AM UTC-6, Luigi Dell'Aquila wrote:
Hi
Upsert is just a keyword in the UPDATE statement, eg.
update V set id = '12', name = 'foo' upsert where id = '12'
you can find all the docs here http
Hi Fabio,
OrientDB Studio is open source, you can find source code here:
https://github.com/orientechnologies/orientdb-studio
It would be great if you could improve the standard behavior and become an
OrientDB contributor!
Regards
Luigi
2015-03-25 14:34 GMT+01:00 Fábio Costa
Hi Stefan,
could you give us additional information about this machine? eg operating
system, JVM version
Thanks
Luigi
2015-03-20 22:36 GMT+01:00 ste...@activitystream.com:
Hi,
We are seeing the strangest thing here.
We have an embedded orentdb (2.0.5 / plocal) that create a new database
Hi,
I already answered in your previous email ;-)
2015-03-22 0:44 GMT+01:00 pumplerod pumple...@gmail.com:
I'm sorry, I thought I was in the pyorient group. Though perhaps someone
here can answer the question.
On Saturday, March 21, 2015 at 6:43:21 PM UTC-5, pumplerod wrote:
is there
for command request:
sql.upsert
On Wednesday, February 4, 2015 at 9:08:04 AM UTC-6, Luigi Dell'Aquila
wrote:
Hi Artem,
have you tried with UPSERT?
Here you can find all the references:
http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Update.html
Regards
Luigi
2015-02-04 13
Hi Stas,
you could implement a hook for this. You can do this in Java or Javascript
(see http://www.orientechnologies.com/docs/last/Hook.html ), just ensure to
* bind your application logic on the following events: onBeforeCreate,
onBeforeUpdate
* let your hook functions return RECORD_CHANGED
to implement hierarchical access to data so that field has more
than just the owner. It has the owner and all of the owner's parents so
not an easy way to determine which in fact is the owner of the data. Any
other way I can get the owner?
On Tuesday, March 17, 2015 at 8:50:35 AM UTC-7, Luigi
V and E? Are there special powers associated with V
and E that I would lose in such a case?
Thanks very much!
Patrick
On Tuesday, March 17, 2015 at 9:50:35 AM UTC-6, Luigi Dell'Aquila wrote:
Hi Rob,
if your class extends ORestricted, the owner is tracked in one of the
following fields
Hi Rob,
if your class extends ORestricted, the owner is tracked in one of the
following fields:
_allow
_allowRead
_allowUpdate
_allowDelete
2015-03-17 16:39 GMT+01:00 Rob Gratz gratz@gmail.com:
Is there a way to obtain which user created or owns a record?
--
---
You received this
Hi Vadim,
I don't know how many items you expect in your db, but I think your data
representation could take you to very expensive queries...
I suggest you to take a look at this, maybe you can pick some ideas
http://www.slideshare.net/LuigiDellAquila/orientdb-time-representation
Luigi
Hi Joao,
it depends on how your source data are represented. If you have sequential
integer/long keys for vertexes, you can use OGraphBatchInsert class
Luigi
2015-03-13 10:30 GMT+01:00 Vitor Enes Duarte vitorenesdua...@gmail.com:
graph.declareIntent(new OIntentMassiveInsert());
// inserts
Hi Jeffrey,
I think you looked at this:
http://www.orientechnologies.com/docs/last/orientdb.wiki/Lightweight-Edges.html
In terms of performance lightweight edges are better, but they are harder
to manage because:
- you cannot refer a lightweight edge by its RID (a lightweight edge is not
a
Exactly
2015-03-12 18:03 GMT+01:00 Jeffrey Auguste mrjaugu...@gmail.com:
Ah, so I can create an edge class extended from E and it will still be
lightweight, Its when/if I add link properties to it, that it will then
become an edge document.
On Thu, Mar 12, 2015 at 12:57 PM, Luigi
Yes, it's right, you can turn lightweight edges on in any moment.
Actually to create a regular edge (instead of lightweight), defining a
class for it is not enough, you just have to explicitly add a property to
that.
Luigi
2015-03-12 17:55 GMT+01:00 Jeffrey Auguste mrjaugu...@gmail.com:
So it
Hi Aaron,
TinkerPop Blueprints considers id as a reserved property name, so you
cannot use it, unless you disable standard constraints (exactly what you
did!)
Luigi
2015-03-12 21:45 GMT+01:00 Aaron Gooch eodgo...@gmail.com:
I was able to get around this issue by setting
Hi guys,
we have an open issue about this
https://github.com/orientechnologies/orientdb/issues/2081
A work-around is to do a massive update on V class immediately after edge
rename, eg.
update V set out_NewEdgeClassName = out_OldEdgeClassName
update V remove out_OldEdgeClassName
update V set
Hi Alexander,
AFAIK you cannot create a full distribution from maven repositories.
If you want a particular Git branch or tag, I suggest you to clone it
locally (see https://github.com/orientechnologies/orientdb ) and then
launch
ant clean install
you will have a full distribution in
for testing, or
some test data with the query and index I'm using?
Best regards,
Mate
On Thursday, March 5, 2015 at 10:51:26 AM UTC+1, Luigi Dell'Aquila wrote:
Hi Mate,
there are no limitations in the number of properties that can be indexed,
so there must be a bug somewhere.
Could you
Hi Mate,
there are no limitations in the number of properties that can be indexed,
so there must be a bug somewhere.
Could you provide a test case to reproduce it?
Thanks
Luigi
2015-03-04 22:25 GMT+01:00 Máté Gábri gabrim...@gmail.com:
Hi,
I'm trying to get familiar with OrientDB's
Hi Raffaela,
at this time the only section about security is chapter 5. We are enriching
the documentation every day, with a continuous and iterative work, so if
you have any suggestions about what you want to see covered, we will be
happy to take them into consideration
Thanks
Luigi
Hi Kiheung,
answers below:
2015-03-02 23:39 GMT+01:00 Kiheung Park kihpar...@gmail.com:
Hi Colin,
Question 1:
You'll just embed another document (or vertex) in the contact property.
Are you trying to do this from the Java API?
-- Yes or no. I was trying to modeling through studio. If Java
in
github for this?
Thanks,
Jamie
On Monday, March 2, 2015 at 4:55:51 PM UTC, Luigi Dell'Aquila wrote:
Hi Jamie,
this is a known issue, we are working hard on the new query parser and
executor and one of the main goals of all this is query optimization.
Thanks
Luigi
2015-03-02 17:11
Hi Jamie,
this is a known issue, we are working hard on the new query parser and
executor and one of the main goals of all this is query optimization.
Thanks
Luigi
2015-03-02 17:11 GMT+01:00 Jamie Blair jamie.bl...@gmail.com:
The following query returns a set of `@rid` and completes in
Hi,
you can use CONTAINS instead of = (because in_* and out_* are collections)
I also suggest you to use in() and out() functions, eg.
select in(Owns).userID from items
Luigi
2015-02-25 8:18 GMT+01:00 Dlpnet dlp...@gmail.com:
Hello
I have a simple DB:
users -- Owns -- items
when I
15:55 GMT+01:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com:
Hi Julian,
first of all let's make your query work, this is the right one:
select from FOrder where user IN (select @rid from FUser where userId =
642255)
Please note that I used IN operator instead of = because a query returns
Hi Stefan,
there is no explicit support to this (you can open a feature request on the
issue tracker if you want), but there is a work-around to obtain this
information:
OrientVertex v = ...
ODocument doc = v.getRecord();
String fieldNames = doc.fieldNames();
ListString edgeClassNames = new
, I tried doing a plocal (create a DB as plocal
? ) can you please help me how to go with it? I am a newbei to orientdb.
We are trying to have a data model as DWH like facts and dimensions in
orientdb.
Thanks,
Shivanandan Gupta
On Thursday, 19 February 2015 13:26:58 UTC+5:30, Luigi
2015 14:40:04 UTC+5:30, Luigi Dell'Aquila wrote:
Hi Shivanandan,
you can just replace this
loader: {
orientdb: {
dbURL: remote:localhost/databases/indb,
dbUser: root,
dbPassword: root,
dbAutoCreate: true,
tx: false,
batchCommit: 1,
dbType: graph
Hi Shivanandan,
the easy way to go faster is using plocal instead of remote, but I don't
know if in your case it's possible (other instances OrientDB have to be
shut down for the time ETL works...)
Luigi
2015-02-19 7:19 GMT+01:00 Shivanandan Gupta shivnandangu...@gmail.com:
Hi All,
I tried
TO MAKE IT PERFECT!!!
Thanks
Luigi
--
Luigi Dell'Aquila
Orient Technologies LTD
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr
by Luca,
http://stackoverflow.com/questions/22606111/orientdb-problems-with-clusters-concept.
I thought I might be missing out something.
On Wednesday, February 11, 2015 at 5:42:27 PM UTC+8, Luigi Dell'Aquila
wrote:
Hi Goh,
That post is really misleading...
In OrientDB you can define multiple
Hi Renzo,
the first query should be something like
select expand(inE('owner')[color ='red'].outV()) from car where name =
'Ferrari'
The second one is just
select out.name as ownerName, color, in.name as carName from owner
Luigi
2015-02-10 22:08 GMT+01:00 Renzo Ludeña
Hi Goh,
That post is really misleading...
In OrientDB you can define multiple clusters per class, and all the
sharding architecture is based on that. To have a better idea of this I
suggest you to check the following links
the first path ? It seems like
a bit of a hack, don't you think ? :(
I'm using OrientDB 2.0.1 BTW.
Thanks !
On Tuesday, February 10, 2015 at 8:53:58 AM UTC+1, Luigi Dell'Aquila wrote:
Hi Georg,
in current implementation it's not possible. Anyway Dijkstra and
ShortestPath functions
Hi Georg,
in current implementation it's not possible. Anyway Dijkstra and
ShortestPath functions are quite simple (links to the source code below),
you could just implement your own version starting from them and (why not?)
send a pull request and become OrientDB contributor.
Hi Andy,
This is a known issue, you can find all the details here:
https://github.com/orientechnologies/orientdb/issues/3203
Luigi
2015-02-05 16:58 GMT+01:00 dakota.pric...@gmail.com:
Hello,
I am unable to create an in MEMORY distributed database due to the
following exception:
Hi Arinath,
if it's just a one-shot batch insert, you can write a simple Java program
and use OGraphBatchInsertBasic class, that is specifically designed for
this simple use case.
Otherwise you could think about using OrientDB ETL and define a simple
importer from CSV, see
Hi,
current implementation of schema manipulation is not so strict, and
especially is not related to already existing data, but only to new
operations. We know this is an issue and we are addressing it, you will
find important changes about this in next releases
Luigi
2015-02-03 18:28
Hi Artem,
have you tried with UPSERT?
Here you can find all the references:
http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Update.html
Regards
Luigi
2015-02-04 13:25 GMT+01:00 Artem Shoobovych shybovy...@gmail.com:
Hi there!
Lately, I've been playing with OrientDB of 1.7.10
; }
public double Height { get; set; }
public DateTime DateOfBirth { get; set; }
public decimal Salary { get; set; }
}
On Friday, January 30, 2015 at 5:31:29 PM UTC+8, Luigi Dell'Aquila wrote:
Hi Siang,
all hash indexes do not support range queries (they are based on hash
Hi Oleg,
do you mean that you are adding properties to the schema or that you are
adding property values to existing vertexes?
What I suggest you is:
- create schema with properties before the insert operations (this will
save space on the disk because property names are not stored in the record
have any suggestion?
Thanks.
On Friday, January 30, 2015 at 4:43:25 PM UTC+8, Luigi Dell'Aquila wrote:
Hi Siang,
which kind of index did you define? Not all types of index support range
queries
Luigi
2015-01-30 9:05 GMT+01:00 Siang Hwee Goh gohsia...@gmail.com:
I am evaluating
Of course I meant use plocal instead of remoTe
Just a typo ;-)
Luigi
2015-01-30 11:29 GMT+01:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com:
Hi Oleg,
do you mean that you are adding properties to the schema or that you are
adding property values to existing vertexes?
What I suggest you
Hi Siang,
which kind of index did you define? Not all types of index support range
queries
Luigi
2015-01-30 9:05 GMT+01:00 Siang Hwee Goh gohsiangh...@gmail.com:
I am evaluating OrientDB right now and I tried to inserts 1.2 million
simple records inside one of the database. It is an
oh, sorry, I saw only now that I wrote remote instead of remove ;-)
anyway you got the point :)
Luigi
2015-01-30 12:49 GMT+01:00 florin flo...@wisemart.com:
Thanks!
On Friday, January 30, 2015 at 2:29:21 AM UTC-5, Luigi Dell'Aquila wrote:
Hi Florin,
null is a valid value for a property
Hi Oleg,
it seems to be ok, the throughput depends a lot on the size of single
documents, on the number and type of indexes you use (I can say that Lucene
indexes demonstrated to have the best performance in insert) and on the
type of connection you are using (plocal or remote).
1M per minute
Hi Florin,
null is a valid value for a property, so setting it to null just leaves it
there, in the document.
If you want to completely remove a property you have to use this statement:
update MyClass remote myPropertyName where...
regards
Luigi
2015-01-30 1:09 GMT+01:00 florin
to that ? Because from what I can
see, I've done nothing different from Rc1 and RC2 to final1.
On Monday, January 26, 2015 at 12:05:27 PM UTC, Luigi Dell'Aquila wrote:
Hi,
this must be because of disabled lightweight vertices. In Graph Studio
tab only fetched records and their neighbors
Hi,
with current version (as Keith said) schema-defined fields are more compact
in terms of disk space. In next releases you will also have additional
advantages in terms of query speed.
But the most significant difference is that defining properties you can
- enforce constraints on fields (min,
Hi George,
link traversal is O(1) operation because the RID is like a physical pointer
to data. Using UUID would mean relying on an index to find the RID
corresponding to the UUID.
SBTree index you will give you O(logN) performance.
HashIndex will give you a near O(1) performance in the average
Hi Andrei,
In OrientDB you can use the if() function to do what you need. I just added
it to the documentation, please check this wiki page.
https://github.com/orientechnologies/orientdb/wiki/SQL-Functions
Soon it will also be in the official Docs page
Luigi
2014-12-19 8:51 GMT+01:00 Andrei
Hi Stéphane,
content is a reserved word in OrientDB SQL syntax, current parser
implementation does not complain about it (while it should), but final
result is unpredictable, like this.
The new parser implementation is more strict and will report an error at
parse time.
Strict query syntax
Hi Sajal,
lightweight edges are still available and the alter database command is
the right way to enable them, so if you are not able to create one maybe
there is an error in your code or an issue in the release.
Could you provide a snippet of code (or better, a test case) to replicate
the
...?
On Wed, Dec 17, 2014 at 12:25 PM, Ankit Jain foranki...@gmail.com wrote:
ok..
On Wed, Dec 17, 2014 at 12:22 PM, Ankit Jain foranki...@gmail.com
wrote:
ok.
On Wed, Dec 17, 2014 at 12:21 PM, Luigi Dell'Aquila
luigi.dellaqu...@gmail.com wrote:
Hi,
sorry, I saw this email only now
+01:00 Ankit Jain foran...@gmail.com:
we can find out that from jar file..can u tell in which jar it is??
On Monday, 15 December 2014 19:58:44 UTC+5:30, Luigi Dell'Aquila wrote:
Hi,
OServetAdmin is in package com.orientechnologies.orient.client.remote
Apparently all the client package
Hi Stéphane,
I suggest you to wait a few hours, as OrientDB RC1 will be released shortly
Luigi
2014-12-15 17:01 GMT+01:00 Stéphane Schild stephane.sch...@gmail.com:
Hello,
You're right, I should not have supposed that this version was stable.
However, I need to evaluate OrientDB for my
Hi Simon,
you can do something like this
select set($comments[0], $comments[1], $comments[2]) from SOME_POST_ID let
$comments = sort(out('PostHasComment'))
or
but edges are not guaranteed to be sorted, so you have to write your own
sort() function.
If you are using M3 or earlier, function
Thanks a lot
Luigi
2014-11-25 8:25 GMT+01:00 l...@emaxsrl.com:
Done!
https://github.com/orientechnologies/orientdb/issues/3094
Il giorno lunedì 24 novembre 2014 18:52:05 UTC+1, Luigi Dell'Aquila ha
scritto:
Hi Luca,
this is clearly a bug, could you please report it in OrientDB issue
,percentile,median,variance,difference,first]`
On Tuesday, November 25, 2014 3:26:46 AM UTC-5, Luigi Dell'Aquila wrote:
Hi Simon,
you can do something like this
select set($comments[0], $comments[1], $comments[2]) from SOME_POST_ID
let $comments = sort(out('PostHasComment'))
or
but edges
, Luigi Dell'Aquila wrote:
Hi Simon,
my mistake, I was not clear at all, the sort() function is not a built-in
function, my proposal was to implement your own function called sort() in
javascript and use it in the query
Luigi
2014-11-25 16:55 GMT+01:00 Simon L si...@pumpup.co:
Thanks
Hi Stefan,
try to remove parentheses from your query, like this:
insert into GermanyClient from select from Client where country = 'Germany'
current SQL parser implementation sometimes is not so friendly, we are
completely rewriting it and the new one will be released in 2.1
About the fromMap,
Hi Riccardo,
what TinkerPop calls labels is represented by OrientDB classes.
You can create a lightweight edge of a particular class with this syntax:
CREATE EDGE MyLabel FROM #14:1 TO #14:0
Of course the class MyLabel has to exist and has to extend E
If you use the SET labelName = value, the
Hi Luca,
this is clearly a bug, could you please report it in OrientDB issue
tracker?
https://github.com/orientechnologies/orientdb/issues
We will fix it ASAP
thanks
Luigi
2014-11-24 18:32 GMT+01:00 l...@emaxsrl.com:
Hello,
I'm using OrientDB version : 2.0-M3.
I created a test function
Hi Jan,
in this use case you will not have big advantage from typical NoSQL
features like index free adjacency (that means fast traversal) or dynamic
schema management. You are actually using OrientDB as a relational db.
Anyway performance you are having is definitely too slow!
I suggest you to
ah, for cases where you know that you don't need range queries I suggest
you to use OClass.INDEX_TYPE.NOTUNIQUE_HASH_INDEX, it's much much faster!
Luigi
2014-11-14 10:04 GMT+01:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com:
Hi Jan,
in this use case you will not have big advantage from
Hi Charles,
at this moment there is no built-in procedure to encrypt root password,
anyway IMHO this problem can be bypassed with some simple modifications.
The real problem is another one: the DB files are not encrypted in any way,
so if your customer copies the orient/databases/ directory on
Hi,
the best thing to do this should be something like this:
update myClass set columnB = columnA.split(,)
but unfortunately it's NOT supported at this time.
As a work around, you can define your own split() function like this
- two parameters: inputString and separator
- this function body:
Hi Mark,
one or two years ago I tested OrientDB on Raspberry PI and it worked fine
(of course the performance was not the same as on my laptop, but it was
more than acceptable). At that time I used Java8 alpha for ARM and that
gave me very good results.
If what you are interested in is a time
Hi Kristoffer,
Invoking server side functions from inside other functions should be
straightforward.
Could you post some of your code? Maybe we can help you better that way.
Luigi
2014-11-06 13:06 GMT+01:00 BojanV bboojja...@gmail.com:
Did you try with sql batch?
:10 UTC+1 torsdag 6. november 2014 skrev Luigi Dell'Aquila
følgende:
Hi Kristoffer,
Of course you can use this approach, this is not bad practice in general,
but sometimes you can find easier solutions to do that.
Here are a couple of examples, they all work fine for me.
I hope you can find
Hi Stefan,
I think this can help you
http://www.orientechnologies.com/docs/last/orientdb.wiki/Graph-Database-Tinkerpop.html#ordered-edges
Luigi
2014-11-05 10:35 GMT+01:00 ste...@activitystream.com:
bump ... again
On Tuesday, 4 November 2014 08:10:37 UTC, ste...@activitystream.com wrote:
it though.
Am I missing something in the release 2 M2 version ?
Also, are you planning to have a backup to file system ( not snapshot) and
without blocking writes in a future release ?
Regards,
Santosh
On Wednesday, October 29, 2014 4:02:06 AM UTC-7, Luigi Dell'Aquila wrote:
Hi Santosh
Hi Frederik,
this kind of issues is related to some legacy code in current query parser
implementation. We are completely rewriting it, so it will be fixed in 2.1.
If you want you can open an issue about this, I'll take care of it.
About third query, I tried it in Studio with a fresh
501 - 600 of 618 matches
Mail list logo