You can use the IN operator, for example if each vertex has a field "tags",
which is a list of strings:
SELECT FROM V WHERE 'party' IN tags
Cheers,
Riccardo
Il 19/nov/2014 17:04 "Seamus Minogue" ha scritto:
> I am storing a List into a field in my record. Is there a way using the
> SQL syntax t
Good advice,
Now it's in:
http://www.orientechnologies.com/docs/last/
Lvc@
On 20 November 2014 00:48, Luke Worth wrote:
> Amazing, thanks! I couldn't find that link on the OrientDB website
> anywhere; if anyone from Orientechnologies is reading I'd suggest making
> that documentation more acc
Looks like this has been fixed with the latest 2.0-M3 release.
Thanks!
On Friday, November 14, 2014 3:36:24 PM UTC+11, yi...@icm-consulting.com.au
wrote:
>
> Hi,
>
> We've encountered an issue where we're getting
> ConcurrentModificationException when committing a transaction. The details
> a
For MSSQL 2012, I followed the following instructions,
Type 1:
http://www.codewiz51.com/blog/post/2014/02/23/Installing-MS-Sql-Server-JDBC-40-Driver.aspx
(I followed all steps, except the step 6 since, I have build the jdbc in my
local directory.)
Type
2: http://www.microsoft.com/en-us/downl
Hi guys,
We've just released OrientDB 1.7.10 as hotfix of 1.7.x version. If you are
in production with 1.7.x, please upgrade it.
Lvc@
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails fro
Amazing, thanks! I couldn't find that link on the OrientDB website
anywhere; if anyone from Orientechnologies is reading I'd suggest making
that documentation more accessible.
Thanks
Luke
On Wednesday, November 19, 2014 6:57:55 PM UTC+11, Riccardo Tasso wrote:
>
> You can use the 1.7.8 document
You are right ! I need to use ETL 1.0 from OrientDB and it is working good.
I can transfer data from MySQL to OrientDB. Thank you !
On Wednesday, November 19, 2014 7:17:17 PM UTC+2, GoorMoon wrote:
>
> which version of orientdb-etl tool you using ?
> if you compile from source i guest you using l
You're right, that's weird but I guess the reason is related to what I am
saying.
Riccardo
2014-11-19 23:06 GMT+01:00 Curtis Stanford :
> That makes sense if the indexes output is showing unique values. Just
> seemed weird that it was different than the output of select count(*) from
> index:...
That makes sense if the indexes output is showing unique values. Just
seemed weird that it was different than the output of select count(*) from
index:...
On Wednesday, November 19, 2014 3:03:37 PM UTC-7, Riccardo Tasso wrote:
>
> I don't know Orient internals but if the index is not unique you
I don't know Orient internals but if the index is not unique you can have
many values associated to the same key.
Imagine the table:
rid, Name, City
#1:1, Riccardo, Trento
#1:2, Roberto, Torino
#1:3, Riccardo, Milano
#1:4, Raffaella, Torino
Index by Name (not unique):
key: Riccardo, value: [#1:1,
I can see from the code that it only does the first. I'd like to submit a
request that edges be made to all matching results.
On Wednesday, November 19, 2014 2:29:10 PM UTC-7, Curtis Stanford wrote:
>
> I have a question about creating edges with ETL. If the index named in the
> "lookup" propert
I have a question about creating edges with ETL. If the index named in the
"lookup" property of the edge transformer returns more than 1 result, will
edges be creating to all of the resulting vertices or just the first one?
I'm only seeing one edge created even though the lookup should return mo
I have a vertex class that has 58,383 records in it. I also have a
NOTUNIQUE index on one of the fields. A select count(*) on the index itself
results also in 58,383. However, typing "indexes" in the console shows that
it only has 43,342 records. Why is it different?
I tried rebuilding the inde
unfortunately, current request will choose the names of classes which are
direct descendants of superclass E and contain at least one record
is there a method of children classes checking on a case of superclass?
пятница, 14 ноября 2014 г., 17:05:07 UTC+2 пользователь bshi...@flex125.com
написа
unfortunately, current request will choose the names of classes which are
direct descendants of superclass E and contain at least one record
пятница, 14 ноября 2014 г., 12:17:17 UTC+2 пользователь Juriy Ivanov
написал:
>
> we have
> class Z superClass V,
> class A superClass E,
> class B superC
Did you put the MSSQL driver in the Lib folder?. Because I needed one for
MySQL.
Am Mittwoch, 19. November 2014 17:46:22 UTC+1 schrieb Raj:
>
>
> Currently, I am using *orientdb-community-1.7.9 *and *MySQL *database.
> On Wednesday, November 19, 2014 6:43:05 PM UTC+2, GoorMoon wrote:
>>
>> Are yo
which version of orientdb-etl tool you using ?
if you compile from source i guest you using latest version that not
compatible with orientdb-community-1.7.9
On Wednesday, November 19, 2014 6:45:30 PM UTC+2, Raj wrote:
>
> Currently, I am using *orientdb-community-1.7.9 *and *MySQL *database.
>
>
Currently, I am using *orientdb-community-1.7.9 *and *MySQL *database.
On Wednesday, November 19, 2014 6:43:05 PM UTC+2, GoorMoon wrote:
>
> Are you using orientdb-etl 2.0-M3 version with oriendb-community-1.7.9
> version?
>
> On Wednesday, November 19, 2014 6:20:42 PM UTC+2, Raj wrote:
>>
>> I d
Currently, I am using *orientdb-community-1.7.9 *and *MySQL *database.
On Monday, November 17, 2014 7:50:20 PM UTC+2, Raj wrote:
>
> I am new to OrientDB and JSON. I am trying to follow the steps in:
> http://www.orientechnologies.com/docs/last/orientdb-etl.wiki/Import-from-DBMS.html
>
> I am not
Currently, I am using *orientdb-community-1.7.9 *and *MySQL *database.
On Wed, Nov 19, 2014 at 6:43 PM, GoorMoon wrote:
> Are you using orientdb-etl 2.0-M3 version with oriendb-community-1.7.9
> version?
>
> On Wednesday, November 19, 2014 6:20:42 PM UTC+2, Raj wrote:
>>
>> I didn't know that ea
Are you using orientdb-etl 2.0-M3 version with oriendb-community-1.7.9
version?
On Wednesday, November 19, 2014 6:20:42 PM UTC+2, Raj wrote:
>
> I didn't know that earlier. Thank you ! I tried that and I get a
> exception. I have also attached the images.
>
> On Wednesday, November 19, 2014 5:1
I didn't know that earlier. Thank you ! I tried that and I get a exception.
I have also attached the images.
On Wednesday, November 19, 2014 5:15:27 PM UTC+2, GoorMoon wrote:
>
> You need to run from cmd and not from studio.
> Save you config file with directory oetl.bat (exm. config.json)
> and
I am storing a List into a field in my record. Is there a way using the SQL
syntax to query for records where a value is in that list?
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails fr
Thx to Enrico in Gitter.
Reason was that .exists() is not working in remote mode. Disabling helped.
But anyway it seems to changed some more things.
Files are imported successful but kind of no indexes and some errors in the
log.
Am Mittwoch, 19. November 2014 16:36:40 UTC+1 schrieb Curtis Mos
Finally I found time to test it. But it's not working.
Exception in thread "main" java.lang.UnsupportedOperationException: Cannot
check the existance of a database in a remote server. Please use the
console or the OServerAdmin class.
at
com.orientechnologies.orient.client.remote.OStorageRem
You need to run from cmd and not from studio.
Save you config file with directory oetl.bat (exm. config.json)
and run *oetl.bat config.json from* command prompt.
On Wednesday, November 19, 2014 5:01:58 PM UTC+2, Raj wrote:
>
> Hi ! Thank you for your guidance. I tried with *orientdb-community-1.7
FWIW you can also generate the javadocs from the source using ant, it's
pretty easy.
On Tuesday, November 18, 2014 7:19:49 PM UTC-7, Luke Worth wrote:
>
> Is there documentation available for OrientDB 1.7.9? We are using that
> version (as it is the latest production release) but the website on
Hello,
I try to create a javascript function to execute a complex sql query with
parameters.
I tried to pass positional parameters, but, from what i've seen and read,
that's does'nt work with subqueries.
So, i'd like to know if it is possible to use named parameters for sql
queries in javascr
Hi Rudy,
Just att a cluster to your logical entity, the class. Example for class
"Log":
CREATE CLUSTER Log_201410
ALTER CLASS Log ADDCLUSTER Log_201410
When you save a record from Java API use:
document.save( "Log_201410" );
or via SQL with:
INSERT INTO Log CLUSTER Log_201410 VALUES ...
Lvc@
Update: The difference seems to be that Studio has "shallow collection"
selected by default. Unselecting that means that Studio brings back the
full result set - and takes a very long time (I didn't time it but several
minutes), although it reports a query execution time of just 0.6s (so I
assu
Looking at this again...
If I run SELECT * FROM myClass in OrientDB Studio, it returns the count of
edges without returning the list of edges, and does it much quicker than my
PHP code (0.1s vs ~20s).
How do I replicate what Studio is doing? Or, how do I find out what Studio
is doing behind th
Hi,
I want to use orientdb to create logic cluster that contains the past month
record
it will improve the performance, if I direct query that cluster.
How to do it?
Thanks
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from t
Great!
guys, *you rock!*
--
---
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...@googlegroups.com.
For more options, visit https://groups.
33 matches
Mail list logo
