I tried to use Teleporter but i got ArrayOutOfIndexException when i use
-include option with 2 or more tables.
Example:
oteleporter.bat -jdriver oracle -jurl jdbc:oracle:thin:@mydb -ourl
plocal:c:/orientdb-enterprise-2.2.0-beta/databases/listeriosi_naive -s
naive -nr java -v 2 -include
I have an csv
ratings.dat (http://files.grouplens.org/datasets/movielens/ml-100k.zip)
that contains this fields:
userID movieID rating
1 1 5
2 1 4
I imported with ETL the user class and movie class now i want to create
with ratings.csv edges
Hi Luca,
thank you for your repl I have created indexes against Movies.id and
Users.id:
User.json
{
config: {
log: info,
parallel: false
},
source: {
file: {
path: D:\\ETL\\users.dat
}
},
extractor: {
row: {
}
},
transformers: [{
csv: {
separator: ^,
columnsOnFirstLine: false,
columns: [id,
Hi Luca,
when I created Occupation class I have created an index on Occupation.id .
*[58:command] DEBUG executed command=sql.create edge rated from (select
from Users where id = $input.userId) to (select from Movies where id =
$input.movieId) set ratings = $input.ratings , rating_date =
This is the output of debug console:
[58:csv] DEBUG Transformer input: 2^648^4^978299913
[58:csv] DEBUG parsing=2^648^4^978299913
[58:csv] DEBUG document={userId:2,movieId:648,rating:4,timestamp:Mon Jan 12
08:44:59 CET 1970}
[58:csv] DEBUG Transformer output:
Solved! The problem are the variables. I changed $input.attribute in
${input.attribute}
Ratings.json
{
config: {
log: info,
parallel: false
},
source: {
file: {
path: D:\\ETL\\ratings.dat
}
},
extractor: {
row: {
}
},
transformers: [{
csv: {
separator: ^,
columnsOnFirstLine: false,
columns:
How i can split a field with ETL?
Example:
id,title,genres
1,Toy Story (1995),Animation|Children's|Comedy
2,Jumanji (1995),Adventure|Children's|Fantasy
3,Grumpier Old Men (1995),Comedy|Romance
I want genres as Array like as [Animation,Children's,Comedy].
I have tried with let blocks but i
Solved. I added split function(myString,separator) in my database then i
used let block.
Il giorno domenica 22 marzo 2015 17:37:41 UTC+1, Gianpaolo Altamura ha
scritto:
How i can split a field with ETL?
Example:
id,title,genres
1,Toy Story (1995),Animation|Children's|Comedy
2,Jumanji
Congratulations!
Il giorno martedì 27 maggio 2014 13:59:27 UTC+2, ste...@activitystream.com
ha scritto:
Congratulations!
On Tuesday, 27 May 2014 11:56:41 UTC, Lvc@ wrote:
Hi Riccardo,
I've just documented the PARALLEL keyword here:
You need to create role_id property as link.
Then you have to create edge with this instruction:
create edge enroll from #12:6 to #11:2 set role_id = (select from #13:2);
Then you can get role name in this way:
select role_id.name from enroll where out('enroll')=user_rid
Il giorno lunedì
You need to create role_id property as link.
Then you have to create edge with this instruction:
create edge enroll from #12:6 to #11:2 set role_id = (select from #13:2);
Then you can get role name in this way:
select role_id.name from enroll where out=user_rid
Il giorno lunedì 19 maggio
Hi all,
trying Gephi json exporter (localhost: 2480/gephi / ...) I saw that
directed property of edges is ever set to false.
I think that the problem is at line 149 of OServerCommandGetGephi.java
now it work ;)
Thank you very much.
Gianpaolo.
--
---
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,
Hi Luca,
i solved the problem with blueprint java API but I'm still trying a
solution that uses a query with Traverse command.
Unfortunatelly $path doesn't work like an array, but is a string. I need a
variable that point to the previous visited node and I think that I will
use $stack variable.
Hi Luca,
$history does not seem to be ordered and $stack is null. I have read that
i need to use $stack in java but i don't find examples or documentation.
Can you help me with some examples?
Thank you,
Gianpaolo.
--
---
You received this message because you are subscribed to the Google
Solved:
The correct query is
select name, out_.name , $b from A let $b=(select from out_ where
name=$parent.$current.name)
It's only a context problem...
Il giorno giovedì 24 aprile 2014 11:41:05 UTC+2, Gianpaolo Altamura ha
scritto:
Hi,
i have this scenario:
Vertex A where class
in_comments TYPE linkset FROM comment.postId To post.id
Lvc@
On 19 April 2014 09:48, Gianpaolo Altamura g.alt...@gmail.comjavascript:
wrote:
Can anyone help me?
Il giorno venerdì 18 aprile 2014 16:11:03 UTC+2, Gianpaolo Altamura ha
scritto:
Hi all,
I'm trying to create edges between two
Hi all,
I'm trying to create edges between two entities imported from RDBMS.
I'm following this tutorial:
https://github.com/orientechnologies/orientdb/wiki/Import-RDBMS-to-Graph-Model
But this command:
CREATE EDGE e FROM comment JOIN post ON postId = id INVERSE
doesn't work. I receive this
18 matches
Mail list logo